vRealize Business for Cloud allows your to export a set of default reports. In addition, you can create and export customized reports based on these default reports according to your requirements.

Procedure

  1. Log in to vRealize Business for Cloud virtual appliance.
  2. Run the command to generate the token for vRealize Automation and vRealize Business for Cloud authentication.

    wget --no-check-certificate -S -q --header "Accept: application/json" --header='Content-Type: application/json' --post-data '{"username":”USER_NAME","password”:”PASSWORD","tenant”:”TENANT"}' -O -CAFE_SERVER/identity/api/tokens, where

    • USER_NAME. The user name with administrator permissions to access vRealize Business for Cloud.

    • PASSWORD. The password for the administrator account.

    • TENANT. The vRealize Business for Cloud registered tenant.

    • CAFE_SERVER. The IP address or FQDN of the vRealize Automation server.

    You see the following output.

    HTTP/1.1 200 OK Server: Apache-Coyote/1.1 Cache-Control: no-cache, no-store Pragma: no-cache Expires: Wed, 31 Dec 1969 23:59:59 GMT Content-Type: application/json;charset=UTF-8 Content-Length: 383 Date: Wed, 25 Nov 2015 17:25:11 GMT {"expires":"2015-11-226T01:25:11.000Z","id": "MTQ0ODQ3MjMxMTQzMDo2MjlhMWU4MTdhOTEwNTM5Y2MyNzp0ZW5hbnQ6aXRibXN1c2VybmFtZTphZG1pbkBpdGJtcy5jb21AdnNwaGVyZS5sb2NhbGV4cGlyYXRpb246MTQ0O DUwMTExMTAwMDpjNTQzNjE3YjM3NDMyZTEwMTI4MzViZDNlYzEyNDA4MGQwMjI5NTVhMTU4OTUxNjM0ZDIzZjlhOTk4OTQ0ZDM5YmY2Y2UwZjUxNDVjYjRhNGUzZWZjMjNmYjM1 NGRjZDdkYTdlOGJjMzA1MjBhM2ZhZDg0NTdhYmNiMDEwZTA3OA==","tenant":"itbms"}

    The ID value is the token to authenticate.

    "MTQ0ODQ3MjMxMTQzMDo2MjlhMWU4MTdhOTEwNTM5Y2MyNzp0ZW5hbnQ6aXRibXN1c2VybmFtZTphZG1pbkBpdGJtcy5jb21AdnNwaGVyZS5sb2NhbGV4cGlyYXRpb246MTQ0O DUwMTExMTAwMDpjNTQzNjE3YjM3NDMyZTEwMTI4MzViZDNlYzEyNDA4MGQwMjI5NTVhMTU4OTUxNjM0ZDIzZjlhOTk4OTQ0ZDM5YmY2Y2UwZjUxNDVjYjRhNGUzZWZjMjNmYjM1 NGRjZDdkYTdlOGJjMzA1MjBhM2ZhZDg0NTdhYmNiMDEwZTA3OA=="

    Note:

    The token has an expiry date.

    "2015-11-226T01:25:11.000Z"

  3. Run the command to get a custom report or a default report.
    • For a custom report, run the following command:

      wget --no-check-certificate -S -q --header "Accept: application/json" --header='Content-Type: application/json' --header="Authorization: Bearer <TOKEN>" -O - https://<VRB_SERVER>/itfm-cloud/rest/reports-api/export-csv?name=<REPORT_NAME>, where

      • <vRB_SERVER>. The IP address or FQDN of the vRealize Business for Cloud server.

      • <Report_Name> is the name you provide for a custom report.

    • For a default report, you can run the command to export the complete data or to export data of a specific period.

      • To export the complete data, run the following command:

        wget --no-check-certificate -S -q --header "Accept: text/plain" --header='Content-Type: text/plain' --header "accept-encoding: gzip" --header="Authorization: Bearer <TOKEN>" -O - https://<VRB_SERVER>/itfm-cloud/rest/reports/export-filters/DEFAULT_REPORT_NAME>>out.xls where,

        DEFAULT_REPORT_NAME. The standard report names mentioned in the table.

        Report Type

        Standard Report Name

        vCenter Server reports

        • servers

        • datastores

        • vsan-datastores

        • vms

        • clusters

        vCloud Director reports

        • vcd-orgs

        • vcd-org-vdcs

        • vcd-vms

        • vcd-vapps

        vRealize Automation virtual machine reports

        vcac-vms

        Storage reports

        • storage-arrays

        • storage-luns

        vCloud Air reports

        • vca-vms

        • vca-vdcs

        • vca-services

        AWS reports

        • aws-resources

        • aws-vms

        Showback reports

        • showback-vms

        • showback-add-svcs

        Budget reports

        rest/budget/export

      • To export a report for a specific period, run the following command.

        wget --no-check-certificate -S -q --header "Accept: text/plain" --header='Content-Type: text/plain' --header "accept-encoding: gzip" --header="Authorization: Bearer <TOKEN>" -O - https://<VRB_SERVER>/itfm-cloud/rest/reports/export-filters/DEFAULT_REPORT_NAME?startmonth=yyyy-mm&&endmonth=yyyy-mm>>out.xls where,

        DEFAULT_REPORT_NAME. The standard report names mentioned in the table.

        • If you specify startmonth and endmonth, vRealize Business for Cloud generates a report from the first day of the month you specify in startmonth till the month that you specify in endmonth (till the last day of previous month.)

          For example, if you enter startmonth=2016-02&&endmonth=2016-06, you see the report is exported from first day of February till the last day of May.

        • If you specify startmonth only, vRealize Business for Cloud generates report from the first day of the month you specified till the current month.

          For example, if you specify startmonth=2016-02, you see the report is exported from the first day of February till the current month.

        • If you specify endmonth only, vRealize Business for Cloud generates report from the month the data is available till the month that you specified in the endmonth (till the last day of the previous month).

          For example, if you specify endmonthendmonth=2016-10, you see the report is exported till the last day of September.

        Note:

        You can specify the period for the vCenter Server virtual machine reports, vCloud Air reports, AWS reports, and Showback reports. You cannot generate vCloud Director, vRealize Automation virtual machine, and budget reports for a specific period.

    You see the reports are exported in the CSV or XLS format.