Owner's Manual

178 Reporting
DeviceType int 4 Yes The type of device.
Workstations = 3
Servers = 4
Desktops = 5
Portables = 6
Network Switches = 8
RACs = 9
KVMs = 10
Unknown = 2 or any
value not listed
DeviceInventoryTime datetime 8 Yes The last time that IT
Assistant collected
inventory data from
the device.
DeviceStatusedTime datetime 8 Yes The last time that IT
Assistant collected the
global health data from
the device.
DeviceDiscoveredTime datetime 8 Yes The last time IT
Assistant interrogated
the system to
determine what agents
were present.
DeviceProtocols int 4 Yes Bitmask indicating
what protocols the
device supported.
Bit 1 = SNMP
Bit 4 = CIM
Bit 8 = IPMI
DevicePreferredProtocol int 4 Yes The protocol by which
the remote device
prefers to be managed.
1 = SNMP
2 = CIM
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description