HP Storage Essentials NAS Manager Software - Manual (Page 554)

Running Reports 522
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”
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