Title: Message
You may be able to correlate that (#3) with tracking log data.  In Exchange 5.5 you can query the store to see if it's last logon was done via the same account that is in the assoc-nt-account field, but as Joe points out there's no level of accuracy to see.  You are way better off going after the user's NT/AD account for last usage, and correlate that with the messages sent by that mailbox. 
 
The logic is something like: if the user hasn't logged into the network in >3months AND no mail has been sent by that mailbox = match and delete as a dead account.  If the user has logged in in <3 months AND has sent something from the mailbox, then no match and leave alone.  If the user has not logged in >3months, but something has been sent from the mailbox, you have someone else using the mailbox and need to investigate.  If they have logged in <3months but no messages sent, then again, you need to investigate why that is.
 
promodag is a great reporting tool to help with Exchange reporting.  www.promodag.com


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe
Sent: Sunday, July 11, 2004 5:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [ActiveDir] How to Query, identify & delete the mail boxes which are not in u se for more than 3 months

Hmmm...
 
You would hope you could query the store and get this info, BUT, even if someone else looks at your calendar or I think if the system needs to look at the mailbox for some reason the store will have last logon updated to reflect that so you can't use the last logon time on the store for anything authoritative. This means everything falls on the shoulders of AD and you have the same normal question, how do I find unused accounts.
 
The answer to that is a couple:
 
1. Set up a password expiration policy and pop anyone who exceeds it by some value of X that you define.
 
2. Query every DC for last logon for every user and generate a list that way, if you have more than a few DCs or many users at all this really falls down quick.
 
3. With K3 in domain functional mode you have lastlogontimestamp which is nice.
 
 
However even with all three of those you don't really know if they are touching their mailbox, they could just be logging onto their account.
 
 
  joe
 
 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Saturday, July 10, 2004 1:04 PM
To: [EMAIL PROTECTED]
Subject: [ActiveDir] How to Query, identify & delete the mail boxes which are not in u se for more than 3 months

Hello Folks,
I was wondering, if its possible to Query, identify & delete the mail boxes which are not in use for more than 3 months & email id which have never been accessed after its creation.
 
Exchange Server 5.5 SP3-BDC, Windows 2000 Domain Controller.
 
Can any one suggest me some scripts or tweaks to achieve this.
 
Thanks for your time!
Cheers,
Athif


-----------------------------------------------------

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom/which they are addressed. If you have received this email in error please notify the system manager at the following email address: [EMAIL PROTECTED] . Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Al Faisaliah Group. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. The sender therefore does not accept liability for any errors or omissions in the context of this message, which arise as a result of Internet transmission. Finally, the recipient should check this email and any attachments for the presence of viruses. Al Faisaliah Group accepts no liability for any damage caused by any virus transmitted by this email.

-----------------------------------------------------

Reply via email to