Usage Reports

Workspace Hours

This report sources information from the Detailed Billing Record (DBR) as well as the Asset Database to populate the number of instance hours for a given month.

Insight This Report Provides

• What is the current usage of Amazon Workspaces?

• What are the costs incurred by each Workspace and the total number of hours run each month?

  In the AWS Console, you can choose whether the running mode for your AWS Workspaces is AlwaysOn (monthly fixed price) or AutoStop (hourly price based on usage). Because of how Tanzu CloudHealth derives Workspace usage data from the AWS bill, Tanzu CloudHealth cannot determine the number of hours an AlwaysOn Workspace has been running. Therefore, for AlwaysOn Workspaces, the Total Hours column shows the total number of hours in the month (either 720 or 744 hours), regardless of what day of the month it is.

Default Columns

The default columns for the Workspace Hours report are:

• Account Name: The account name the Workspace is billed to.
• Bundle ID: the ID of the bundle used to create the Workspace.
• Directory ID: The ID of the AWS Directory Service directory that the Workspace is on.
• Username: The username for the Workspace.
• WorkSpace ID: The ID of the Workspace.
• State: The current operational status of the Workspace.
• Total Hours: The total number of hours that the Workspace has been running for the selected month.

• Total Cost: The total of fees billed for the Workspace as it was running for the selected month.

  Select which month you want the Workspace Hours report to analyze in the Filters > Range Filters dropdown.

Virtual Machine Usage

Insights This Report Provides

• What is the monthly usage of virtual machines?
• What is the average number of VMs being run per month?

The data source for the this report is the Azure customer bill, which includes information about the machine series and number of hours shown. Consequently, the data presented in this report might not match internal Azure reporting that uses other data sources, such as the Cost and Usage Report.

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: ## VMs by Usage
• Category: Machine Series
• Chart Type: Bar

Example

VM Usage by Months and Machine Series (Default View)

Variations: In the Y-Axis dropdown, select ## VMs to view VM usage by the number of individual VMs running or ## VM Hours to view VM usage by the number of hours all VMs were running.

VM Compute Cost by Months and Machine Series

• Y-Axis: Compute Cost

Determine the actual cost of the VMs according to the Azure bill.

Variations: In the Y-Axis dropdown, select Compute Cost before RIs to view how much you would have paid if you didn’t buy RIs for the same usage or Application Cost to view the cost of the Azure applications and ComputeHR_SW running on your VMs.

Asset Usage by Months and Machine Series

• Y-Axis: ## Assets

Determine the number of VMs that count towards each unique resource GUID.

ElastiCache Usage

Insights This Report Provides

• What is the historical ElastiCache usage?
• How many nodes are running for each reservation type?
• Where are nodes located?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Instances
• Category: Reservation Type
• Chart Type: Bar

Examples

ElastiCache Usage by Days and Reservation Type (Default View)

ElastiCache Usage by Instance Types and Reservation Type

Report Settings - X-Axis: Instance Types - Y-Axis: ## Instances, ## Reservations

Determine which node types are reserved and which are On Demand.

ElastiCache Usage by Days and Instance Types for: On Demand

Report Settings - Filters: Reservation Type > On Demand - Category: Instance Types

Determine daily On Demand usage by node type.

ElastiCache RN Inventory

Insights This Report Provides

• How many reserved nodes (RN) are running under each reservation type?
• What is the scope of each RN?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Reservations
• Category: Reservation Type
• Chart Type: Bar

Examples

RN Inventory by Days and Reservation Type (Default View)

Variations:

• From the Y-Axis dropdown, select either Amortized Cost By Purchase ($) to show the amortized cost assigned by where the RN was purchased or Amortized Cost by Usage ($) to show the amortized cost assigned by where the RN benefit occurred.
• From the Category dropdown, select Instance Type or Region to view the scope of each RN by a different parameter.

EC2 Snapshot Usage

Insights This Report Provides

• How many EC2 snapshots have been used over time?
• What is the EC2 snapshot usage trend by region?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Snapshots
• Category: Regions
• Chart Type: Bar

Example

Snapshot Usage by Days and Regions (Default View)

Variations: In the Category dropdown, specify another category such as Accounts or Days to view EC2 snapshot trends by that category.

EC2 RI Utilization

Insights This Report Provides

• What is the usage of EC2 Reserved Instances over time?
• How does the RI usage compare to the overall instance usage?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: ## Instances, ## Reservations
• Chart Type: Line

Example

Reservation Utilization by Weeks (Default View)

