HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Running Reports522

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

VARCHAR2(255) Asset storage Tier Name for example

“Ultra High Availability”

STORAGETIERCOSTPERGB NUMBER(36,2) Asset storage Tier cost

DEPARTMENTNO VARCHAR2(255) Asset department no

DEPARTMENTNAME VARCHAR2(255) Asset department Name

PERCENTAGEOWNED NUMBER(5, 2) Percentage owned by Department

ADMINISTRATOR VARCHAR2(255) Asset maintained by

STAFFNAME VARCHAR2(255) Staff Name

STAFFPHONENUMBER VARCHAR2(255) Staff PH#

STAFFDEPARTMENT VARCHAR2(255) Staff Department

STAFFEMAIL VARCHAR2(255) Staff E-mail

RACKNUMBER VARCHAR2(100)

FLOOR VARCHAR2(100)

DATACENTER VARCHAR2(100)

CITY VARCHAR2(100)

REGION VARCHAR2(100)

COUNTRY VARCHAR2(50)

CONTINENT VARCHAR2(20)

ADDRESS VARCHAR2(1024)

ZIPCODE VARCHAR2(16)

LICENSE VARCHAR2(4000)

PURCHASEORDERNUMBER VARCHAR2(255) Asset Purchase Order no

Table 106 MVC_ASSETSUMMARY (continued)

Column Name Type Description