Re: [IMail Forum] LastLogin?
Web Login. The last POP3 login is retained through the times stamp on the lastlog.in file in the user's main mail folder. The registry value for web login is seconds since 1/1/1970. Darin. - Original Message - From: Evans Martin To: IMail_Forum@list.ipswitch.com Sent: Friday, November 21, 2008 2:20 AM Subject: [IMail Forum] LastLogin? Does the LastLogin registry value hold the last web login, the last POP3 login, the last IMAP login, etc.? Thanks, Evans Martin --- Evans L. Martin - MartekWare.Com Phone: (615) 533-0197 AOL IM: Martek01 Hosting Solutions & Custom Software Development Home of iPlus Info Browser for IMail / SmarterMail
RE: [IMail Forum] LastLogin Stamp in external database (IMail 8.15)
> I am working on a script for a client of ours and am trying to determine > how to use the LASTLOGIN field in the external database. I know the value > is supposed to be the number of seconds after 1/1/1970 from the archives. > But when I run this calculation I am coming up around 21 hours off. I accomplish this by returning out the datetime equivalent of the LASTLOGIN field from the database rather than the raw number of seconds. Then you can compare that to a variable in VBScript that holds the current date and time. Just select out this value from your database for the user you are interested in: CONVERT(datetime, DATEADD(s,LastLogin-21600,'1/1/1970 12:00 AM')) As LastLogin Note that LastLogin is in UTC so I subtract 21600 seconds from the LastLogin field to account for my time zone (CST) which is -6 hours from UTC. I hope that helps. - Andy To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
RE: [IMail Forum] LastLogin Stamp in external database (IMail 8.15)
Hi! I would also be interested in such a script. Regards, Steinar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Grant Griffith - IMail Sent: 15. desember 2005 15:53 To: IMail_Forum@list.ipswitch.com Subject: RE: [IMail Forum] LastLogin Stamp in external database (IMail 8.15) Thanks for the info Eric. However I am trying to write a script to do this on a per user basis, therefore since I can not put any arguments the tool will not work in my situation. Is the source available for this executable? Thanks, Grant Griffith EI8HTLEGS, A Division of ETC (812)932-1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Shanbrom Sent: Wednesday, December 14, 2005 11:34 PM To: IMail_Forum@list.ipswitch.com Subject: Re: [IMail Forum] LastLogin Stamp in external database (IMail 8.15) On our utilities page is a last login utility.. this might make things easier for you Eric S Grant Griffith - IMail wrote: >Hello All, > >I am working on a script for a client of ours and am trying to >determine how >to use the LASTLOGIN field in the external database. I know the value >is supposed to be the number of seconds after 1/1/1970 from the >archives. But when I run this calculation I am coming up around 21 hours off. > >Here is the VBScript I am using, can anyone tell me why the value is >coming out off? > >tmpDormantTime = DateDiff("s",date(), "01/01/1970 >00:00:00")-(daystodormant*86400) > >The daystodormant is a variable I currently have set to 90 and 86400 is >the number of seconds in a day. Therefore the tmpDormantTime should >equal the seconds for 90 days prior. That was I know if they have >logged in within the past 90 days by comparing the tmpDormantTime to the LASTLOGIN value. > >As a side note, I also check the lastlog.in file for POP3 and IMAP >connections, but that is working fine... > >Thanks, >Grant Griffith >EI8HTLEGS, A Division of ETC >(812)932-1000 > > > > >To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >List Archive: >http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ Denne emailen er skannet og funnet fri for virus Denne emailen er skannet og funnet fri for virus To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
RE: [IMail Forum] LastLogin Stamp in external database (IMail 8.15)
Thanks for the info Eric. However I am trying to write a script to do this on a per user basis, therefore since I can not put any arguments the tool will not work in my situation. Is the source available for this executable? Thanks, Grant Griffith EI8HTLEGS, A Division of ETC (812)932-1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Shanbrom Sent: Wednesday, December 14, 2005 11:34 PM To: IMail_Forum@list.ipswitch.com Subject: Re: [IMail Forum] LastLogin Stamp in external database (IMail 8.15) On our utilities page is a last login utility.. this might make things easier for you Eric S Grant Griffith - IMail wrote: >Hello All, > >I am working on a script for a client of ours and am trying to determine how >to use the LASTLOGIN field in the external database. I know the value is >supposed to be the number of seconds after 1/1/1970 from the archives. But >when I run this calculation I am coming up around 21 hours off. > >Here is the VBScript I am using, can anyone tell me why the value is coming >out off? > >tmpDormantTime = DateDiff("s",date(), "01/01/1970 >00:00:00")-(daystodormant*86400) > >The daystodormant is a variable I currently have set to 90 and 86400 is the >number of seconds in a day. Therefore the tmpDormantTime should equal the >seconds for 90 days prior. That was I know if they have logged in within >the past 90 days by comparing the tmpDormantTime to the LASTLOGIN value. > >As a side note, I also check the lastlog.in file for POP3 and IMAP >connections, but that is working fine... > >Thanks, >Grant Griffith >EI8HTLEGS, A Division of ETC >(812)932-1000 > > > > >To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
Re: [IMail Forum] LastLogin Stamp in external database (IMail 8.15)
On our utilities page is a last login utility.. this might make things easier for you Eric S Grant Griffith - IMail wrote: Hello All, I am working on a script for a client of ours and am trying to determine how to use the LASTLOGIN field in the external database. I know the value is supposed to be the number of seconds after 1/1/1970 from the archives. But when I run this calculation I am coming up around 21 hours off. Here is the VBScript I am using, can anyone tell me why the value is coming out off? tmpDormantTime = DateDiff("s",date(), "01/01/1970 00:00:00")-(daystodormant*86400) The daystodormant is a variable I currently have set to 90 and 86400 is the number of seconds in a day. Therefore the tmpDormantTime should equal the seconds for 90 days prior. That was I know if they have logged in within the past 90 days by comparing the tmpDormantTime to the LASTLOGIN value. As a side note, I also check the lastlog.in file for POP3 and IMAP connections, but that is working fine... Thanks, Grant Griffith EI8HTLEGS, A Division of ETC (812)932-1000 To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
Re: [IMail Forum] LastLogin
> The web interface puts a value in the registry called LastLogin. > What is this number? Is it milliseconds, seconds, or what? I'd like > to be able to read this value to determine when the account was last > used. In archives. It's Unix time. Seconds since 1/1/1970 00:00:00. -Sandy Sanford Whiteman, Chief Technologist Broadleaf Systems, a division of Cypress Integrated Systems, Inc. e-mail: [EMAIL PROTECTED] To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/