Report of User Mailbox Archive usage.

[Cdee]

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.

[Tmarques]

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.

[TonySterling]

Well if you install EV Reporting you could use the report:

Vault Store Usage by Archive 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

[Tmarques · Accepted solution]

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.

[Cdee]

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!!!