beautypg.com

89 mvc_assetsummary – HP Storage Essentials Enterprise Edition Software User Manual

Page 520

background image

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”

This manual is related to the following products: