Frank_Noessler
2 Bronze

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

ServerJanFebMarAprMayJunJulAugSepOctNovDecSum
srv1112
srv2224
srv3336
Sum6612

Currently I'm able to get this result

ServerSize Raw (TB)
srv11
srv22
srv33
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

0 Kudos
5 Replies
RLIM
1 Copper

Re: Custom Report - Server backed up date overview

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

0 Kudos
proxy3
1 Copper

Re: Custom Report - Server backed up date overview

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

0 Kudos
Highlighted
Frank_Noessler
2 Bronze

Re: Custom Report - Server backed up date overview

Thanks

So I will do it month per month and will do my detailed analysis in excel ...


0 Kudos
finnj7
1 Copper

Re: Custom Report - Server backed up date overview

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

Frank_Noessler
2 Bronze

Re: Custom Report - Server backed up date overview

THX

I will test that!

0 Kudos