The NC_Workstation table tracks workstation inventory data.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
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 |
True(1) indicates 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. |
NOTE:
MachineName and LoginName are obtained from the network. If more than one network is available, the order used is Windows network, NetWare, and NetBIOS.
The PrimaryUserOID foreign key references the UserOID primary key column of the NC_User table.