Variations: In the Category dropdown, specify a category such as Billing Accounts to view EC2 RI usage by billing account.

EC2 Instance Usage

Insights This Report Provides

• What is the monthly EC2 instance usage?
• What is the EC2 instance usage trend by reservation type?

Report Default Settings

• Interval: Daily
• X-Axis: days
• Y-Axis: ## Instances
• Category: Reservation Type
• Chart Type: Bar

Example

Instance Usage by Days and Reservation Type (Default View)

EC2 Instance Hours

Note The average RI Amortized Cost field is being deprecated and will be removed in a future release.

Insights This Report Provides

• What is the current usage of instances?
• What are the costs incurred by each instance, the total number of hours run, and the number of hours this instance was run under a reservation?

This report sources information from the Cost and Usage Reports (CUR) as well as the current monthly Asset Database to populate the number of instance hours for a given month.

Default Columns

The default columns for the Instance Hours report are:

• Account Name: The account name the asset is billed to.
• Instance Name: The name of the Instance.
• API Name: The Instance Type.
• Zone Name: The Availability Zone of the instance.
• Spot: Whether or not the instance is a spot instance.
• Total Hours: The total number of hours that the instance has been running. After a month is invoiced, the maximum value is 24*days of month.
• EC2 Compute Cost: the total of the fees billed for the instance-type as it was running. For instances that were running fully on-demand, it will be hourly fee for that instance type * number of hours run.

Note: When you launch an EC2 instance, it first enters the pending state and then transitions to the running state. When you stop that instance, it first enters the stopping state and then transitions to the stopped state.

As soon as your instance transitions to running, AWS bills you per second, with a one minute-minimum charge. Even if an instance runs for less than one minute, you incur the full minute of billing.

For more information, see EC2 Instance Lifecycle.

EC2 RI Inventory

Insights This Report Provides

• How many EC2 Reserved Instances do you have?
• What is the historical trend of your EC2 RI usage?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: ## Reservations
• Category: Reservation Type
• Chart Type: Bar

Example

Reservation Inventory by Weeks and Reservation Type (Default View)

Variations: In the Category dropdown, specify a category such as Reservation Class or Reservation Scope to analyze EC2 RI trends by class, scope, etc.

Dynamo DB Table Usage

Insights This Report Provides

• What is the usage of Dynamo DB tables over time?
• What is the cost incurred by each table?
• How many hours did each table run for?
• What is the cost per table attributed to your reserve capacity?

Dynamo DB Table usage is calculated using your billing records, as well as CloudWatch metrics

Default Columns

• Month: The month for which the data is showing
• Table Name: The name of the DynamoDB table
• Hours: The total number of hours that the table was running in the billing period
• Storage Cost: The portion of total storage cost attributable to this table
• Committed Read/Write Capacity Cost: The portion of the capacity cost that can be attributed to this table
• Reserved Read/Write Capacity Cost: The portion of the reserved capacity cost that can be attributed to this table
• Total Cost: The total cost attributable to this table including Storage, Capacity, and API call and Transfer costs

Azure Storage Usage

Insights This Report Provides

• What is the historical trend for Azure storage usage?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Operations (One Hundred Million)
• Category: Storage Types
• Chart Type: Bar

Example

Storage Usage by Days and Storage Types (Default View)

Availability Zone Usage

AWS infrastructure is hosted at isolated locations called Availability Zones, which are grouped into separate geographic areas called Regions. Amazon maps these locations to logical identifiers such as us-east-1a for each account. The mapping between the locations and identifiers is done independently per account.

The Availability Zones report drives the analysis and recommendations of the RI Optimizer.

Insight This Report Provides

• How are logical zones mapped to individual locations?
• When AWS reports infrastructure and outage issues in specific zones, what is the problem location across multiple accounts?
• What are opportunities to share Reserved Instances across multiple accounts?

The pricing benefits of RIs are shared when the purchasing account is a linked account billed under one consolidated billing (CB) payer account.

The usage amount across all linked accounts is pooled and then the normal RI logic is applied. However, the pooling and RI applicability is along physical zone boundaries, and doesn’t hold for same zone identifiers across multiple accounts.

Report Default Columns

• Fixed: The name in the first column, in the format {region}x-fixed, is not meaningful except to distinguish between different locations.
• All Other Columns: Each column represents one your AWS accounts. Each cell in the table has a logical zone identifier that AWS has assigned for that account and location. For example, us-east-1d in the Tanzu CloudHealth account maps to the same location as us-east-1b in the Tanzu CloudHealth-Development account.

