Owner's Manual

Reporting 197
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 Table.
OSVendor nvarchar 64 Yes The operating system
vendor name.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description