Users Guide

76 Reporting and Task Management
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
Ta b l e.
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
Ta b l e.
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.
PurchaseOrderNumber nvarchar 64 Yes The purchase order number.
PurchaseDate nvarchar 64 Yes The date that the system was
purchased.
SigningAuthorityName nvarchar 64 Yes The signing authority reference.
OriginalMachineConfigurationExpensed nvarchar 64 Yes The original system
configuration that was
expensed.
OriginalMachineConfigurationVendor
Name
nvarchar 64 Yes The original system
configuration vendor name.
CostCenterInformationVendorName nvarchar 64 Yes The cost center information
vendor name.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description