89 mvc_assetsummary – HP Storage Essentials Enterprise Edition Software User Manual
Page 520
Running Reports
482
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”