Users Guide

Reporting and Task Management 63
IT Assistant Database Schema Information
The rows in the Device table represent the devices in the network. IT Assistant gathers data that is stored
in associated tables and is linked by the DeviceId, an internal identifier.
The associated data is stored in the following tables.
NOTE: The primary keys for the tables are marked with an asterisk (*).
Table 5-2. IT Assistant Database Schema
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description
Device Table
DeviceId* int 4 No Internal device identification
used as a foreign key in all
related tables.
DeviceName nvarchar 256 Yes The name IT Assistant uses to
identify the device, which is the
name shown in the Device Tree
in the User Interface (UI).
DeviceInstrumentationName nvarchar 256 Yes The name of the device
retrieved from the MIB II
SysName or CIM.
DeviceDNSName nvarchar 256 Yes ComputerSystemName
DeviceType int 4 Yes The type of device.
Workstations = 3
Servers = 4,
Desktops = 5
Portables = 6
Network Switches = 8
RACs = 9
KVMs = 10
Unknown = 2 or any value not
listed
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.