With DPA there is no easy way to get the details for each calendar month.
What I have found is if you change the Time Period interval to say roughly 30 days (average days per month) within one of the Resources you have in the report, this will then group the data for you for an estimate for each month. I have found that this was the only way to show backup data per month. It is similar to the existing reports of Data Backed Up Daily and Data Backed Up Weekly.
1 - Using the All Jobs data source, add a bunch of fields, Jan through Dec
2 - Change the date format of the end time/queue time or start time (whichever you consider to be the backup timestamp) to dd/MMMM/yyyy. This will give you dates in the format 12/February/2014. You can then perform some regex and group the data by month
3 - Set Values of each month i.e. Set Value of report field "Feb" to the value of Report Field "Size" if the newly formatted date field contains "February"
4 - You should be able to then hide all fields except Jan - Dec
Note that this will only work if your start time and end time are within the same calendar year i.e. choose a time period of 1st Jan to 31st Dec
I created a similar report by adding a Data Source for each Month with a different Time Window:
For last Month, use the default time window. For the other Months, change the time window as follows:
Start Time: Relative to Start of Window
Start Time Parameters: 30 Days Before
End Time: Relative to Enf of Window
End Time Parameters: 30 Days Before
Change the Start/End Time Parameters as apropriate for each Month. Unfortunately it's not possible to enter the relative start/end times in Monthly units so each colomn will not be an exact Month.
RLIM
14 Posts
0
December 9th, 2014 13:00
Hi Frank,
With DPA there is no easy way to get the details for each calendar month.
What I have found is if you change the Time Period interval to say roughly 30 days (average days per month) within one of the Resources you have in the report, this will then group the data for you for an estimate for each month. I have found that this was the only way to show backup data per month. It is similar to the existing reports of Data Backed Up Daily and Data Backed Up Weekly.
Advise on how you get on.
Regards
Roland
Frank Kuhn
25 Posts
0
December 10th, 2014 02:00
THX
I will test that!
Frank Kuhn
25 Posts
0
December 10th, 2014 02:00
Thanks
So I will do it month per month and will do my detailed analysis in excel ...
finnj7
6 Posts
1
December 10th, 2014 02:00
Hi Frank
What you need to do is as follows:
1 - Using the All Jobs data source, add a bunch of fields, Jan through Dec
2 - Change the date format of the end time/queue time or start time (whichever you consider to be the backup timestamp) to dd/MMMM/yyyy. This will give you dates in the format 12/February/2014. You can then perform some regex and group the data by month
3 - Set Values of each month i.e. Set Value of report field "Feb" to the value of Report Field "Size" if the newly formatted date field contains "February"
4 - You should be able to then hide all fields except Jan - Dec
Note that this will only work if your start time and end time are within the same calendar year i.e. choose a time period of 1st Jan to 31st Dec
proxy3
4 Posts
0
December 10th, 2014 02:00
Hi Frank,
I created a similar report by adding a Data Source for each Month with a different Time Window:
For last Month, use the default time window. For the other Months, change the time window as follows:
Start Time: Relative to Start of Window
Start Time Parameters: 30 Days Before
End Time: Relative to Enf of Window
End Time Parameters: 30 Days Before
Change the Start/End Time Parameters as apropriate for each Month. Unfortunately it's not possible to enter the relative start/end times in Monthly units so each colomn will not be an exact Month.
Regards