Unsolved
This post is more than 5 years old
25 Posts
0
955
Custom Report - Server backed up date overview
Hello,
I'm searching for an idea how to build a report which shows me that format:
Data backed up in TB
| Server | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Sum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| srv1 | 1 | 1 | 2 | ||||||||||
| srv2 | 2 | 2 | 4 | ||||||||||
| srv3 | 3 | 3 | 6 | ||||||||||
| Sum | 6 | 6 | 12 |
Currently I'm able to get this result
| Server | Size Raw (TB) |
|---|---|
| srv1 | 1 |
| srv2 | 2 |
| srv3 | 3 |
| Sum | 6 |
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
Copy Size:
Input Field Size
Output Field Size Copy
Size is dropped afterwards
Set Value
Condition: Size Scanned is present
Set Field: Size Copy
Value Type: Report Field
Set Vaule: Size Scanned
Multiply
Label: Size Raw
Field Name: Size Copy
Units: MB
Value: 1
Group By
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
Kind regards
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