Inventory Reporting

CloudCheckr offers a variety of different reports which focus on ‘Inventory’

Summary

The S3 Summary report is a high level view of all of the different inventory reports located in your CloudCheckr account. It lists each service and then gives basic useful information taken from those services as well as a link to the report and detail report for each service.

Dboard
Map Overlay

 The Map Overlay Report shows which AWS Services are being utilized within each geographical region. It displays each region: US East (Virginia), US West (N. California), US West (Oregon), EU (Ireland), EU (Frankfurt),South America (Sao Paulo), Asia Pacific (Singapore), Asia Pacific (Sydney),  and Asia Pacific (Tokyo), with statistics showing how the region is being utilized.

map overlay

 

 

The Map Report has a dropdown, allowing you to jump between different AWS Services.  The EC2 Map shows how many instances are running and stopped within each region while the S3 Map shows the total number of buckets and objects within each region, as well as the total size of the objects being stored.

Tagged Resources

This report shows all of the resource tags you are using within AWS, as well as the specific resources that are using each tag.

NOTE: This report excludes the tag “Name”.

For more information on the Tagged Resources report please keep reading:

Read More
For more information on Resource Tags, see the Amazon website.

Capture

The report will show a list of each Resource Tag as well as the total number of resources using that tag.

If you click the green ‘plus’ symbol to the left of any Tag name, the report will expand and you will see additional details for that specific tag.  The plus symbol will turn to a red ‘minus’ symbol.  Use this to collapse the details once more.

Capture

  • Resource Type – which AWS service the resource was launched within.
  • Resource Name – the name of the resource.
  • Region Name – the AWS Region the resource resides within.

The data from the report can be exported into a CSV file by clicking on the ‘Save as CSV’ button in the top-right corner of the graph.

Untagged Resources

This report shows all of the resources within AWS that do not have any resource tags.

For more information on Resource Tags, see the Amazon website.

Read More

Capture

The report shows a list of the untagged resources as well as details for each:

  • Resource Type – which AWS service the resource was launched within.
  • Resource Name – the name of the resource.
  • Region Name – the AWS Region the resource resides within.

You can click on the Resource Name for any resource to be taken to its specific details report.

Custom Reports

CloudCheckr Custom Reports allow you to build specific searches and filter parameters to locate the AWS Resources you need. Instead of having to recreate the search and filter parameters, you can save these and reload them later. The parameters of your Custom Reports are saved and a new custom report will be built each day with the most up-to-date data from your AWS Deployment.

Read More

USING CUSTOM REPORTS

Capture

Custom Reports has three different sections:

Report Builder allows you to customize and save your reports.

Default Reports is a section that CloudCheckr pre-populates with some of our more popular custom reports for you as examples or templates. These include Custom Reports such as “Top 10 EC2 Instances With the Lowest CPU percentage”, and “10 Most Expensive S3 Buckets”.

Saved Reports allows you to view and edit any of your already-saved Custom Reports.

REPORT BUILDER

Capture

To create a Custom Report, first choose an AWS Service using the Report type dropdown.  CloudCheckr will populate the report options based on this selection.  The Filters, Columns, and Sort By options will all change depending on the AWS Service.

Name your report in Report Name field.  A name must be given to the report before it can be saved.

Capture

FILTER OPTIONS

First, choose your Filter options for the report by clicking on the ‘Plus’ symbol (+).  You’ll be presented with a pop-up box with three sections.

The first is the Filter Type.  This is where you will choose the type of data used to filter your report.  EC2 Custom Report, for example, has 26 different filter options including Instance Status, Size, Cost, Age, Tag, VPC, and CPU Utilization.

 

The second option is how to filter the data based on that selection.  These options vary by the filter type.  You can choose:

  • is equal to – this finds exact matches.  Example:  Instance Status is equal to Running to find all of your Running EC2 instances.
  • is not equal to – this finds everything except this exact match.  Example:  Region is not equal to EU (Ireland) to find all resources not in that region.
  • contains – finds resources that contain your selection.  This includes partial matches.  Example:  Tag contains Product, to find all resources tagged with Key = Product.
  • does not contain – finds resources that do not contain your selection.  This includes partial matches.  Example:  Availability Zone does not contain 1c, to find all resources in the other Availability Zones.
  • is greater than – finds resources with values higher than the selection.  Example:  Cost is greater than $500, to find all resources that cost more than $500.
  • is less than – finds resources with values lower than the selection.  Example, CPU Utilization is less than 25%, to find all resources whose CPU Utilization is lower than 25%.

The third option is a text box where you will enter the details of what you would like to filter on.  Many of the filter types provide suggestions as you type (see screenshot above showing Availability Zone suggestions).  If you are choosing to filter on something that ‘is equal to’, for example, your report will return anything that is an exact match with whatever you enter in this text box.  If you are choosing ‘contains‘ you can enter as many or as few characters as you’d like.   ‘Less than‘ and ‘greater than‘ require a number.

