Owner's Manual

208 Reporting
Tape Dri ve Ta b le
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 Lib r ary Tabl e
DeviceId* int 4 No The Foreign Key to the
Device Table.
Ta p e L i b r a r y I n d e x * int 4 No The tape library index.
Ta p e L i b r a r y Ve n d o r nvarchar 64 Yes Name of the tape
library vendor.
Ta p e L i b r a r y M o d e l nvarchar 64 Yes Name of the tape
library model.
TapeLibraryFirmwareVersion nvarchar 32 Yes Firmware version of
the tape library.
Ta p e L i b r a r y D r i v e C o u n t int 4 Yes The number of drives.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description