Forum Discussion

John_Santana's avatar
John_Santana
Level 6
11 years ago

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

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.

Enterprise Vault
Information Governance
Reporting
Tip-How to
Windows Server (2003-2008)
  • John_Santana's avatar
    John_Santana
    Level 6
    11 years ago

    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.