03-18-2009 12:51 AM
HI All
I have to create a report that states the following:
List all archives that the mailbox has been deleted or is not associated with it.
Any ideas?
Rob
Solved! Go to Solution.
03-18-2009 08:18 PM
If you have deleted a user then when we try to sync it will obviously fail. By default when we fail to sync a users archive 14 times in a row we will mark that mailbox as being deleted. We do this in the exchangemailboxentry table by changing the LegacyMbxDN field to Marked @ date/time.
So you could run a SQL script stating:-
select * from exchangemailboxentry where legacymbxDN LIKE '%marked%'
But you may have some whose user has been deleted but have not hit the 14 times failure so the mailbox will not be marked.
This default value can be changed but would not really recommend it as you may have some sync problems for whatever reason and mailboxes will start gettinbg marked as deleted if you set this too low.
The registry key that determines this is:-
The second way of doing this is if you are setting the billing account as if the user cannot be found that this field changes to the SID and states account unknown.
So in the VAC within the archives section you could sort on Bill usage to and then take a screenshot
03-18-2009 08:18 PM
If you have deleted a user then when we try to sync it will obviously fail. By default when we fail to sync a users archive 14 times in a row we will mark that mailbox as being deleted. We do this in the exchangemailboxentry table by changing the LegacyMbxDN field to Marked @ date/time.
So you could run a SQL script stating:-
select * from exchangemailboxentry where legacymbxDN LIKE '%marked%'
But you may have some whose user has been deleted but have not hit the 14 times failure so the mailbox will not be marked.
This default value can be changed but would not really recommend it as you may have some sync problems for whatever reason and mailboxes will start gettinbg marked as deleted if you set this too low.
The registry key that determines this is:-
The second way of doing this is if you are setting the billing account as if the user cannot be found that this field changes to the SID and states account unknown.
So in the VAC within the archives section you could sort on Bill usage to and then take a screenshot
03-18-2009 10:39 PM
Thanks for the feedback
Also running scripts with MbxArchivingState as the search.
Ill try both options and let you know how it goes.
Rob