Owner's Manual

Reporting 187
NICMACAddress nvarchar 24 Yes The MAC address of
the NIC.
NICManufacturer nvarchar 256 Yes The reseller of the
NIC.
NICPingable int 4 Yes A flag indicating that
IT Assistant
communicates with
the device using this IP
address.
Operating System Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
OSId* int 4 No The instance ID for
the operating system.
OSName nvarchar 64 Yes The name of the
operating system.
OSRevision nvarchar 64 Yes The revision of the
operating system (for
example, the Microsoft
Windows® service
pack or the Linux
kernel version)
OSTotalPhysicalMemory int 4 Yes The total physical
memory reported by
the operating system in
megabytes.
OSLocale nvarchar 64 Yes The locale for the
operating system.
OSType int 4 Yes The type of operating
system.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description