10 years ago
OpsCenter SQL query, to find client with low throughput
Hi
I need to create a sql query report in OpsCenter, so I am able to locate the clients that are performing poorly regarding backup.
So what I would like your help to create, is a report containing the following:
- Client name
- Masterserver
- Mediaserver (not important, but nice to have if posible)
- Size of backup
- Throughput
- Starttime
- Endtime
- OS
Conditions for the report:
- I would like to run it against a predefined masterserver (so I only get clients from that specifik masterserver)
- I only want to see clients in the report which is running backup slower than 5MB/s
- The report has to be timelimited, so I will be able to look at the backup 1 week back or 1 month.
I really hope one of you guys will help me with some input :-)
Br
Tommy