cancel
Showing results for 
Search instead for 
Did you mean: 
Wayne_Humphrey
Level 6
Partner Accredited Certified
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
Comments
jprknight-oldax
Level 6
This is a really nice script. I am going to wrap it up in some vbscript for formatted output to a .csv file. :)

I just have one question; What is Exchange State? I have never heard of it before now.

Thanks again,

Jeremy.
Paul_Grimshaw
Level 6
Employee Accredited Certified
MbxExchangeState 0=Normal,1=Deleted,2=Hidden
jprknight-oldax
Level 6
Thanks Paul :)
MatsHolm
Level 4
Partner Accredited
Hi!

Tried to run this on my EV SQL server but gets:

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?
GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified
Hi Mats,

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

Regards
John_Santana
Level 6

Thank you for sharing the script, however, I got this error:

 

SELECT LEFT(mbxdisplayname, 20)                   AS 'Mailbox', 
       exchangecomputer                           AS 'Exchange Server', 
       mbxitemcount                               AS '#Items (Mailbox)', 
       VS1.archiveditems                          AS '#Items (Archive)', 
       mbxsize / 1024                             AS 'Mbx Size (MB)', 
       VS1.archiveditemssize / 1024               AS 'Archive Size(MB)', 
       ( mbxsize + VS1.archiveditemssize ) / 1024 AS 'Total Size(MB)', 
       VS1.createddate                            AS 'Archive Created', 
       VS1.modifieddate                           AS 'Archive Updated', 
       mbxexchangestate                           AS 'Exchange State' 
FROM   enterprisevaultdirectory.dbo.exchangemailboxentry AS EME, 
       enterprisevaultdirectory.dbo.exchangeserverentry AS ESE, 
       evvaultstore1..archivepoint AS VS1 
WHERE  EME.defaultvaultid = VS1.archivepointid 
       AND EME.mbxarchivingstate = 1 
       AND EME.exchangeserveridentity = ESE.exchangeserveridentity
 

 

Msg 207, Level 16, State 1, Line 16
Invalid column name 'exchangeserveridentity'.
 
when I executed against the EV 9.0.4 DB on my Exchange Server 2007 ?
Version history
Last update:
‎06-27-2009 11:56 PM
Updated by: