HP Matrix Operating Environment Chargeback

ManualsBrandsHP ManualsSoftwareHP Matrix Operating Environment w/Insight Control 24x7 Supp Flexible Lic

Technical white paper

HP Matrix Operating Environment

Chargeback

Creating customized reports based on CLI output files

Table of contents

Introduction .................................................................................................................................................................................... 2

Chargeback usage report ............................................................................................................................................................ 2

Accessing the source data ........................................................................................................................................................... 4

Command-line Tool .................................................................................................................................................................. 4

API................................................................................................................................................................................................. 8

Understanding the chargeback output data ........................................................................................................................... 8

“get detailedusage” XML elements ....................................................................................................................................... 8

List of service allocation data ................................................................................................................................................. 9

Service information ................................................................................................................................................................ 10

Resource usage detail ............................................................................................................................................................ 10

Creating formatted reports ....................................................................................................................................................... 12

Learning the basic XSLT elements ...................................................................................................................................... 12

Creating a sample formatter ................................................................................................................................................ 13

Creating a report to show only service name, date, and service fixed cost ............................................................... 14

Adding attributes to an existing report .............................................................................................................................. 14

Creating a report to show all detailed service allocation metrics per day ................................................................. 15

Applying the formatter to the source data ............................................................................................................................ 17

Adding stylesheet tag to the source XML file ................................................................................................................... 17

Opening the XML as a report in Microsoft Excel 2007 .................................................................................................... 17

Opening the XML as a report in Internet Explorer ........................................................................................................... 18

For more information ................................................................................................................................................................. 20

Summary of content (20 pages)

PAGE 1
Technical white paper HP Matrix Operating Environment Chargeback Creating customized reports based on CLI output files Table of contents Introduction .................................................................................................................................................................................... 2 Chargeback usage report .........................................................................................................................................................
PAGE 2
Technical white paper | HP Matrix Operating Environment Chargeback Introduction HP CloudSystem Matrix infrastructure orchestration added chargeback support in version 7.1. Chargeback is a metering system capable of collecting and exposing allocation usage data for provisioned infrastructure. For more information about chargeback, see the HP Matrix Operating Environment Infrastructure Orchestration User Guide at www.hp.com/go/matrixoe/docs.
PAGE 3
Technical white paper | HP Matrix Operating Environment Chargeback Figure 2. Report containing all allocation metrics displayed in Internet Explorer Note Matrix infrastructure orchestration version 7.3 (API version 3) added the element to IP addresses.
PAGE 4
Technical white paper | HP Matrix Operating Environment Chargeback Accessing the source data Command-line Tool The XML data containing usage and cost metrics can be generated by executing chargeback command-line interface (CLI) commands. The CLI tool, chargeback\chargeback.bat, allows users to restrict the search using parameters such as start date, end date, and filters such as service name, billing code, service owner, and organization.
PAGE 5
Technical white paper | HP Matrix Operating Environment Chargeback Use the following commands to obtain more information about chargeback archive operations: chargeback archive databaseexport –help chargeback archive databasedelete –help chargeback archive executionhistory –help Getting usage data Following is an example of using the CLI operation “get usage” to retrieve summary usage data for each day in the reporting period. Figure 3.
PAGE 6
Technical white paper | HP Matrix Operating Environment Chargeback Getting aggregated usage data An example of using the CLI operation “get aggregatedusage” to retrieve summary usage data, aggregated for all days in the reporting period. Figure 5. Chargeback CLI command to retrieve aggregated summary usage data C:\Program Files\HP\Matrix infrastructure orchestration\chargeback\bin>chargeback.
PAGE 7
Technical white paper | HP Matrix Operating Environment Chargeback Figure 8. Detailed service usage data XML 2012-04-13 0.1190 8.7528 false Disk1-1 0.0977 0.
PAGE 8
Technical white paper | HP Matrix Operating Environment Chargeback API The CLI tool uses the infrastructure orchestration chargeback SOAP API, which is used to programmatically retrieve XML encoded chargeback data.
PAGE 9
Technical white paper | HP Matrix Operating Environment Chargeback Table 1.
PAGE 10
Technical white paper | HP Matrix Operating Environment Chargeback Figure 9. XML ServiceUsageDetail list 2014-04-01 … 2014-04-02 … … Service information The element contains the allocation data metrics for one specific service per day, as indicated by the element.
PAGE 11
Technical white paper | HP Matrix Operating Environment Chargeback Servers The list of servers is represented by the element. In this list, each server is represented by the element. Figure 12 shows a partial example of an XML file containing server allocation metrics. Figure 12. XML element containing server metrics 2.4315 8.
PAGE 12
Technical white paper | HP Matrix Operating Environment Chargeback IpAddresses The list of IP addresses is represented by the element. In this list, each IP is represented by the element. Figure 14 shows a partial example of an XML file containing IP allocation metrics. Figure 14. XML element containing IP allocation metrics 0.1217 8.
PAGE 13
Technical white paper | HP Matrix Operating Environment Chargeback XSLT Element Description Extracts the value of a specified node. The following example gets data of the specified node: The select attribute contains an XPath expression that specifies which node to extract the value. Declares a variable.
PAGE 14
Technical white paper | HP Matrix Operating Environment Chargeback Figure 16. Minimal Excel report containing formatted text Creating a report to show only service name, date, and service fixed cost The following example shows a report displaying only a few attributes such as service name, metric date, and the service fixed cost. The XSLT allows only the desired information to show in the reports.
PAGE 15
Technical white paper | HP Matrix Operating Environment Chargeback To display these new attributes, it is important to understand where the desired attributes are located in the source XML structure. In this case, the attributes are located inside the element under each service that is represented by the element. The following elements need to be added to the XSL file to display the new attributes.
PAGE 16
Technical white paper | HP Matrix Operating Environment Chargeback Figure 21. XSL transformation to show all detailed service allocation metrics per day PAGE 17
Technical white paper | HP Matrix Operating Environment Chargeback

Applying the formatter to the source data An XML stylesheet instruction must be inserted at the top of the source XML file, just after the first XML tag, to indicate to the web browser or Excel application that it should apply the XML transformations defined in the XSL file when rendering the XML document.
PAGE 18
Technical white paper | HP Matrix Operating Environment Chargeback Figure 24. Excel dialog for opening the resulting HTML file The report is displayed in Excel as shown below. It is the result of the application of the XSL defined in Figure 21 to the source XML allocation data shown in Figure 8. Figure 25. Excel report containing all allocation metrics The Excel file is in read-only mode. Therefore, it is important to save it under a different name.
PAGE 19
Technical white paper | HP Matrix Operating Environment Chargeback Figure 26.
PAGE 20
For more information Resources, contacts, or additional links For more information about HP Matrix OE infrastructure orchestration including using the chargeback feature, see the HP Matrix Operating Environment Infrastructure Orchestration User Guide: www.hp.com/go/matrixoe/docs For the complete description of the chargeback API and the Matrix API and CLI, see the HP CloudSystem Matrix/Matrix Operating Environment Integration Interfaces API and CLI Operations Reference Guide: www.hp.