Owner's Manual

174 Reporting
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
DeviceAssetTag nvarchar 64 Yes This attribute defines
the device’s asset tag.
DeviceServiceTag nvarchar 64 Yes This attribute defines
the device’s service tag.
DeviceSystemId int 4 Yes The manufacturer’s ID
for the system model.
DeviceSystemModelType nvarchar 64 Yes The manufacturer’s
model name.
Table 10-3. IT Assistant Database Schema (continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description