Once you are satisfied with your selections, click the Apply button to apply your filter to the custom report.  You can add additional filter options by clicking on the ‘Plus’ symbol (+) next to Filters again.

MATCH ALL FILTERS

Capture

When setting up multiple filters within your Custom Report you have the option to match all filters, or match any filters.

Match all filters (which is enabled by default) will only return results that match every filter option you have selected.

If Match all filters is not checked, the report will contain results that contain any filter option selected.

For example, we have a running Windows EC2 instance.

I setup a Custom EC2 Report with two filter options:

1 – Instance Status is equal to Stopped

2 – Instance Platform is equal to Windows

Match all filters checked will NOT return this EC2 instance because it does not match the “Instance Status is equal to Stopped” filter.

Match all filters not checked WILL return this EC2 instance because it matches one of the criteria: Instance Platform is equal to Windows.

COLUMNS

Capture

This allows you to choose which columns will display in the Custom Report.

Open the column options by clicking on the ‘Plus’ symbol (+).  You’ll be presented with a pop-up box a list of columns.

Simply check the columns you would like to display and click Apply.

NOTE: The data from all columns will also be available within the details of the resources when viewing the custom report.  If you do not select Platform, for example, the platform will not show as a column in the report but you can see the platform of the resource when looking at its details within the report.

RESULTS TO SHOW & SORT BY

Capture

You can sort the results from your Custom Report by any of the available column options.  These can be sorted in Ascending or Descending order.

You can choose to sort on something that you did not select when choosing your columns.  However, a column will be created for your Sort By selection in this scenario.

Using the Results to Show text box, you can dictate how many results you would like in your report.  This will allow you to setup reports that focus on ‘Top 25’ or ‘Top 100’.

Just enter the number of results you would like to view in the text box.  The results the report returns will be dependent on your Sort By selection.

NOTE: If you leave Results to Show empty, the report will return ALL matching results.

SAVING CUSTOM REPORTS

Capture

Once you have your Filters, Columns, and Sort By selections made, you can save your custom report.

NOTE: If you haven’t named your report yet, you must before it can be saved.

Click the Save Filter button on the bottom of the builder to save your report.

Capture

Once the report is saved you will see a notification at the top of the page.

If you would like to view your new report you can click the View Report link.

You can also stay in the Custom Report builder and create and save a new report by following these same steps.

VIEWING CUSTOM REPORTS

Capture

You can view your saved custom reports at any time by opening the Custom Reports menu and clicking on Saved Reports.  From there, choose the AWS service of the report you want to view and select the report.  You will be able to view the report, and it’s details here.

EDITING CUSTOM REPORTS

Capture

If, for any reason, you need to make a modification to your custom report, you can easily do so.

First, load the report you want to modify.  Then, make your desired changes by updating the Filters, Columns, or Sort By options and click the Filter button.

The report will reload, updating the results according to your changes.  If you are satisfied with these results you can click the Update Current Filter button.  This will overwrite the parameters of your Custom Report.

Alternatively, you can save these parameters as an entirely new Custom Report by clicking on the Save To Custom Reports button.  Give your new report a name and save.

DELETING CUSTOM REPORTS

Capture

If you would like to delete one of your saved custom reports,  load the report you want to delete.

Then, simply click the Delete Filter button.  You will get a popup asking you to confirm your delete request.  Click Delete.

Your report has now been removed from your list of saved custom reports.

NOTE:  This action cannot be reversed.

USE CASES

Here are some example uses cases for Custom Reports showing how to use the filter options to obtain targeted results.

Example 1:

Report to locate all running Windows instances that cost more than $100 per month in US West (Oregon) which have averaged less than 50% CPU Utilization over the past 90 days.

Filters:

  1. Status is Equal To Running
  2. Platform is Equal To Windows
  3. Instance Cost is Greater Than 100
  4. Region is Equal To US West (Oregon)
  5. 90 Day Avg CPU is Less Than 50

Example 2:

Report to show all S3 buckets that have more than 1 million objects, that are not located in the US.

Filters:

  1. Objects is Greater Than 1000000000
  2. Region Does Not Contain US

Example 3:

Report to show non-Linux m1.xlarge Reserved Instances running in Availability Zone us-east-1b.

Filters:

  1. Pricing Type is Equal To Reserved
  2. Platform is not Equal to Linux
  3. Type (Size) is Equal to m1.xlarge
  4. Availability Zone is Equal to us-east-1b

Example 4:

Report to show all instances within a specific VPC that cost less than $200 and whose CPU never spiked above 50%.

