cancel
Showing results for 
Search instead for 
Did you mean: 

SQl query for InActive Archives.

Gurmeet_Kohli
Level 4

Hello Guys,

I've a simple question about the Archive Status result from Enterprise Vault 

To get the count of  Inactive archives I ran the following query

 

SELECT MbxDisplayName, LegacyMbxDN, mbxsize, lastmodified

FROM ExchangeMailboxEntry

WHERE PolicyTargetGroupEntryId IS NULL

and when I run the query as 

Select * from Archive where ArchiveStatus = 2 -  the the count is different.

To my knowledge 

0 => Being created

1 => Available

2 => Unavailable

3 => Closed

4 => Being deleted

So Inactive and disconnected archives are same or different please guide.

 

Regards,

Gurmeet Singh Kohli

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Andrew_S_Jones
Level 4
Employee Accredited Certified

Hi Gurmeet,

I agree with Rob, as there are several ways an archive could be considered 'inactive'.  For example an entry in the ExchangeMailboxEntry table may have a populated 'PolicyTargetGroupEntryId' however they may not be enabled for archiving, MbxArchivingState:

  • 0 = New
  • 1 = Enabled for Archiving
  • 2 = Disabled for Archiving
  • 3 = Relinked

​If a user is disabled for Archiving, this does not affect the 'Status' of their archive.  Which will still be available for the user through ArchiveExplorer/Search/etc.

Please let us know what further information you may need.

Thanks,

Andrew

View solution in original post

4 REPLIES 4

Rob_Wilcox1
Level 6
Partner

Well first of all...

 

What do you define as an inactive archive?

And.. the tables could be different because not everyone might have an archive.

Working for cloudficient.com

Andrew_S_Jones
Level 4
Employee Accredited Certified

Hi Gurmeet,

I agree with Rob, as there are several ways an archive could be considered 'inactive'.  For example an entry in the ExchangeMailboxEntry table may have a populated 'PolicyTargetGroupEntryId' however they may not be enabled for archiving, MbxArchivingState:

  • 0 = New
  • 1 = Enabled for Archiving
  • 2 = Disabled for Archiving
  • 3 = Relinked

​If a user is disabled for Archiving, this does not affect the 'Status' of their archive.  Which will still be available for the user through ArchiveExplorer/Search/etc.

Please let us know what further information you may need.

Thanks,

Andrew

Gurmeet_Kohli
Level 4

Hello guys,

Thank you for your response.

I wanted the inactive count and made it clear from my client as well and I've the required answer

Now I've a different question

1. When was EV server installed. I shared the regkey 

'HKLM\Software\KVS\Enterprise Vault\Install' - Installationdate’ but it shows the SP installed date

e.g. EV was installed on 2010 but it shows 2013 as 9.0.4 was upgraded.

2. When I ran the command 

SELECT MbxDisplayName, LegacyMbxDN, mbxsize, lastmodified

FROM ExchangeMailboxEntry

WHERE PolicyTargetGroupEntryId IS NULL

The mailbox size listed is in MB or KB.

Regards,

Gurmeet Singh Kohli

Rob_Wilcox1
Level 6
Partner
Please ... Create two new posts for your additional questions and, Mark one of the poets here as the solution if you felt they helped.
Working for cloudficient.com