2.39 NC_Workstation Table

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

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.

Notes