While not as quick as checking the directory, 2006.2 adds a nice login audit string to the webserver log file -
2007-03-13 00:01:25 1.2.3.4 - 192.168.1.33 443 POST /IClient/login.aspx Login+Attempt:[EMAIL PROTECTED]:[EMAIL PROTECTED]:+en-US 302 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) The logs could be post-processed to update for web login information. ----- Original Message ----- From: Grant Griffith To: [email protected] Sent: Tuesday, March 13, 2007 2:12 PM Subject: RE: [IMail Forum] IMail 2006 Question Tripp, That is exactly what we are doing right now by checking the lastlog.in file timestamp and the database field. Is there a way to determine if they have logged in via webmail to see if they are using it anymore? We basically mark the account as dormant and disable it if it is not used for 90 days. This is something that we must be able to do. Thanks, Grant Griffith Web Application Developer Enhanced Telecommunications http://www.etczone.com 812-932-1000 ------------------------------------------------------------------------------ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tripp Allen Sent: Tuesday, March 13, 2007 2:06 PM To: [email protected] Subject: RE: [IMail Forum] IMail 2006 Question We don't recommend that you ever manually access the .uid or .mbx files as you could interrupt other processes using the files. If you're thinking of using this to determine if an account is inactive I don't think that's a valid case as the account probably will still be receiving mail (spam) which would update the UID. Tripp ------------------------------------------------------------------------------ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Grant Griffith Sent: Tuesday, March 13, 2007 1:50 PM To: [email protected] Subject: RE: [IMail Forum] IMail 2006 Question Thanks for the info Tripp. Therefore you are telling me that I can rely on this .uid file to tell if the mailbox has been accessed at all? Therefore I would be able to ignore the lastlog.in file after upgrading? Thanks, Grant Griffith Web Application Developer Enhanced Telecommunications http://www.etczone.com 812-932-1000 ------------------------------------------------------------------------------ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tripp Allen Sent: Tuesday, March 13, 2007 1:44 PM To: [email protected] Subject: RE: [IMail Forum] IMail 2006 Question .UID files can be updated anytime the associated mailbox is accessed by any of the IMail services (POP, IMAP, Web Client, Queue Manager etc). Tripp ------------------------------------------------------------------------------ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Grant Griffith Sent: Tuesday, March 13, 2007 1:33 PM To: [email protected] Subject: RE: [IMail Forum] IMail 2006 Question Can someone at IPSwitch confirm when the .uid files are updated? Thanks, Grant Griffith Web Application Developer Enhanced Telecommunications http://www.etczone.com 812-932-1000 ------------------------------------------------------------------------------ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike N Sent: Tuesday, March 13, 2007 12:19 PM To: [email protected] Subject: Re: [IMail Forum] IMail 2006 Question POP3 updates lastlog.in just as before. Web messaging does not update this file, nor the lastlogin field in the database record. Web Messaging updates some .UID files in the user's folder, but I haven't checked to see if web messaging is the only thing that touches these files. Just be aware that we saw these problems in the external DB under 2006.2 - I haven't heard if they have been fixed or confirmed (sent a test case for the first item to Ipswitch): - Full mailbox notification on external DB fills up the mailbox. - Random lost password and access flags with external DB. Also, if your external DB is on another machine, you must update the IMail WebClient app's web.config under the appropriate section - similar to this article, which needs to be updated for 2006.2 - http://support.ipswitch.com/kb/IM-20051206-DM07.htm 2006.2 is great otherwise, and solves many issues with 2006.1. ----- Original Message ----- From: Grant Griffith To: [email protected] Sent: Tuesday, March 13, 2007 11:10 AM Subject: [IMail Forum] IMail 2006 Question Hello All, We are planning on upgrading soon from 8.22 and I have a script that runs every week that checks for accounts that are not being used by looking at the lastlog.in file and also the web messaging time stamp in our SQL Server database. That way I check both POP3 logins and Webmail logins. Is this done differently in IMail 2006? Are both of those fields still used and used the same as it was in 8.22? Can anyone check on this for me? Thanks, Grant Griffith Web Application Developer Enhanced Telecommunications http://www.etczone.com 812-932-1000
