Forum Discussion

dorlow615's avatar
dorlow615
Level 4
9 years ago

Enterprise Vault SQL command to see usage for an archive?

We have our EV servers that are pointing to SQL servers for the database.  When I want to see how much space a certain user is using in EV, I go to the EV server they're provisioned on and opened a web browser and browse to http://localhost/enterprisevault/usage.asp. It takes forever for this page to load.  Does anyone have a good SQL query I could just run from the SQL server that would return the same information and I could return it for just one user instead of every user provisioned on that server?

Enterprise Vault
Information Governance
Monitoring
Troubleshooting
  • TonySterling's avatar
    TonySterling
    9 years ago

    You could use this:


    --This gives the archive name and size of archive in MB
    --Runs against the VaultStore 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

    WHERE ex.MbxDisplayName =  'My.User'
    GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize

1 Reply

Sort By
  • TonySterling's avatar
    TonySterling
    Moderator
    9 years ago

    You could use this:


    --This gives the archive name and size of archive in MB
    --Runs against the VaultStore 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

    WHERE ex.MbxDisplayName =  'My.User'
    GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize