08-07-2014 06:54 AM
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
Solved! Go to Solution.
08-13-2014 08:31 AM
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'
08-07-2014 09:24 AM
have you seen this blog post? https://www-secure.symantec.com/connect/blogs/storage-expiry-reports
08-08-2014 07:56 AM
took a look at it, cant get it to work it doesnt like the LTE 'date' syntax.
thanks
08-08-2014 08:01 AM
instead of LTE you can try <=
08-13-2014 05:35 AM
getting the following error.
sql is not my strong suit, thanks for all the help.
i have ev 8 sp3
thanks
08-13-2014 08:31 AM
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'
08-13-2014 09:05 AM
ok so for EV8 instead of SUM(ArchivedItemSize) do SUM(ItemSize)