Users Guide

Reporting and Task Management 71
MemoryDeviceBankName nvarchar 256 Yes This attribute defines the
location of the bank for the
memory device.
MemoryDeviceType nvarchar 256 Yes This attribute defines the type
of the memory device.
MemoryDeviceFormFactor nvarchar 256 Yes This attribute defines the form
factor of the memory device.
MemoryDeviceSize int 4 Yes This attribute defines the size
of the memory device.
MemoryDeviceFailureMode nvarchar 256 Yes This attribute defines the
failure mode of the memory
device.
NIC Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
NICId* int 4 No The unique instance ID of the
NIC.
NICIPAddress nvarchar 40 Yes The IP address assigned to the
NIC.
NICNetmask nvarchar 40 Yes The subnet mask assigned to
the NIC.
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
Ta b l e.
OSId* int 4 No The instance ID for the
operating system.
OSName nvarchar 64 Yes The name of the operating
system.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description