Not all accounts have visibility into all the locations in the region. Multiple accounts may have complete, partial, or no overlap of physical locations.

GovCloud accounts have access to GovCloud region only and nothing else. Other accounts do not have access to GovCloud region. Multiple zones should be available in every accessible region to each account.

This mapping is refreshed daily for all new and existing accounts.

EBS Volume Usage

Insight This Report Provides

• What is the usage of volumes over a billing period?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: Storage
• Category: EBS Volume Status
• Chart Type: Bar

Example

Volume Usage by Days and EBS Volume Status (Default View)

EBS Volume Hours

Insight This Report Provides

• What is the usage of volumes over a billing period?
• What are the costs incurred by each volume, the total number of hours run, and the status of the volume?

Default Columns

• Volume ID: The ID of the volume.
• Volume Name: The name of the volume.
• Active?: Whether or not the volume is active in AWS.
• Size (GB): The size of the volume.
• Status: The status of the volume.
• Type: The type of the volume.
• Instance Name: If applicable, the name of the instance which with the volume is associated.
• Hours: Number of hours the volume has been active.
• Total cost: The total cost for the volume including storage, IO costs, PIOP costs, and transfer costs.
• Storage cost: The storage cost for the volume.
• IO cost: The IO cost for the volume.
• PIOPS cost: The PIOPS cost for the volume.
• SSD Savings: The amount saved if the volume were an SSD instead of magnetic, when all costs are factored in.

Virtual Machine RI Utilization

Insight This Report Provides

• What is the historical trend of virtual machine reservation usage?
• Which assets and reservations are used most frequently?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: ## Assets, ## Reservations
• Chart Type: Bar

Example

Virtual Machine RI Utilization by Weeks (Default View)

Virtual Machine RI Inventory

Insight This Report Provides

• How many virtual machine reservations do you have?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: ## Reservations
• Chart Type: Bar

Example

Virtual Machine RI Inventory by Weeks (Default View)

SQL Database Usage

Insights This Report Provides

• What is the monthly usage of my SQL databases?
• Which SQL databases are used most frequently?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: SQL Databases
• Category: Service Tier
• Chart Type: Bar

Example

SQL Database Usage by Days and Service Tier (Default View)

S3 Usage

Analyze S3 usage by storage type over a specific period

Insight This Report Provides

• What is your S3 usage over time?
• Which S3 storage types are used most frequently?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: Glacier Overhead, Glacier Storage, Infrequent Access Storage, RR Storage, Standard Storage
• Chart Type: Line

Examples

S3 Storage by Days (Default View)

Redshift Usage

Insight This Report Provides

• What is the Redshift instance usage by instance type?
• How many instances are reserved or On Demand?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Instances
• Category: Reservation Type
• Chart Type: Bar

Examples

Redshift Usage by Days and Reservation Type (Default View)

Redshift Usage by Instance Types and Reservation Type

Report Settings - X-Axis: Instance Types - Y-Axis: ## Instances, ## Reservations

Determine which instance types are reserved and which are On Demand.

Redshift RN Inventory

Insight This Report Provides

• How many Redshift reserved instances are running under each reservation type?
• What is the scope of each Redshift reservation?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: ## Reservations
• Category: Reservation Type
• Chart Type: Bar

Examples

Redshift Usage by Days and Reservation Type (Default View)

Variations: From the Category dropdown, select Instance Type or Region to view the scope of each Redshift reservation by a different parameter.

RDS Snapshot

Insights This Report Provides

• How many RDS Snapshots are being used in the environment?
• What is the proportion of RDS Snapshots used across teams, projects, or accounts?

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: Number of Snapshots
• Category: Regions
• Chart Type: Bar

Example

Region-wise usage of RDS Snapshots (Default View)

RDS RI Utilization

Insights This Report Provides

• How many RDS instances are running with respect to the number of RDS RIs available in a given period?
• What is the trend of RI instance utilization and number of RIs available across teams, projects, or accounts?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: (i) Number of Instances, (ii) Number of Reservations
• Category: None
• Chart Type: Line

Example

Number of RDS instances running with respect to the number of RDS RIs available (Default View)

RDS RI Inventory

Insights This Report Provides

• How many RDS reserved instance are in use?
• What is the proportion of All Upfront, Partial Upfront, and No Upfront reservations?
• Which types of RDS reservations are being used across teams, projects, or accounts?

Report Default Settings

