WorkstationOID |
PK |
binary(16) |
No |
An internal ID number used as a primary key. |
ZenWorksAgentId |
|
binary (16) |
|
The identification for the ZENworks Adaptive Agent installed on this workstation. |
UnManagedAgentId |
|
binary (16) |
|
The identification for an unmanaged agent. |
MachineName |
|
nvarchar(32) |
|
The machine name. See "Notes" below. |
InventoryType |
|
smallint |
No |
The type of inventory: 0=Workstation, 1=Server, 2=Stockroom, 3=Lost and Found, 4= Portable, 5=NetCensus, 6=Manually-entered Workstation, 7=Workstation Not Yet Scanned, 8=UNIX, 9=PDA. |
LoginName |
|
nvarchar(32) |
|
The user’s logon name. See "Notes" below. |
Site |
|
nvarchar(32) |
|
The site of the workstation. |
Dept |
|
nvarchar(32) |
|
The department to which the workstation belongs. |
CostCenter |
|
nvarchar(32) |
|
The cost center to which the workstation belongs. |
Building |
|
nvarchar(32) |
|
The building in which the workstation resides. |
Floor |
|
nvarchar(10) |
|
The floor on which the workstation resides. |
Room |
|
nvarchar(32) |
|
The number of the room. |
Phone |
|
nvarchar(32) |
|
The telephone number at the workstation. |
TotalMemory |
|
int |
|
The total system memory. |
TotalHardDiskSpace |
|
Float |
|
The total space on the hard disk. |
FreeHardDiskSpace |
|
Float |
|
The total free space on the hard disk. |
LastScanId |
|
binary(16) |
|
|
LastSuccessfulScanDate |
|
DateTime |
|
The date and time of the last successful scan of the workstation. |
LastSuccessfulLoadDate |
|
DateTime |
|
The date and time of the last successful load of inventory from the workstation. |
LastUsageGatherDate |
|
DateTime |
|
Reserved for internal use. |
LANAddress |
|
nvarchar(12) |
|
The LAN address from the LAN adapter. |
IPAddress |
|
nvarchar(15) |
|
The IP address from the LAN adapter. |
SubnetMask |
|
nvarchar(15) |
|
The subnet mask from the LAN adapter. |
DefaultGateway |
|
nvarchar(15) |
|
The default gateway from the LAN adapter. |
WkstnDomain |
|
nvarchar(64) |
|
The workstation domain. |
SerialNumber |
|
nvarchar(38) |
|
The serial number of the system component. |
AssetTag |
|
nvarchar(38) |
|
The asset tag of the system component. |
IsLeased |
|
smallint |
No |
1 (TRUE) if the machine is leased; else 0. |
LeaseExpireDate |
|
DateTime |
|
Lease expiration date. |
LeaseContractId |
|
VarChar(20) |
|
The contract ID of the lease. |
AccountId |
|
varbinary(16) |
|
The account identification. |
CreateDate |
|
DateTime |
No |
The date and time the workstation was added. |
DateLastModified |
|
DateTime |
No |
The date and time the workstation was last modified. |
IsDeleted |
|
DateTime |
|
Used to record the date when a workstation is marked as retired. |
CPUSpeed |
|
float |
|
The CPU speed. |
CPUProduct |
|
DateTime |
|
The product name of the CPU. |
CPUCount |
|
smallint |
|
The number of CPUs in the workstation. |
SystemManufacturer |
|
nvarchar(35) |
|
The system manufacturer. |
SystemProduct |
|
nvarchar(100) |
|
The system product name. |
SystemModel |
|
nvarchar(25) |
|
The system model. |
SystemChassis |
|
smallint |
|
The type of system chassis. See the chassis type listing under the NC_System table. |
OSManufacturer |
|
nvarchar(35) |
|
The operating system manufacturer. |
OSProduct |
|
nvarchar(100) |
|
The operating system product name. |
OSModel |
|
nvarchar(25) |
|
The operating system model number. |
OSServicePack |
|
nvarchar(8) |
|
The operating system service pack level. |
OSBuild |
|
nvarchar(8) |
|
The operating system build number. |
ScannedSerialNumber |
|
nvarchar(38) |
|
The scanned serial number for the workstation. |
CalculatedPrimaryUser |
|
nvarchar(128) |
|
The calculated primary user from an authoritative source. |
ADF0 |
|
nvarchar(256) |
|
Description of "Administrator Defined Field 0" |
ADF1 |
|
nvarchar(256) |
|
Description of "Administrator Defined Field 1" |
ADF2 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 2" |
ADF3 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 3" |
ADF4 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 4" |
ADF5 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 5" |
ADF6 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 6" |
ADF7 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 7" |
ADF8 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 8" |
ADF9 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 9" |
ADF10 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 10" |
ADF11 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 11" |
ADF12 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 12" |
ADF13 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 13" |
ADF14 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 14" |
ADF15 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 15" |
ADF16 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 16" |
ADF17 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 17" |
ADF18 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 18" |
ADF19 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 19" |
PrimaryUserOID |
FK1,l2 |
binary(16) |
|
ID to link in entered user information from NC_User. |