SQL query to calculate archived items size per day?

[rajesh_velagapu]

SQL query to calculate archived items size per day?

Below query gives me archived items count, need archived items size as well.

select * as '8/01'

from saveset

where archiveddate >= '8/01/2011' and archiveddate < '8/02/2011'

[rajesh_velagapu]

Query to calculated archived items count per day.

select count(*), as '8/01'

from saveset

where archiveddate >= '8/01/2011' and archiveddate < '8/02/2011'

[JesusWept3 · Accepted solution]

should be something like USE yourVaultStore SELECT COUNT(IdTransaction) "Archived Items", SUM(ItemSize)/1024 "Archived Items Size (MB)" FROM Saveset WHERE ArchivedDate >= DATEADD(d, -1, getDate())

[rajesh_velagapu]

Thanks!!!

Regards

Rajesh