Owner's Manual
Reporting 197
PowerSupply Table
DeviceId*
int 4 No The Foreign Key to the
Device Table.
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.
PowerSupplyMonitorCapable
nvarchar 64 Yes This attribute defines
the capability of the
power supply monitor.
Processor Table
DeviceId*
int 4 No The Foreign Key to the
Device Table.
ProcessorChassisIndex*
int 4 No This attribute defines
the index (one based)
of the chassis.
ProcessorIndex*
int 4 No This attribute defines
the index (one based)
of the processor.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description