Owner's Manual

Reporting 179
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
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.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description