• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Jun 282011
 

Storage Expiry Reports has been talked about a few times in the forums, both internally and externally.  As you may know there is a button which can be enabled in the Enterprise Vault Outlook Addin to give an end user the ability to see which items are going to be expired in the coming days.

This is great, well at least it’s a great start!

It doesn’t proactively tell users, I’ve heard people thinking about/discussing an idea of having the report auto emailed to users once per week, or changing the icon of shortcut’s (but then what if you don’t have shortcuts any more, or they’re buried somewhere down your folder structure in a folder called IMPORTANT)?

It doesn’t give an administrator an overview of all the expiry that it is about to take place.

Here are two ideas which have been logged on the Connect Forums – I’d suggest voting on them, if you want to try to see some changes in this area:

http://www.symantec.com/connect/idea/better-ev-expiry-reports
http://www.symantec.com/connect/ideas/storage-expiry-report

Also it is worth taking a look at the SQL at the bottom of this post :

http://www.symantec.com/connect/forums/storage-expiry-report

Is this something that you use as an EV Administrator?

USE VaultStoreDB
SELECT COUNT(IdTransaction) AS NumberOfItems, SUM(ArchivedItemSize) AS TotalSize
FROM Saveset
WHERE ArchivedDate LTE ’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(ArchivedItemSize) AS TotalSize
FROM Saveset
WHERE IdDateTime LTE ’12/12/2008′

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)