Users Guide

72 Reporting and Task Management
OSRevision nvarchar 64 Yes The revision of the operating
system (for example, the
Microsoft Windows
®
service
pack or the Linux kernel
version)
OSTotalPhysicalMemory int 4 Yes The total physical memory
reported by the operating
system in megabytes.
OSLocale nvarchar 64 Yes The locale for the operating
system.
OSType int 4 Yes The type of operating system.
PowerSupply Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
PowerSupplyChassisIndex* int 4 No This attribute defines the index
(one based) of the chassis.
PowerSupplyIndex* int 4 No This attribute defines the index
(one based) of the power
supply.
PowerSupplyType nvarchar 256 Yes This attribute defines the type
of the power supply.
PowerSupplyLocation nvarchar 256 Yes This attribute defines the
location of the power supply.
PowerSupplyOutputWatts int 4 Yes This attribute defines the
maximum sustained output
wattage of the power supply, in
tenths of watts.
Processor Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
ProcessorChassisIndex* int 4 No This attribute defines the index
(one based) of the chassis.
ProcessorCores int 4 Yes This attribute defines the
number of processor cores
detected for the processor
device.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description