Filters:

  1. VPC is Equal To [enter the name of your VPC]
  2. Cost is Less Than 200
  3. Peak Utilization is Less Than 50

Trending

CloudCheckr’s trending reports allow you to quickly see how your AWS deployment has fluctuated over the past 7, 30, 90, 180 or 365 days.  These reports, which are separated by AWS Service, focus on EC2, S3, RDS, and Glacier.

The data from each of these reports can be quickly exported into a CSV file.

NOTE:  The data for these charts begins populating on a daily basis when you start using CloudCheckr.

For more information see below:

Read More

EC2

The EC2 trending report is broken down into 4 different reports:

  • History by Time
  • History by Instance
  • History by Pricing Type
  • Other

 

 

S3 Trends

The S3 Trends Report shows how many objects are being stored  and how much storage is being utilized within S3.

s3 trending report

Storage Used This shows you the total amount of storage used in S#

Objects – shows how many objects are being stored within S3, and how much storage is being utilized.

RDS Trends

The RDS Trends Report provides a running, daily total for the DB instances and features launched within RDS. The dropdown at the top of the report allows you to display totals for the past 7, 30, or 90 days.

DB Instances – shows how many DB Instances are launched.

DB Instance Storage used – shows the total amount of storage being used by all DB instances

DB Snapshots – shows how many DB Snapshots exist within RDS.

DB Security Groups – shows how many DB Security Groups exist within RDS.

Glacier Trends

The Glacier Trending Report shows how your Glacier usage fluctuates on an ongoing daily basis. You can choose to show 7, 30, 90, 180, or 365 days worth of data in the report by using the dropdown at the top of the report. The report can be exported into a CSV file by clicking on the Save icon in the top-right corner of the report.

 Capture

Number Of Bytes Used- This chart shows the total storage used by Glacier, in GB.

Number of Archives- Shows the total number of Archives created within Glacier.

Cost- Shows the total storage costs for Glacier.

Support Trends

The Support Trends report shows you a trend of all the support cases opened within AWS.

Number of Resolved Support Cases- This is the total number of support cases which has been marked by solved by Amazon. This is not support cases which may be open with the CloudCheckr support team. 

Number of Unresolved Support Cases- This is the total number of unresolved support cases you have with AWS.

Total Support Cases- This is a trend of your total support cases, regardless of status, with AWS. 

 

 

EC2

EC2 Summary Report
EC2 Details Report

EBS Volumes

EC2 EBS Volumes Summary Report
EC2 EBS Volumes Detail Report
EC2 EBS Volumes Snapshot Report

AMIs

EC2 AMIs Summary Report
EC2 AMIs Detail Report

Security Groups

EC2 Security Groups Summary Report
EC2 Security Groups Detail Report

Load Balancers

EC2 Load Balancer Summary Report
EC2 Load Balancer Details Report

S3 Reports

S3 Summary Report
S3 Details Report

RDS Reports

RDS Summary Report
RDS Detail Report

Backups

RDS Backup Summary Report
RDS Backup Detail Report

Security Groups

RDS Security Group Summary Report
RDS Security Group Detail Report

Parameter Groups

RDS Parameter Group Summary Report
RDS Parameter Group Detail Report

Snapshots

RDS Snapshots Summary Report
RDS Snapshots Detail Report

Auto Scaling Reports

Auto Scaling Summary Report
Auto Scaling Groups Report
Auto Scaling Launch Configurations Report

CloudFormation

CloudFormation Summary Report
CloudFormation Details Report

CloudFront Reports

CloudFront Summary Report
CloudFront Detail Report

CloudSearch

CloudSearch Summary Report
CloudSearch Details Report

Data Pipeline

Data Pipeline Summary Report
Data Pipeline Details Report

DynamoDB

DynamoDB Summary Report
DynanmoDB Details Report

ElastiCache Reports

ElastiCache Summary Report
ElastiCache Clusters Report
ElastiCache Nodes Report

Elastic Beanstalk

Elastic Beanstalk Summary Report
Elastic Beanstalk Details Report

Elastic MapReduce

Elastic MapReduce Summary Report
Elastic MapReduce Details Report

Glacier Reports

Glacier Summary Report
Glacier Detail Report

IAM Reports

IAM Summary Report
IAM Users Report
IAM Groups Report
IAM Roles Report

Kinesis

Kinesis Summary Report
Kinesis Details Report

RedShift

RedShift Summary Report
RedShift Details Report

Route 53

Route 53 Summary Report
Route 53 Details Report

SES

SES Summary Report
SES Details Report

SipmleDB

SimpleDB Summary Report
SimpleDB Details Report

SQS

SQS Summary Report
SQS Details Report

SNS

SNS Summary Report
SNS Details Report

SWF

SWF Summary Report
SWF Details Report

VPC

VPC Summary Report
VPC Details Report