Owner's Manual

184 Reporting
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
has 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 The Foreign Key (FK)
to the Device Table.
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.
AgentGlobalStatus int 4 Yes The global status of
the agent.
Not Known = 0
Unknown = 2
Normal = 4
War ning = 8
Critical = 16
AgentInstallTime datetime 8 Yes The time the agent
was installed, if
available.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description