Owner's Manual

Reporting and Task Management 75
PCISlots nvarchar 64 Yes The status of the system's add-in
PCI slots (enabled/disabled).
USBPorts nvarchar 64 Yes The status of the USB ports
(on/off).
SoftwareInventory Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
ComponentId nvarchar 64 Yes The component identifier for
the software.
InstanceId* nvarchar 32 No The instance identifier for the
hardware.
HWDeviceId nvarchar 16 Yes The hardware device identifier
of the PCI ID.
HWVendorId nvarchar 16 Yes The hardware vendor identifier
of the PCI ID.
HWSubDeviceId nvarchar 16 Yes The hardware subdevice
identifier of the PCI ID.
HWSubVendorId nvarchar 16 Yes The hardware subvendor
identifier of the PCI ID.
SubComponentId nvarchar 64 Yes The subcomponent identifier
for the hardware.
HWDescription nvarchar 128 Yes The description of the
hardware.
SoftwareType nvarchar 64 Yes The type of software, for
example, driver (DRVR),
firmware (FRMW), and so on.
SoftwareVersion nvarchar 64 Yes The software version number.
SoftwareDescription nvarchar 128 Yes The description of the software.
SoftwareInventoryOS Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
OSVendor nvarchar 64 Yes The operating system vendor
name.
OSMajorVersion nvarchar 16 Yes The major version of the
operating system.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description