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.
- From the left navigation pane, choose Inventory > Custom Reports > Custom Report Builder. The Custom Report Builder page opens.
- 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.
- In the Report Name text field, type a name for your report. You must provide a name before CloudCheckr can save your report.
(Add new filter).
- In the first drop-down menu, select the type of data on which to filter your report.
- In the second drop-down menu, select a function to refine your search.
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
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
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
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
- 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.
- Click Apply.
- 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 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.
- Click (Add New Column). A dialog box opens.
- 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.
- 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.
- Select your sort options.
- From the first drop-down menu, select which column you want to sort by.
- From the second drop-down menu, select if you want to sort the results in ascending or descending order.
- From the Build Summary Chart For drop-down menu, select the parameter on which to build your report chart.
- 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.
Here are some example uses cases that show how to use the filter options to obtain custom, targeted results.
|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.||
|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.||
|3||You need a report to show non-Linux m1.xlarge Reserved Instances running in the following availability zone: 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%.||