cancel
Showing results for 
Search instead for 
Did you mean: 

expiry report

jpergola329
Level 5

hello,

is there any way to run an expiry report for all users, to see whats going to expire, total items, and where its located, i know how to do it as the user logged into outlook, and run it from there.

i have run the expiry in report mode with the totals and such, but im looking for a more detailed report.

thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

You can try these:

SE VaultStoreDB
SELECT COUNT(IdTransaction) AS NumberOfItems, SUM(ItemSize) AS TotalSize
FROM Saveset
WHERE ArchivedDate <= '12/12/2008'

or in this instance if you are using Sent Date (Modified Date in storage expiry)

USE VaultStoreDB
SELECT COUNT(IdTransaction) AS NumberOfItems, SUM(ItemSize) AS TotalSize
FROM Saveset
WHERE IdDateTime <= '12/12/2008'

View solution in original post

6 REPLIES 6

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

have you seen this blog post? https://www-secure.symantec.com/connect/blogs/storage-expiry-reports

jpergola329
Level 5

took a look at it, cant get it to work it doesnt like the LTE 'date' syntax.

thanks

 

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

instead of LTE you can try <=

jpergola329
Level 5

getting the following error.

sql is not my strong suit, thanks for all the help.

i have ev 8 sp3

thanks

 

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

You can try these:

SE VaultStoreDB
SELECT COUNT(IdTransaction) AS NumberOfItems, SUM(ItemSize) AS TotalSize
FROM Saveset
WHERE ArchivedDate <= '12/12/2008'

or in this instance if you are using Sent Date (Modified Date in storage expiry)

USE VaultStoreDB
SELECT COUNT(IdTransaction) AS NumberOfItems, SUM(ItemSize) AS TotalSize
FROM Saveset
WHERE IdDateTime <= '12/12/2008'

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

ok so for EV8 instead of SUM(ArchivedItemSize) do SUM(ItemSize)