ComponentOID |
PK |
binary(16) |
No |
An internal ID number used as a primary key. |
WorkstationOID |
FK |
binary(16) |
No |
The workstation with which the component is associated. |
ProductOID |
FK |
binary(16) |
No |
The product as identified by the Collector. |
ProductAlias |
FK |
binary(16) |
No |
The product as edited by the user. |
ProductType |
|
smallint |
No |
The product type. See "Notes" in "NC_Product Table." |
Collector |
|
smallint |
|
The list is:
- 0 Win32
- 1 OS/2
- 2 DOS
- 3 UNIX
- 4 Palm OS
- 5 OS X
|
Source |
|
smallint |
|
The source of the component:
- 0 Novell Defined
- 1 Collector
- 2 Field Editor
- 3 ZENworks Control Center
- 4 Translator/Migrator
- 5 Palm Translator
- 6 UNIX Translator
- 7 OS X Translator
|
SerialNumber |
|
nvarchar(38) |
|
The serial number as discovered by the Collector. |
AssetTag |
|
nvarchar(38) |
|
The asset tag as discovered by the Collector. |
SerialNumberAlias |
|
nvarchar(38) |
|
The serial number as provided by the user. |
AssetTagAlias |
|
nvarchar(38) |
|
The asset tag as provided by the user. |
ModelNumber |
|
nvarchar(32) |
|
The model number. |
CreateDate |
|
DateTime |
No |
The date the component was first discovered. |
DateLastModified |
|
DateTime |
No |
The date the component was last changed. |
IsDeleted |
|
DateTime |
|
The date and time the record was deleted; else null. |
ExcludedNonColl |
|
Tinyint |
Yes |
0 |
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" |
IsRetired |
|
DateTime |
|
The date and time the record was retired; else null. |