Hi,
I am trying to find a way to query the daily difference of how much data is backed up on certain VMs every day (in percent and TB).
Lets say those VM's all have "XYZ" in their names.
I once made a sql query on the summary-table to query the amount of node-data backed up between the given dates X and Y.
The Script looks like this:
SELECT cast(entity as char(60)) as Nodename, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='BACKUP' ) AND start_time>'$1 00:00:00' AND start_time<'$2 00:00:00' GROUP BY entity ORDER BY "GB"
and gives Output like this:
Unfortunately I can't query single VM's (filespaces) on the summary table, only datamovers (nodes)
Does anyone have an idea on how to get the data I need?
The result should look anywhere near this:
And as mentioned, my biggest problem right now is that I am unable to query the summary of VM-names (filespaces) instead of datamovers (nodename)
Any ideas? The only thing I can think of is to collect all needed VM's under one datamover and then use my old Summary-Script the get the daily change in TB, then convert this to percent. But for multiple reasons this is absolutely not optimal.
But I'm a SQL beginner, so maybe I am missing something.
Any help would be appreciated.
Kind regards
I am trying to find a way to query the daily difference of how much data is backed up on certain VMs every day (in percent and TB).
Lets say those VM's all have "XYZ" in their names.
I once made a sql query on the summary-table to query the amount of node-data backed up between the given dates X and Y.
The Script looks like this:
SELECT cast(entity as char(60)) as Nodename, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='BACKUP' ) AND start_time>'$1 00:00:00' AND start_time<'$2 00:00:00' GROUP BY entity ORDER BY "GB"
and gives Output like this:
Nodename | GB |
Node1 | 30,02 |
Node2 | 72,84 |
Node3 | 946,87 |
VM-Datamover1 | 1698,23 |
... | ... |
Unfortunately I can't query single VM's (filespaces) on the summary table, only datamovers (nodes)
Does anyone have an idea on how to get the data I need?
The result should look anywhere near this:
Date | VM where name like 'XYZ' | Data +/- in TB | Data +/- in % |
2021-08-10 | All "XYZ" VM's | +100 TB | +10 % |
2021-08-11 | All "XYZ" VM's | -10 TB | -1 % |
... | ... | ... | ... |
And as mentioned, my biggest problem right now is that I am unable to query the summary of VM-names (filespaces) instead of datamovers (nodename)
Any ideas? The only thing I can think of is to collect all needed VM's under one datamover and then use my old Summary-Script the get the daily change in TB, then convert this to percent. But for multiple reasons this is absolutely not optimal.
But I'm a SQL beginner, so maybe I am missing something.
Any help would be appreciated.
Kind regards