HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Running Reports482
ContainerExtentID NUMBER Container Extent ID
DiskID NUMBER Disk Drive ID
Table 88 MVC_DISK_EXTENTVW (continued)
Column Name Type Description
Table 89 MVC_ASSETSUMMARY
Column Name Type Description
DOMAINID NUMBER(38) Domain ID
ASSETID NUMBER(38) ID of the Asset depending on Assetclass for
example if the assetclass is Host then this is
host.id
ASSETCLASS VARCHAR2(13) The Asset class are “HOST”,
“APPLICATION”, “STORAGESYSTEM” or
“SWITCH”
NAME VARCHAR2(256) Name of the Host for example in case of
Host this host name.
DATECREATED DATE Creation Date
DATELASTMODIFIED DATE Date last modified.
DESCRIPTION VARCHAR2(255) Asset description
STATUS VARCHAR2(8) Asset status. Can be 'NEW', 'MISSING',
'REPAIRED', 'IN USE'
VENDOR VARCHAR2(254) Asset Vendor
MODEL VARCHAR2(254) Asset Model
SERIALNUMBER VARCHAR2(254) Asset serial number
BARCODE VARCHAR2(255) Asset bar code
ASSETCODE VARCHAR2(255) Asset code
ASSETTYPE VARCHAR2(255) Asset type
ASSETTAG VARCHAR2(255) Asset Tag
ASSETCATEGORY VARCHAR2(255) Asset Category
GEOGRAPHICLOCATION VARCHAR2(255) Asset location
STORAGETIERCLASSIFICATIO
N
VARCHAR2(255) Asset storage Tier Name for example “Ultra
High Availability”