** Description: Archiving Rate by hour.
**
** Requirements: Updated the Vault databases as required, and update the Vault store identifier to match. Change VaultstoreX to
** your first vaultstore and VaultstoreY to your second, you can add as many as you need to get them all.
** Then import into excel and create a pivot chart.
select "Vault Store" = 'VaultStoreX',
"Archived Date" = left (convert (varchar, s.archiveddate,20),14)+'00',
"Hourly Rate" = count (*),
"MB (original)" = sum (sp.originalsize)/1024/1024,
"MB (compressed)" = sum (s.itemsize)/1024
from VaultStoreX.dbo.saveset S INNER JOIN
VaultStoreX.dbo.savesetproperty SP on S.savesetidentity = SP.savesetidentity
Where left(convert (varchar, s.archiveddate,20),14)+'00' > GETDATE() - 2
group by left (convert (varchar, s.archiveddate,20),14)
Union
select "Vault Store" = 'VaultStoreY',
"Archived Date" = left (convert (varchar, s.archiveddate,20),14)+'00',
"Hourly Rate" = count (*),
"MB (original)" = sum (sp.originalsize)/1024/1024,
"MB (compressed)" = sum (s.itemsize)/1024
from VaultStoreY.dbo.saveset S INNER JOIN
VaultStoreY.dbo.savesetproperty SP on S.savesetidentity = SP.savesetidentity
Where left(convert (varchar, s.archiveddate,20),14)+'00' > GETDATE() - 2
group by left (convert (varchar, s.archiveddate,20),14)
order by "Vault Store", "Archived Date" desc
