cancel
Showing results for 
Search instead for 
Did you mean: 

Need some help in modifying SQL script to capture the total amount of data for the past 2 years in EV Vault Store ?

John_Santana
Level 6

Hi People,

I cannot find the total amount of data in EV Vault Store for the past two years by using the EV Operations Manager website (http://EV-VM1/MonitoringWebApp/default.aspx), so I manage to google around the script and found one as follows:

USE EVvaultstore1-DB 

SELECT"Archived Date" = LEFT (CONVERT (VARCHAR, archiveddate, 20), 10), 
      "Daily Rate" = Count (*), 
      "Size (MB)" = Sum (itemsize) / 1024
FROM   saveset 
WHERE  archiveddate > Dateadd(year, -2, Getdate ())  
GROUP  BY LEFT(CONVERT (VARCHAR, archiveddate, 20), 10) 
ORDER  BY "archived date" DESC 

the output is in daily rate but I'm not sure if that is reflecting the correct total disk space size that I need to provision to be provisioned on the new CIFS share that I need to build for EV 10 migration.

1 REPLY 1

John_Santana
Level 6

here's the result:

Archived Date Daily Rate Size (MB)
2014-05-06    3950      578
2014-05-05    118337    15660
2014-05-04    391353    42781
2014-05-03    164474    17206
2014-04-15    28445     3252
2014-04-14    152954    15943
2014-04-13    237248    27416
2014-04-12    264741    26574
2014-04-01    11115     1197

is the column itemsize is in Kilobytes size or in Byte size ? ebcause I have put /1024 to make it more meaningful and easier to read.