Owner's Manual

182 Reporting
IT Assistant Database Schema Information
IT Assistant gathers data that is stored in associated tables and is linked by
the DeviceID, an internal identifier. Table 10-3 lists the IT Assistant
Database Schema.
NOTE: The primary keys for the tables are marked with an asterisk (*).
Table 10-3. IT Assistant Database Schema
Column Name Data Type 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 Fully qualified name as
returned by the DNS
Server
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