Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Thursday, December 12, 2024
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
12/12/2024 12:59:02 PM
slxdeveloper.com
Now Live!
View User Profile
User Profile -
Stuart
Stuart
OAG Worldwide
fjrigjwwe9r1SiteUser:UserBio
fiogf49gjkf0d
IT Development, OAG Worldwide, Dunstable, UK
Log in
to send this member a message!
Stuart
's Contributions
Stuart
has contributed
2
comments and
0
articles.
Select to view:
Comments
Articles
Comment:
Re: E1 User Audit
fiogf49gjkf0d
Whilst this is an excellent tool, I have one small problem. It seems some users (not all, and I can't see the pattern) have their date and month of last login stored the wrong way round. And I think it happens on the 11th and 12th of the month.
We have GB date settings, and today (12 Jun 2007) we have three users logged as 06 Dec 2007 and all the others as 12 Jun 2007.
Anyone else seen this?
I have looked at the code that fires at login and it just sets the date like this:
Login(5) = cstr(now)
And in the debugger that looks like this:
? login(5)
12/06/2007 11:34:21
But the Field is like this:
? oRS.Fields("Login5")
06/12/2007 11:34:21
In query analyzer the dates look like this:
SELECT LOGIN5
FROM sysdba.E1_AUDIT
WHERE LOGIN5 > GETDATE()
LOGIN5
------------------------------------------------------
2007-12-06 10:32:06.000
2007-11-06 11:04:27.000
2007-12-06 09:56:53.000
2007-12-06 09:52:35.000
(4 row(s) affected)
Author:
Stuart
- 6/12/2007
Comment:
Re: E1 User Audit
fiogf49gjkf0d
This is a great utility, thanks Mike.
Author:
Stuart
- 7/26/2006
slxdeveloper.com is brought to you courtesy of
Ryan Farley
&
Customer FX Corporation
.
This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.
code of conduct
|
page cache (param): 12/12/2024 1:37:17 PM