I'm searching for an idea how to build a report which shows me that format:
Data backed up in TB
Currently I'm able to get this result
|Server||Size Raw (TB)|
I always have to tun the report several times and I have to edit the time range - so to get the data for one year I have to run it 12 times.
My current dataflow looks like that:
Backup Save Set Details --> Copy Size (Copy) --> Set Value --> Multiply --> Group By --> End
Input Field Size
Output Field Size Copy
Size is dropped afterwards
Condition: Size Scanned is present
Set Field: Size Copy
Value Type: Report Field
Set Vaule: Size Scanned
Label: Size Raw
Field Name: Size Copy
Group By 1: Server
I'm not able to get all the monthy in one table.
Note: all Backupservers are NetWorker Servers
Thanks in advice
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.
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.
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