Owner's Manual

Reporting 199
Tap e Dr ive Tabl e
DeviceId* int 4 No The Foreign Key to the
Device Table.
Ta p e D r i v e I n d e x * int 4 No The tape drive index.
TapeDriveVendor nvarchar 64 Yes Name of the tape drive
vendor.
Ta p e D r i v e M o d e l nvarchar 64 Yes Name of the tape drive
model.
Ta p e D r i v e Ty p e nvarchar 64 Yes The tape drive type.
TapeDriveFirmwareVersion nvarchar 32 Yes Firmware version of
the tape drive.
TapeDriveSerialNumber nvarchar 32 Yes Serial number of the
tape drive.
Ta p e D r i v e W M N nvarchar 32 Yes WMN for the tape
drive.
TapeDriveCleaningRequired nvarchar 32 Yes Specifies whether the
tape drive requires
cleaning.
Tape Library Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
TapeLibraryIndex* int 4 No The tape library index.
TapeLibraryVendor nvarchar 64 Yes Name of the tape
library vendor.
TapeLibraryModel nvarchar 64 Yes Name of the tape
library model.
TapeLibraryFirmwareVersion nvarchar 32 Yes Firmware version of
the tape library.
TapeLibraryDriveCount int 4 Yes The number of drives.
Table 10-3. IT Assistant Database Schema (continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description