• Interval: Weekly
• X-Axis: Weeks
• Y-Axis: Reservations
• Category: RDS Reservation Type
• Chart Type: Bar

Example

Number of RDS reservations by reservation type (Default View)

RDS Instance Usage

Insights This Report Provides

• What is trend of RDS usage by instance type?
• What is the trend of RDS usage across teams, projects, or infrastructure owners?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: Number of Instances
• Category: RDS Instance Types
• Chart Type: Bar

Example

RDS RI cost amortization for current month by Instance Type (Default View)

Variations: In the Category dropdown, specify a Perspective Group such as Owner, Environment, or other Perspectives. The report shows you usage trends by those Perspectives so that you can analyze how many RDS instances a team, project, or infrastructure owner is using.

EMR Cluster Hours

Insight This Report Provides

• What is the usage of Elastic MapReduce clusters over a billing period?
• What are the costs incurred by each cluster, the total number of hours run, and details on the operation and costs of the cluster?

Default Columns

• Account Name: The account name the cluster is billed to
• Cluster ID: The unique ID of the cluster
• Name: The cluster name
• Ready Date: The Date and Time that the Cluster was ready for use
• Total Hours: The total number of Instance Hours for all of the instances in the cluster
• Total Cost: The total cost of the cluster including usage fees and the EMR surcharges

ElasticSearch Usage

Insight This Report Provides

• What are each ElasticSearch domain’s total running hours and associated cost?

Default Columns

• Account Name: The name of the account associated with the domain.
• Domain Name: The name of the ElasticSearch domain.
• Month: The month from which the report data is calculated.
• Domain Hours: The number of hours the domain has been run this month.
• Total Cost: The associated cost of running the domain this month.

Data Transfer Usage

Insight This Report Provides

• What is the AWS usage for data transfer?
• What is the AWS usage by data transfer type (regional, inter-zone, etc.)?
• Which cost reduction opportunities are available based on inter-region traffic and its sources?

Report Default Settings

• Interval: Daily
• X-Axis: Days
• Y-Axis: Transferred (GB)
• Category: AWS Services
• Chart Type: Bar

Examples

Transfer Usage by Days and AWS Services (Default View)

Transfer Usage by Transfer Type and Perspective

Report Settings

• X-Axis: Transfer Type
• Category: Any perspective that uses a workload-based grouping

Determines how much of your traffic is external-facing vs. internal.

EC2 Underutilized RIs

Insight This Report Provides

• Which reserved instances were not fully utilized over the Analysis Period?

Underutilization for the Analysis Period is calculated as follows: (Total instance hours reserved) - (Total instance hours used)

Default Columns

• Billing Account/Account: The account associated with the reserved instance.
• Instance Type: The type of the instance.
• Location: The Availability Zone or Region of the instance.
• Operating System: The operating system running on the instance.
• Reservation Type: The payment option used for the reservation.
• % VPC: The percentage of time that the instance ran in a Virtual Private Cloud.
• Hours Unused: The number of hours over the Analysis Period (Current Month or last 31 days) for which the reserved instance was paid for but was not used.
• Unused RI Cost: The savings in USD that could have been achieved by utilizing the reserved instance to full capacity.

Variations

You can customize the report in one or more of these ways:

• Filter by Account: Select an account from the Filters > Account dropdown to limit the report to specific accounts.
• Analysis Period selection: Select Current Month (month-to-date usage) or Last 31 days to specify the period over which Tanzu CloudHealth should analyze reserved instance usage.
• Account Analysis selection: Select Billing Family or Account to specify the AWS account against which Tanzu CloudHealth should evaluate usage.

RDS Instance Hours

Insights This Report Provides

• What is the usage of RDS instances over a specific month?
• What costs were incurred by each RDS instance?
• For how many hours did an RDS instance run?
• How many hours of an RDS instance were covered by a reservation?

Report Default Settings

• Account Name: The account to which the instance is billed
• Instance ID: The ID of the instance
• DB Name: The database attached to the instance
• API Name: The type of instance
• Zone Name: The availability zone of the instance
• Total Hours: The total number of hours for which the instance ran during the selected month

The report shows instance hours for the current month, which is also the billing period considered for analysis.

Examples

RDS instance hours for current month (Default View)

RDS instance hours covered by reservation

Report Settings

• Click Edit Columns and add the Reserved Instance Hours column to the report.

Virtual Machine Underutilized RI

Insight This Report Provides

• Which reserved virtual machines were not fully utilized over the Analysis Period?

Underutilization for the Analysis Period is calculated as follows: (Total VM hours reserved) - (Total VM hours used)

