Owner's Manual

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