Users Guide

64 Reporting and Task Management
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
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.
DeviceLocation nvarchar 256 Yes The device location as retrieved
from the remote agent.
DellSystem int 4 Yes The Boolean flag indicating if
the device is a Dell enabled
agent.
SubnetLastDiscoveredOn nvarchar 256 Yes The last discovery range that
was used to discover the device.
Agent Table
DeviceId* int 4 No Foreign Key to the Device
Ta b l e.
AgentName* nvarchar 256 No The name of the agent.
AgentVersion nvarchar 64 Yes The version of the agent.
AgentManufacturer nvarchar 64 Yes The manufacturer of the agent.
AgentDescription nvarchar 256 Yes A brief description of what the
agent manages.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description