ID | Int | 4 | | Y | |
ComputerName | nvarchar | 50 | | Y | Computer name of the workstation. |
MacAddress | nvarchar | 50 | | Y | MAC address of the workstation ( example: 00:04:75:c2:f2:3e Note This value must be unique in the database |
AssetTag | nvarchar | 50 | Y | | Asset tag of the workstation. |
SerialNumber | nvarchar | 50 | Y | | Serial number of the workstation |
Make | nvarchar | 50 | Y | | Manufacturer of the workstation |
Model | nvarchar | 50 | Y | | Model number of the workstation. |
UDShare | nvarchar | 255 | Y | | UNC path to the share where user data is stored. |
UDDir | nvarchar | 255 | Y | | Existing computer name (used to make folder beneath UDShare). |
UDProfiles | nvarchar | 255 | Y | | Name of user profile being migrated. |
SLShare | nvarchar | 255 | Y | | UNC path to the share where ZTI script creates log files. |
TimeZone | nvarchar | 50 | Y | | Time zone where workstation will be deployed |
AdminPassword | nvarchar | 50 | Y | | Password to be assigned to local administrator account on workstation. |
DomainAdmin | nvarchar | 50 | Y | | Domain-based account name that is a member of the Domain Administrators group. |
DomainAdminPassword | nvarchar | 50 | Y | | Password for the domain-based account. |
JoinDomain | nvarchar | 50 | Y | | Domain name that the workstation will join. |
MachineObjectOU | nvarchar | 255 | Y | | Active Directory OU where the machine account will be created. |
JoinWorkGroup | nvarchar | 50 | Y | | Workgroup name that the workstation will join. |
FullName | nvarchar | 50 | Y | | User name configured on the workstation. |
OrgName | nvarchar | 50 | Y | | Organization name to be configured on the workstation. |
Command0 | nvarchar | 255 | Y | | Obsolete field that is no longer used by the ZeroTouchInstallation.vbs. |
OsdInstallSilent | char | 1 | Y | | Indicates if the SMS 2003 OSD Feature Pack image installation wizard should be displayed (1 in this field indicates the wizard will not be displayed). |
OsdInstallPackage | nvarchar | 255 | Y | | Unique ID of the OS Deployment package that the OS Image Installation CD or RIS should install. This is set by the custom program or script specified in the Operating System Image Installation CD Wizard |
OsdInstallProgram | nvarchar | 255 | Y | | Name of the OS Deployment Program that the OS Image Installation CD or RIS should install. This is set by the custom program or script specified in the Operating System Image Installation CD Wizard |
OsdNewMachineName | nvarchar | 255 | Y | | Name to assign to the computer when the new operating system is installed. This variable is used in the new computer and replace computer installation scenarios when running the OS Image Installation CD or from RIS. In a refresh computer scenario, ZTI can rename the machine by including the “ComputerName=%OSDNEWMACHINENAME% line in the default section. |
OsdStatePath | nvarchar | 255 | Y | | Path where OSD stores user state migration information. |
OSInstall | char | 1 | | Y | Flag monitored by ZeroTouchInstallation.vbs to determine of the script should continue to run. If set to False, ZeroTouchInstallation.vbs |
AdminUser | nvarchar | 255 | | Y | Indicates the username who added or last modified the record. |
