
UNSOLVED
FK
Frank Kuhn
25 Posts
0
1157
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
Responses (0)
Solutions (0)
