cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine the amount of "cross archiving" ?

FreKac2
Level 6
Partner Accredited Certified

I need to find out how much is transfered/cross-archived during archiving. It's a scenario where the user archive is located on evserver1 but the mailbox exist on the exchange server archived by evserver2.

Thanks,

Fredrik

4 REPLIES 4

RahulG
Level 6
Employee

I guess the amount of data archived for the mailbox which is on the exchange server archived by EvServer 2 would be the same transfere/cross-archived .

You can run the report to find find out how much item archived per hour or day .

FreKac2
Level 6
Partner Accredited Certified

I was a bit unclear in my question, it's not just a question of one user/archive.

If possible I would like to monitor this in real time, e.g. via perfmon.

E.g. if there is a MSMQ queue that will show this type of communication.

Mohawk_Marvin
Level 6
Partner

Outgoing (MSM)queues should be created if Server 1 has the archive but Server 2 targets the Exchange

JesusWept3
Level 6
Partner Accredited Certified

Well you hit it on the head really, just use Perfmon, EV and MSMQ both have their own Perfmon counters that you can use.... but I have a query that might be insightful to you

 

SELECT COUNT(DISTINCT(S.ArchivePointIdentity)) "# of Mailboxes Archived",
       COUNT(S.ItemSize) "# of Items Archived",
       SUM(S.ItemSize) "Size of Items Archived (KB)"

FROM EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
     EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,
     EnterpriseVaultDirectory.dbo.ExchangeServerEntry ESE,
     EnterpriseVaultDirectory.dbo.ArchivingRetrievalTask ART,
     EnterpriseVaultDirectory.dbo.Task T,
     EnterpriseVaultDirectory.dbo.Root R,
     EnterpriseVaultDirectory.dbo.Archive A,
     EnterpriseVaultDirectory.dbo.VaultStoreEntry VSE,
     EnterpriseVaultDirectory.dbo.StorageServiceEntry SSE,
     EnterpriseVaultDirectory.dbo.ComputerEntry CE,
     YourVaultStore.dbo.Saveset S,
     YourVaultStore.dbo.ArchivePoint AP

WHERE EME.MbxStoreIdentity = EMS.MbxStoreIdentity
  AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
  AND ESE.ExchangeServerEntryID = ART.ExchangeServerEntryID
  AND ART.TaskEntryId = T.TaskEntryID
  AND EME.DefaultVaultID = R.VaultEntryID
  AND R.RootIdentity = A.RootIdentity
  AND A.VaultStoreEntryID = VSE.VaultStoreEntryID
  AND VSE.StorageServiceEntryID = SSE.ServiceEntryID
  AND SSE.ComputerEntryID = CE.ComputerEntryID
  AND T.ComputerEntryID != SSE.ComputerEntryID
  AND S.ArchivePointIdentity = AP.ArchivePointIdentity
  AND AP.ArchivePointId = EME.DefaultVaultId
  AND S.ArchivedDate > '2010-12-01'


The above is an EV9 Query, to make it work in EV8 and below change the following

From


WHERE EME.MbxStoreIdentity = EMS.MbxStoreIdentity
  AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity


To


WHERE EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity


And also remove the following line in the FROM Clause



EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,

Also don't forget to change YourVaultStore.dbo. to the Database name of your vault store. Also you can change the S.ArchivedDate to change the filter So for the last day you could do WHERE S.ArchivedDate > DATEADD(d, -1, GetDate())

https://www.linkedin.com/in/alex-allen-turl-07370146