Can we modify a saved Usage Report to execute with current date range?
search cancel

Can we modify a saved Usage Report to execute with current date range?

book

Article ID: 284261

calendar_today

Updated On:

Products

CloudHealth

Issue/Introduction

 

Yes, you can convert a saved Usage Report to execute with current date range.

 

1. Create a 'saved report' under Saved Reports

i.e. Reports --> Usage -->

 

You should be able to achieve a report that always lists the current month's results by removing the "&period" selection from the URI and resaving the report / subscription. 

E.g. Modify the URL of your saved report to remove - &period_val=2022-00-00 < Equal's YYYY-MM-DD Date

 

It should look similar to this before saving - (after you edit the URL:

 

https://apps.cloudhealthtech.com/reports/usage/instance-hours?table_form_submitted=true&tab=&account_type=&per_page=25&search=&display_names=account.name,instance.name,instance_type.api_name,availability_zone.name,instance.is_spot,total_hours,total_cost,ec2_io_cost,ebs_total_cost,instance.instance_id,instance.launch_date,instance.is_active,full_cost,instance.tags,month,on_demand_hours,reserved_hours,spot_hours,ec2_savings_plan_hours,compute_savings_plan_hours,used_pct,reservation_pct,savings_plan_pct,compute_cost,ec2_optimized_ebs_surcharge_cost,ec2_dedicated_tenancy_cost,ec2_cpu_credits_cost,ec2_other_cost,ebs_storage_cost,ebs_io_cost,ebs_piops_cost,avg_amortized_cost,sp_amortized_cost,ri_amortized_cost,total_amortized_cost&sort_order=-total_cost&selected_perspective=-1&selected_group=?+undefined:undefined+?&selected_perspective_2=-1&aws_account_id=7765300874607&aws_availability_zone_id=&is_active=All&type=All&aws_instance_type=All&status=All&tenancy=All&has_tags=All&tag_key=All&tag_value=&start_before_time=&start_time=&stop_time=&stop_after_time=&launched_in=&submit-report=&report_id=7765300872861

 

This should ensure the report always lists the current month when executed on a schedule.