Get all List of all Archives and display the following:
-- Mailbox
-- Exchange Server
-- Number of Items (Mailbox)
-- Number of (Archive)
-- Mailbox Size (MB)
-- Archive Size (MB)
-- Total Size (MB)
-- Archive Created
-- Archive Updated
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVAmericasVaultStore04..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVAPJVaultStore01..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS11..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS2..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS3..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS4..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS5..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS6..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS7..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS8..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVEVGlobal1MailboxVS9..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVjournalingVaultstore..ArchivePoint'.
Server: Msg 208, Level 16, State 1, Line 22
Invalid object name 'EVMailboxVaultstore1..ArchivePoint'.
What do I need to edit to make the script to work?
Not sure if you found this already, or have solved it yourself, but what you need to adjust is in the following:
FROM
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE,
EVAmericaseVaultStore..ArchivePoint AS VS1
You need to replace EVAmericaVaultStore with the name of the vaultstore as you use. Additionally, if you check the script, it does a union for other stores. You need to adjust those also. Also take in account to remove unused unions...