4. Usage dashboard

In this area, you can see your USAGE data of the used cloud resources of your account. The following reports are available for this purpose:

  • Current month - Usage Standard Report current month
  • Previous month - Usage Standard Report last month
  • Custom query - Individual USAGE report with extensive query options (advanced)

All reports have an export function.

Note

The dates shown are indicative, time shifted 2-3 hours (e.g. CEST) depending on the time zone and may differ from your invoice dates for various reasons such as processing and rounding processes. They do not claim to be complete.

4.1. Usage Standard Reports

With the standard usage reports Current month and Previous month you can quickly get an overview of your used cloud resources.

  • To do this, navigate to Usage dashboard on the left and then click on the desired standard report, for example Previous month.
../_images/cp-ui-usage-previous-month.png

Note

If you have been using Cloud Services since the current month, understandably no data will appear in the previous month.

  • Simply call the standard Usage Report Current month.
  • To do this, navigate to Usage dashboard on the left and then click on Current month.
../_images/cp-ui-usage-current-month.png
  1. In the upper screen you can see the date range of the query
  2. In the column header you can sort the displayed table as you like by clicking on a column
  3. A filter input field allows you to filter the table by specific text
  4. Clicking on the Export table as CSV button will save the report locally. Look for the icon at the bottom of the screen.
../_images/cp-ui-usage-export-icon.png

4.2. Custom Query Report

The Custom query panel allows advanced users to create custom USAGE reports with extensive query capabilities that require some understanding and knowledge of the data structure.

  • To access the custom query, navigate to Usage dashboard on the left and then click on Custom query.
  • Then please click on the Custom usage query button to open the query input mask.
../_images/cp-ui-usage-custom-query-form.png
  • Now enter the parameters for your query and confirm with the Store it button. This saves and executes the query.

Note

You do not have to use all input fields for a query. Start with simple queries, see examples below.

4.2.1. Custom Query Form Fields

../_images/cp-ui-usage-custom-query-form1.png
Input Fields Custom Query Report Form
Input section Description
  1. Begin / End date
Please enter the time window, over which the query refers to
  1. Project ID Filter
Optionally, you can filter (limit) the query to one or more projects by entering the project name [1].
  1. Custom Projection
You can use this field to display other extensive fields, functions and data in the report. See examples below.
  1. Filters
Here you can enter additional filters of fields in the query in the form <field_name>:<value_we_want_to_filter>.
  1. Groupby options
By selecting the groupby fields, the report is displayed aggregated by these fields. Similar to SQL group by argument.
[1]Entering the first letter of a project will display a list of available projects. As soon as you select one, the project_id of this project will be inserted into the field. Repeat the process to select multiple projects.
  • Clicking the Custom usage query button again displays the last query, which you can then modify if necessary.

4.2.2. Example List of all VM Instances

You want a Custom Query Report query of last month’s USAGE data from VM instances only. The list should display the following fields as columns:

  • display_name
  • flavor_name
  • project_id

Enter the following data in the Custom Query Form and view the result.

../_images/cp-ui-usage-custom-query-example1.png

Note

By entering the filter in the form type:instance-usage-hours, only the instances are queried.