UNSOLVED

Frank Kuhn

updated

12 years ago

FK

Frank Kuhn

25 Posts

0

1156

December 9th, 2014 02:00

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