HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Not standard; a text description of the hardware
location, on complex multi-SBB hardware only, for
the element
NVARCHAR(256)dc_HWLocation
The product ID string of the server bladeNVARCHAR(64)dc_ProductID
CIM_PhysicalMedia table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPhysicalMedia_LUID
Node partly identifies CIM_PhysicalMediaBIGINTNodeID
Snapshot partly identifies CIM_PhysicalMediaBIGINTSnapshotID
CreationClassName partly identifies
CIM_PhysicalMedia; equates to CIM_PhysicalMedia
NVARCHAR(256)CreationClassName
Inherited from CIM_PhysicalElement.Tag; an arbitrary
string that uniquely identifies the Physical Element
NVARCHAR(256)Tag
and serves as the Element's key, can contain
information such as asset tag or serial number data
Specifies the type of the PhysicalMedia, as an
enumerated integer (The MediaDescription property
SMALLINTMediaType
is used to provide more explicit definition of the
Media type, whether it is pre-formatted, compatability
features and so on. CIM_PhysicalMedia.MediaType
enumeration. 0 = Unknown, 1 = Other, 2 = Tape,
3 = QIC Cartridge, 4 = AIT Cartridge, 5 = DTF
Cartridge, 6 = DAT Cartridge, 7 = 8mm Tape
Cartridge, 8 = 19mm Tape Cartridge, 9 = DLT
Cartridge, 10 = Half-Inch Magnetic Tape Cartridge,
11 = Cartridge Disk, 12 = JAZ Disk, 13 = ZIP Disk,
14 = SyQuest Disk, 15 = Winchester Removable
Disk, 16 = CD_ROM, 17 = CD_ROM/XA, 18 =
CD-I; 19, 19 = Recordable, 20 = WORM, 21 =
Magento-Optical, 22 = DVD, 23 = DVD-RW+, 24
= DVD-RAM, 25 = DVD-ROM, 26 = DVD-Video, 27
= Divx, 28 = Floppy/Diskette, 29 = Hard Disk, 30
= Memory Card, 31 = Hard Copy, 32 = Clik Disk,
33 = CD-RW, 34 = CD-DA, 35 = CD+, 36 = DVD
Recordable, 37 = DVD-RW, 38 = DVD-Audio, 39 =
DVD-5, 40 = DVD-9, 41 = DVD-10, 42 = DVD-18,
43 = Magneto-Optical Rewriteable, 44 =
Magneto-Optical Write Once, 45 = Magneto-Optical
Rewriteable (LIMDOW), 46 = Phase Change Write
Once, 47 = Phase Change Rewriteable, 48 = Phase
Change Dual Rewriteable, 49 = Ablative Write
Once, 50 = Near Field Recording, 51 = MiniQic,
52 = Travan, 53 = 8mm Metal Particle, 54 = 8mm
Advanced Metal Evaporate, 55 = NCTP, 56 = LTO
Ultrium, 57 = LTO Accelis, 58 = 9 Track Tape, 59
= 18 Track Tape, 60 = 36 Track Tape, 61 = Magstar
3590, 62 = Magstar MP, 63 = D2 Tape, 64 = Tape,
DST Small , 65 = Tape, DST Medium, 66 = Tape,
DST Large)
The number of bytes that can be read from or written
to a Media (This property is not applicable to \"Hard
BIGINTCapacity
Copy\" (documentation) or cleaner Media. Data
compression should not be assumed because it would
increase the value in this property. For tapes, it
Database tables 29