Novell Doc: ZENworks 10 Configuration Management Services Reference - NC_System Table

2.34 NC_System Table

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.

Notes

The ComponentOID foreign key references the ComponentOID primary key column of the NC_Component 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