Users Guide

68 Reporting and Task Management
Enclosure Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
EnclosureNumber* int 4 No The instance number of the
enclosure entry.
EnclosureName nvarchar 256 Yes The enclosure's name.
EnclosureVendor nvarchar 256 Yes The enclosure's reseller's name.
EnclosureId int 4 Yes The SCSI address of the
processor.
EnclosureServiceTag nvarchar 64 Yes The enclosure identification
used when consulting customer
support.
EnclosureAssetTag nvarchar 64 Yes The user-definable asset tag for
the enclosure.
EnclosureAssetName nvarchar 64 Yes The user-definable asset name
for the enclosure.
EnclosureProductId nvarchar 64 Yes The enclosure's product
identification, which also
corresponds to the enclosure
type.
EnclosureType nvarchar 64 Yes The type enclosure.
EnclosureChannelNumber int 4 Yes The channel number, or bus, to
which the enclosure is
connected.
EnclosureBackplanePartNum nvarchar 64 Yes The part number of the
enclosure's backplane.
EnclosureSCSIId int 4 Yes The SCSI ID of the controller
to which this enclosure is
attached.
Enclosure Management Module Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
EMMNumber* int 4 No The instance number of the
enclosure management module.
EMMName nvarchar 256 Yes The name of the enclosure.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description