Owner's Manual

Reporting 193
OSMajorVersion nvarchar 16 Yes The major version of
the operating system.
OSMinorVersion nvarchar 16 Yes The minor version of
the operating system.
OSSPMajorVersion nvarchar 16 Yes The Service Pack
major version.
OSSPMinorVersion nvarchar 16 Yes The Service Pack
minor version.
SwitchDevice Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
SwitchIndex* int 4 No The index of the
switch.
SwitchAssetTag nvarchar 255 Yes The asset tag of the
switch.
SwitchServiceTag nvarchar 255 Yes The service tag of the
switch.
SwitchSerialNumber nvarchar 255 Yes The serial number of
the switch.
CostOfOwnership Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
CooIndex* int 4 No The index of the cost
of ownership.
PurchaseCost nvarchar 64 Yes The initial purchase
cost of the system.
WayBillNumber nvarchar 64 Yes The way bill number.
InstallationDate nvarchar 64 Yes The date that the
system was installed.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description