06-04-2012 02:29 AM
Hi Folks,
I am looking out of a script which can help mein getting users mailbox archive usage report (The same which we get on Storage Group --> Right Click--> reporting) the same way but i need the same to be sent in as an mail using a script so that i can keep a track of the users archive usage on a daily basis.
Have anyone come across such scripts if yes please do let me know it would of great help for me.
Thanks in advance.
Solved! Go to Solution.
06-04-2012 05:38 AM
First you would need to configure the report server for email delivery http://msdn.microsoft.com/en-us/library/ms345234(SQL.105).aspx
Once you have completed the above task you need to setup subscriptions to the bill usage report.
06-04-2012 05:25 AM
Hi
You able to do the following with Enterprise Vault Reporting and within SQL reporting setup subscriptions to the bill usage report or vault usage to send mail at a scheduled time daily.
06-04-2012 05:28 AM
Well if you install EV Reporting you could use the report:
Article: HOWTO57490 | | | Created: 2011-08-01 | | | Updated: 2012-03-31 | | | Article URL http://www.symantec.com/docs/HOWTO57490 |
or you could run this agains your vault store database:
SELECT ex.MbxDisplayName,
a.archiveditems as Count, (a.archiveditemsSize/1024) as 'Size'
FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize
06-04-2012 05:38 AM
First you would need to configure the report server for email delivery http://msdn.microsoft.com/en-us/library/ms345234(SQL.105).aspx
Once you have completed the above task you need to setup subscriptions to the bill usage report.
06-04-2012 08:14 AM
Thanks Tmarques it worked for me, just tested in my lab looks great.
Also Thanks Tony for the SQL script i can use it in between of a day to pull a quick results
Cheers!!!