Custom Reports

Custom Reports enables you to create custom inventory reports using a Custom Report Builder. The procedure walks you through an example of how to create a custom report.


Procedure

  1. From the left navigation pane, choose Inventory > Custom Reports > Custom Report Builder.

    The Custom Report Builder page opens.

  2. From the Report type drop-down menu, select a report type.

    CloudCheckr will populate the Filter, Columns, and Sort By options based on this selection.

    For this procedure, we selected RDS.
  3. In the Report Name text field, type a name for your report. You must provide a name before CloudCheckr can save your report.
  4. Click (Add new filter).

    1. In the first drop-down menu, select the type of data on which to filter your report.
    2. In the second drop-down menu, select a function to refine your search.

      Function

      Description

      Example

      is equal to

      finds exact matches

      Instance Status is equal to Running: finds all of your running EC2 instances

      is not equal to

      finds everything except this exact match

      Region is not equal to EU (Ireland): finds all resources not in that region

      contains

      finds resources that contain your selection, and may include partial matches

      Tag contains Product: finds all resources tagged with Key = Product

      does not contain

      finds resources that do not contain your selection and may include partial matches

      Availability Zone does not contain 1c: finds all resources in the other availability zones

      starts with

      finds the resource name that start with the word(s) or numbers you type in the blank text field

      DB Instance Class starts with db.m5: finds all resources that start with db.m5

      does not starts with

      selects resources that do not start with the keywords you type in the blank text field

      DB Instance Class does not start with db.m5: finds all resources that do not start with db.m5

      is empty

      finds resources that do not have a value for the selected filter

      Engine is empty set to true: finds all resources that do not have a value in for engine

      is not empty

      finds resources that do have a value for the selected filter

      Engine is not empty set to true: finds all resources that do have a value in for engine

    3. In the blank text field, type the word(s) or number(s) that you want your function to take action on.
      Keep in mind:
      • Many of the filter types provide suggestions as you type.
      • If you select equal to, your report will return results that are an exact match of what you typed in the text field.
      • If you select contains, you can type as many or as few characters as you want.
      • The filters, is less than and is greater than require a number.
  5. Click Apply.
  6. If applicable, select the Match All Filters check box.

    Enabled by default, Match All Filters only returns results that match all selected filter options. If you do not select it, the report will contain results with any selected filter option. For example, a company is running a Windows EC2 instance configured with two filter options:
    • Instance Status is equal to Stopped
    • Instance Platform is equal to Windows
    If you selected Match All Filters, CloudCheckr will not return this EC2 instance because it does not match the Instance Status is equal to Stopped filter.

    If you did not select Match All Filters, CloudCheckr will return this EC2 instance because it is an option of the Instance Platform is equal to Windows filter.

  7. Click (Add New Column).

    A dialog box opens.
  8. Select the columns you want to display and click Apply.

    The data from all columns is also available in the custom report details.  For example, if you do not select Platform as a report column, you can still find out the platform of a resource by viewing the report details.
  9. In the Results to Show text box, type a numerical value to indicate the number of results you want CloudCheckr to generate.

    If you leave Results to Show empty, the report will return all matching results.
  10. Select your sort options.
    1. From the first drop-down menu, select which column you want to sort by.
    2. From the second drop-down menu, select if you want to sort the results in ascending or descending order.

  11. From the Build Summary Chart For drop-down menu, select the parameter on which to build your report chart.
  12. Click Save Filter.

    CloudCheckr displays a notification at the top of the page after it saves the report successfully.

    The screenshot shows an example of a custom report. The top portion shows the report filters and the bottom portion shows the results.

    To access a saved custom report, go to the left navigation pane and choose Inventory > Custom Reports > Custom Report Builder, navigate to the service associated with the report, and click the report name. Once CloudCheckr loads the report, you can modify, delete, or email it.

Use Cases

Here are some example uses cases that show how to use the filter options to obtain custom, targeted results.

Example

Description

Filters

1 You need a report to identify all running Windows instances that cost more than $100 per month in US West (Oregon), which averaged less than 50% CPU Utilization for the past 90 days.
  • Status is Equal To Running
  • Platform is Equal To Windows
  • Instance Cost is Greater Than 100
  • Region is Equal To US West (Oregon)
  • 90 Day Avg CPU is Less Than 50
2 You need a report that shows all S3 buckets that have more than 1 million objects and are located outside of the United States.
  • Objects is Greater Than 1,000,000
  • Region Does Not Contain US
3 You need a report to show non-Linux m1.xlarge Reserved Instances running in the following availability zone: us-east-1b.
  • Pricing Type is Equal To Reserved
  • Platform is not Equal to Linux
  • Platform is not Equal to Linux
  • Type (Size) is Equal to m1.xlarge
  • Availability Zone is Equal to us-east-1b
4 You need a report to show all instances within a specific VPC that cost less than $200 with CPU that never spiked above 50%.
  • VPC is Equal To [enter the name of your VPC]
  • Cost is Less Than 200
  • Peak Utilization is Less Than 50

How did we do?