Forum Discussion

Cdee's avatar
Cdee
Level 6
13 years ago

Report of User Mailbox Archive usage.

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.

Enterprise Vault
Information Governance
Reporting
Tip-How to
  • Tmarques's avatar
    Tmarques
    Level 4
    13 years ago

    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's avatar
    TonySterling
    Moderator
    13 years ago

    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

  • Cdee's avatar
    Cdee
    Level 6
    13 years ago

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