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

Running Reports484
RESELLER VARCHAR2(255) Asset Reseller
COMMENTS VARCHAR2(4000) Comments
ASSETFIXCOSTTAXPERDEPTPE
RYEAR
NUMBER Asset Fixed cost tax per department per
Year
STORAGFIXCOSTTAXPERDEPT
PERYEAR
NUMBER Storage Fixed cost tax per department per
Year
Table 89 MVC_ASSETSUMMARY (continued)
Column Name Type Description
Table 90 MVC_APPLICATIONSUMMARYVW
Column Name Type Description
APPLICATIONID NUMBER(38) Application ID
APPLICATIONNAME VARCHAR2(256) Application Name
DOMAINID NUMBER(38) Domain ID
APPLICATIONTYPE NUMBER(38) Application type
VENDOR VARCHAR2(254) Vendor
DESCRIPTION VARCHAR2(1024) Description of the application
STATUS NUMBER(38) Operational status
BUILDNUMBER VARCHAR2(254) Software build number
SERIALNUMBER VARCHAR2(254) Software serial number
TARGETOS VARCHAR2(254) Target operating system
PRODUCTNAME VARCHAR2(254) Product name
VERSION VARCHAR2(254) Software version
IDENTIFICATIONCODE VARCHAR2(254) Software identification code
SOFTWAREELEMENTID VARCHAR2(254) Software element ID
HOSTID NUMBER(38) ID of host where the application is running
from