Druva provides a strong reporting mechanism to track credit consumption at each resource level and determine the cost associated with each organization. Druva Hybrid Workloads allows you to create a cost allocation report that provides cost allocation details specific to cost codes. The Cost Allocation Report displays credit consumption details for resources such as administrative groups, organization, and backup sets. The Cost Allocation report is generated every day at 12:15 AM UTC. You can download the report that shows credit consumption for a quarter. You can configure Druva Hybrid Workloads to send the Cost Allocation Report through an email on the first calendar day of every month. The report contains credit consumption details of the previous month and the cost allocation information.
Factors that affect report generation
When the cost allocation report is generated, the cost allocation of a particular resource is calculated using the credits consumed by the resource and the cost allocation rate defined for its cost code. Any change in the mapping between the cost code and the administrative group or organization during report generation affects the cost allocation for the cost code. The various factors that affect the cost allocation are listed as follows:
- An administrative group is deleted from an organization: The deleted administrative group is not accounted for cost allocation during report generation for that month. The credit usage information for the deleted resources belonging to the administrative groups is displayed under the unaccounted resource details in the Details section of the report. If an administrative group associated with a cost code is deleted, the administrative group is no longer associated with the cost code.
- An administrative group is removed from the cost code: The removed administrative group is not accounted for cost allocation during report generation for that month.
- An administrator deletes an organization: The organization is deleted from the associated cost code and is not accounted for cost allocation during report generation for that month. If an organization associated with a cost code is deleted, the organization is no longer associated with the cost code.
- An organization is removed from the cost code: The removed organization is not accounted for cost allocation during report generation for that month.
- The organization is moved from one cost code to another cost code in mid-month. The organization is accounted under the latest cost code for the complete month.
- A resource is deleted from the administrative group: The cost allocation for the deleted resource for the current complete month is displayed as unaccounted resource details in the Details section in the report.
- A resource is moved from one administrative group to another administrative group in mid-month: The resource is accounted under the latest administrative group for the complete month. If the latest administrative group is associated with any other cost code, the resource is accounted under that cost code.
- A backup set is deleted from an organization: The removed backup set is not accounted for cost allocation during report generation for that month.
- A backup set is moved from one administrative group to another administrative group in mid-month: The backup set is accounted under the latest administrative group for the complete month. If the latest administrative group is associated with any other cost code, the backup set is accounted under that cost code.
- A cost code is deleted: The report details for the current month are deleted. However, Druva Hybrid Workloads maintains the reports for the previous months.
- Cost objects are overlapped: If one or more cost codes are mapped to the same administrative group, organization, or backup set, the credit usage entries are duplicated for each cost code.
- Log in to the Druva Cloud Platform Console.
- Click to access the Global Navigation Panel > Reports > Hybrid Workloads. The Hybrid Workloads Reports page appears.
- Click Cost Allocation.
The Cost Allocation page appears. By default, the report provides details of the costs allocated that occurred in the last 30 days.
You can apply filters to the report to fetch replication activity details per your requirements. You can view the generated report, download it, or send it through an email to the intended recipients. You can also download data in the widgets in the CSV, CSV-Summary, and PDF formats. You can sort data in the table view using single or multiple columns, and rearrange columns in the table as required.
Note: The report data is refreshed every two hours. The last updated time recorded for the report is displayed next to the report title. This timestamp follows the administrator’s time zone. However, the timestamps of the data fetched in the report follow the UTC time zone.
The following screenshot depicts a sample Cost Allocation report.
The following table lists the fields of the Cost Allocation report:
|Summary||Total Cost Codes||The count of the cost codes.|
|Top Cost Codes chart||The horizontal bar graph displays the different cost codes versus the credits consumed by the resource.|
|Credit Allocation Summary||Cost Code||The name of the cost code.|
|Monthly Credits Consumed||The count of monthly credits consumed by the resource.|
|Cost Allocation Rate||The cost allocation rate of the cost code for the resource.|
|Monthly Cost||The total monthly expenditure of the resource.|
|Quarterly Cost||The total quarterly expenditure of the resource.|
The following table lists the actions that you can perform on the Cost Allocation Report page.
|Add filter||Creates filters to display Cost Allocation Report based on the filter’s selection.|
|Sort data||Sorts data in the Cost Allocation table using one or more columns.|
|Rearrange columns||Changes the order of the columns in the Cost Allocation Details table.|
You can apply filters to the Cost Allocation report to fetch audit details as per your requirements. You can view the generated report, download it, or send it through an email to the intended recipients.
- On the Cost Allocation page, click the filter icon.
The Filters widget appears. The Filters widget displays a default filter that lists cost allocation summary for the last 30 days. You can define multiple filters based on your requirements. Druva will fetch report data based on the fields’ selection. Click the delete icon to remove filters.
- Click Add Filter.
- On the Filter dialog, select a field or type the field name in the Column box, and use the filter options to create a combination of filters, and click Apply.
The Cost Allocation report page now displays data specific to the filter created. Similarly, you can further create more filters and apply them to display cost allocation summary.
For example, to fetch quarterly cost details for specific cost codes, select the Quarterly Code from the filter options, select the Equals option from the Is drop-down list, and select the specific cost code. Click Apply.
The report now displays quarterly cost details for the selected cost code.
Use the sort options to sort the report data in a single or multiple columns in an ascending or descending order.
The Apply Multiple-column Sort option allows you to sort report data using more than one column. The report displays data based on the order of columns selected. For example, you may want to fetch monthly credits consumed per cost code. To sort data, simply perform the following steps:
- In the Cost Allocation Summary table, go to the Cost Code column and click the More icon > Apply Multi-column Sort.
- Click the sort icon in the Monthly Credits Consumed column.
The Cost Allocation Summary table displays report data sorted based on the selected order of columns.
You can change the order of the columns in the Cost Allocation Summary table, Simply drag a column and drop it to the required position within the table.