10-09-2013 10:07 AM
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
Solved! Go to Solution.
10-09-2013 12:38 PM
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:
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
10-09-2013 10:37 AM
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.
10-09-2013 12:38 PM
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:
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
10-09-2013 03:11 PM
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
10-09-2013 03:39 PM