Default Columns

• Subscription: The subscription associated with the reserved VM.
• Virtual Machine Size: The size of the VM.
• Location: The Region of the VM.
• Reservation Type: The payment option used for the reservation.
• Number of Reservations: The number of reservations the VM is on.
• % Used: The percentage of time over the Analysis Period (Current Month or last 31 days) for which the reserved instance was used.
• Reserved Hours : The number of hours over the Analysis Period (Current Month or last 31 days) for which the reserved instance was paid for.
• Hours Unused: The number of hours over the Analysis Period (Current Month or last 31 days) for which the reserved instance was paid for but was not used.
• Effective Costs: The cost paid over the Analysis Period (Current Month or last 31 days) for the VM.
• Unrealized Savings: The savings in USD that could have been achieved by utilizing the reserved VM to full capacity.

Variations: In the Analysis Period dropdown, select Current Month (month-to-date usage) or Last 31 days to specify the period over which Tanzu CloudHealth should analyze reserved VM usage.

Host Hours

Insights This Report Provides

• How many host hours were committed based on the subscription plan?
• How many host hours were utilized from committed hours and if there were any on-demand hours beyond committed hours?

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: Committed Host Hours and Host Usage Hours
• Category: CSP Organizations
• Chart Type: Bar

Example

VMware Cloud Host Usage by Months and CSP Organizations (Default View)

Elastic IP Hours

Insights This Report Provides

• What is the number of elastic IP on-demand usage hours?

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: Elastic IP Usage Hours
• Category: CSP Organizations
• Chart Type: Bar

Example

VMware Cloud Elastic IP Usage by Months and CSP Organizations (Default View)

GCP GCE Compute Engine Usage

The FlexReport view of the GCE Compute Engine usage report provides faster realization of the latest data and drilldown capability to help you make decisions. Like FlexReport, you will need access permission enabled for the GCE Compute usage report and follow the same organizational scoping.

To view the usage report, navigate to Reports > Usage > Compute Engine. The report will appear in FlexReport chart view format.

Perspectives are currently not supported for the GCE Compute usage report.

Insights This Report Provides

• What is the daily/monthly compute engine usage trend over the last 13 months based on the number of cores and RAM?
• What is the compute engine usage trend by
  • Project ID
  • Billing Account ID
  • Region
  • Coverage Type – Different Discount types are provided by GCP.
  • Machine Type- Custom VM, Standard VM, etc.
  • Machine Series – (e.g., first generation, second generation. Supported series- N1, N2, N2D, E2, C2, M1)
  • Machine Family- Grouping of Machine Series

Permissions Required to Access the GCE Compute Usage Report

To access GCE Compute usage report, your role must have permission to Read GCP Gce Usage Report. To assign the access permission, navigate to Setup > Admin > Roles. In the Privileges section of the role editor, expand Google > Reports> GCP GCE Usage Report and enable or disable the required permissions.

For drilldown view of the GCE Compute Engine usage report, you need to have the FlexReport permissions enabled. For more details, see Roles and Privileges for FlexReports.

VMware Cloud Data Transfer (Beta)

Insights This Report Provides

• What number of data transfer hours were used across a CSP organization?

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: Data Transfer
• Category: CSP Organizations
• Chart Type: Bar

Example

VMware Cloud Data Transfer by Months and CSP Organizations (Default View)

Oracle Cloud Compute Usage

Analyze Compute Instance usage by Months and Tenancies

Insights This Report Provides

• Historical usage data for the past 12 months and current month.
• Usage report view by Compute Shapes, Months, Regions, Tenancies, and Organization specific perspective.
• Billed instance hours by Tenancies.

Report Default Settings

• Interval: Monthly
• X-Axis: Months
• Y-Axis: Billed Instance Hours
• Category: Tenancies
• Chart Type: Bar

Report View

Switch the Usage report view between Daily, Monthly and Weekly. Your Interval selection determines how the data is defined on the X-Axis:

• Daily: The last two months of data
• Weekly: The last 52 weeks
• Monthly: The last 13 months

Filters Menu

You can use the following standard filter options to view the report as per your business needs.

• Days/Weeks/Months (Based on specified Interval)
• Regions
• Tenancies
• Compute Shape
• Organization specific Perspectives

Note:

• You can select multiple filter options as per your analysis needs.
• The perspectives are labeled with the letter P .
• The platform provides 13 months of historical data, starting from May 1, 2020 or from the time the tenant was created in the Oracle Cloud, whichever occurs later.