The NC_System table contains inventory data about systems.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK, FK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
ChassisType |
smallint |
The type of chassis. See "Notes" below. |
||
|
ThermalState |
smallint |
The thermal state. See "Notes" below. |
||
|
CoverRemoved |
DateTime |
The CPU cover has been removed. |
||
|
Fingerprint |
Varbinary(255) |
The fingerprint used to identify the system. |
NOTE:
The ComponentOID foreign key references the ComponentOID primary key column of the NC_SystemComp table.
The ChassisType can have one of the following values:
|
0 |
Out of Range |
13 |
All in One |
|
1 |
Other |
14 |
Sub Notebook |
|
2 |
Unknown |
15 |
Space-saving |
|
3 |
Desktop |
16 |
Lunch Box |
|
4 |
Low Profile Desktop |
17 |
Main Server Chassis |
|
5 |
Pizza Box |
18 |
Expansion Chassis |
|
6 |
Mini Tower |
19 |
SubChassis |
|
7 |
Tower |
20 |
Bus Expansion Chassis |
|
8 |
Portable |
21 |
Peripheral Chassis |
|
9 |
Laptop |
22 |
RAID chassis |
|
10 |
Notebook |
23 |
Rack Mount Chassis |
|
11 |
Hand Held |
24 |
Sealed-case PC |
|
12 |
Docking Station |
ThermalState can have one of the following values:
|
0 |
Out of range |
|
1 |
Other |
|
2 |
Unknown |
|
3 |
Safe |
|
4 |
Warning |
|
5 |
Critical |
|
6 |
Non-recoverable |