Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, May 21, 2019 
 
E1 User Audit  
Description:  The E1 User Audit utility will allow you to track the last 5 login dates and times for all of your SalesLogix users, including remotes. This utility can be accessed from within SalesLogix via the menu 'Tools', 'Manage', 'User Audit'. It includes the ability to quickly find a specific user and even export the list to Excel!

Category:  Utilities
Author:  Mike Spragg
Submitted:  3/15/2006
   
Stats: 
Article has been read 13738 times

Rating: - 5.0 out of 5 by 12 users
 

fiogf49gjkf0d
E1 User Audit

The E1 User Audit utility will allow you to track the last 5 login dates and times for all of your SalesLogix users, including remotes. This utility can be accessed from within SalesLogix via the menu 'Tools', 'Manage', 'User Audit'. It includes the ability to quickly find a specific user and even export the list to Excel!




 Click here to download the bundle (for v6.2)

 Click here to download the bundle (for v7.0)


Updates

  • 11/20/2006 - Updated attached bundle. This now stores the machine name and login name as well as the last 5 logouts (as well as the last 5 logins). Thanks Mike!
  • 7/24/2006 - Updated attached bundle. Added the ComputerName and the LoginName (that the client logged into via).
  • 5/1/2006 - Updated attached bundle to contain new version including fix mentioned in comments. No more issues.

 

About the Author

  Mike Spragg
(SalesLogix Business Partner)
empath-e Limited

fiogf49gjkf0d
10 Years+ with SLX !
(Formerly of e1 Business)


View online profile for Mike Spragg
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
Wolbo
 

Re: E1 User Audit
Posted: 3/16/2006 3:33:34 AM
fiogf49gjkf0d
Great utility! We have been struggling with the lack of user audit functionality and metrics ever since we implemented SalesLogix throughout our company worldwide and unfortunately Saleslogx provides very little in this area. Is it possible to make a similar overview showing the last 5 syncs for all SalesLogix users? Additionally it would be great to have a column displaying the number of days since the last login and/or sync.
 
Sam Cayze
 

Re: E1 User Audit
Posted: 3/20/2006 2:53:47 PM
fiogf49gjkf0d
I cannot get this to work. Let me guess, it does not work on 6.2.2?
 
Sam Cayze
 

Re: E1 User Audit
Posted: 3/21/2006 10:41:47 AM
fiogf49gjkf0d
The Pluggin seems to work, but values are not populating in the fields. Are there any tables that need to be created?
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 3/21/2006 10:44:16 AM
fiogf49gjkf0d
Sam, you need to ensure that you set the DBOpen to the E1AS_DBOpen command - check the bundle for the actual name.
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 3/21/2006 10:44:54 AM
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 3/21/2006 10:44:59 AM
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 3/21/2006 10:45:07 AM
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.
 
Sam Cayze
 

Re: E1 User Audit
Posted: 3/21/2006 11:40:43 AM
fiogf49gjkf0d
"Sam, you need to ensure that you set the DBOpen to the E1AS_DBOpen command - check the bundle for the actual name."

Sorry, I am not grasping that... :)
 
Sam Cayze
 

Re: E1 User Audit
Posted: 3/21/2006 11:42:54 AM
fiogf49gjkf0d
Do I need to set:
objSLXDB = New SLX_DB

to my database?

Which would be

objSLXDB = SLXDEV
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 3/21/2006 11:43:42 AM
fiogf49gjkf0d
Sam,

In the Architect, you have to go to "Tools", "Client Options" and then in the DBOpen event select the script plugin Mike mentioned. In order for the values to populate this script needs to fire when the database is opened by a user.

Make sense?

-Ryan
 
Christian Janelle
 

Re: E1 User Audit
Posted: 3/28/2006 1:22:31 PM
fiogf49gjkf0d
Mike, great program but the only drawback I find it’s when the user refresh the database with CTRL-F5 because this action fire the DB OPEN and DB CLOSE actions calling your LOGIN_DBOPEN script again and stamping a new login date.

Try to put a global variable “LOGIN” at the start of your program and a global variable “LOGOUT” on the DB CLOSE action but because the CTRL-F5 fire the DB CLOSE action at the same time, always a new login.

Maybe someone else have a better solution.
 
Tim Hogan
 

Re: E1 User Audit
Posted: 3/30/2006 5:17:25 AM
fiogf49gjkf0d
Thanks Mike great utility. Where do I find the E1 Sync Report utility you mention I can't seem to find it on this site. 80% of our users are remotes so reporting when they sync last would be very useful.
Cheers Tim
 
Tim Hogan
 

Re: E1 User Audit
Posted: 3/30/2006 5:33:33 AM
fiogf49gjkf0d
Found it! Sorry I was blinded by the fridge light. :-)
Cheers Tim
 
MB
 

Re: E1 User Audit
Posted: 4/17/2006 1:57:15 PM
fiogf49gjkf0d
quite new to SalesLogix... could someone tell me how and where to load this utility???
Thank you :)

- Utterly lost.
 
MB
 

Re: E1 User Audit
Posted: 4/17/2006 2:36:23 PM
fiogf49gjkf0d
Just to clarify, I've already downloaded the utility but I don't know what next.
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/17/2006 2:37:14 PM
fiogf49gjkf0d
It's at the top - of this thread or here: http://www.slxdeveloper.com/resources/articles/82/E1-UserAudit.zip
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/17/2006 2:40:52 PM
fiogf49gjkf0d
Right, it's very simple (didn't think I needed notes!) - simply add the menu to the system - in Architect go to Tools | Client Options and add the menu strip. Then, to ensure it captures data, you need to add the E1AS_DBOpen script to the DB Open (in the same view) - so that it runs when the user logs in. To find the results - you will find this in Tools | Manage | User Audit - in the SalesLogix client
 
MB
 

Re: E1 User Audit
Posted: 4/17/2006 4:33:00 PM
fiogf49gjkf0d
Is there a specific place (folder, perhaps) that this .sxb file should be located on the server in order for me to see this plugin when I try to add it to the menu under Client Options? (I'm so sorry for such eye-rolling questions!)
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/17/2006 4:37:15 PM
fiogf49gjkf0d
MB,

The sxb file extension is for a SalesLogix bundle. Think of this as an install for the addin. To install this bundle in SLX you need to open the Administrator and then go to the Bundles section on the side nav bar. Then right-click to browse to this sxb file, and then install it. Once installed you can dispose of the sxb file.

-Ryan
 
MB
 

Re: E1 User Audit
Posted: 4/17/2006 5:09:33 PM
fiogf49gjkf0d
woo hoo!!! That wasn't so bad...
Thank you, Ryan and Mike.
 
MB
 

Re: E1 User Audit
Posted: 4/17/2006 5:10:27 PM
fiogf49gjkf0d
woo hoo!!! That wasn't so bad...
Thank you, Ryan and Mike.
 
MB
 

Re: E1 User Audit
Posted: 4/19/2006 10:47:28 AM
fiogf49gjkf0d
Hi again.
When I view the User Audit, it shows the correct timestamp, but in the table (E1 Audit), the timestamp is waaay off. For instance, I logged in this morning at 7:31 and User Audit screen shows the correct time, but when I go to E1 Audit table, the most recent login is today at 2:31.
Any idea?
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/19/2006 11:36:40 AM
fiogf49gjkf0d
MB,

If you're looking directly at the table keep in mind that all dates/times are stored in UTC. When you view the date/time in SLX the SLX provider calcuates the date/time value based on your offset (ie: makes it *your* local time). This is normal.

-Ryan
 
MB
 

Re: E1 User Audit
Posted: 4/19/2006 11:47:31 AM
fiogf49gjkf0d
Oh. That makes sense.
Thank you (again).

- enlightened
 
Dhany



E1 User Audit
Posted: 4/22/2006 4:53:35 AM
fiogf49gjkf0d
Thanks a lot Mike, It's really ease up my work.
I strongly believe that this kind of logging should be implemented in SalesLogix out of the box.
Are there any intention on including this feature in the next version of SalesLogix ?

Dhany
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/22/2006 4:24:08 PM
fiogf49gjkf0d
You're right - it should be. Hopefully, it will make it into v7 !
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/25/2006 7:40:14 PM
fiogf49gjkf0d
**** SERIOUS ISSUE WITH THIS BUNDLE ****

It's come to my attention that there is a serious flaw with the ActiveScript part of this bundle. Essentially, when this was converted from Legacy code the LogSetGlobalID was carried through. However, this appears to cause a sync issue as it is not cleared. This didn't cause an issue with v5.x nor 6.1/6.2.x - the error appears to be 6.2.4. The error will manifest itself as the inability to record/see changes on the main detail views on other remote databases/users. Auxialliary records are created - but changes to the main details are not syncing.

My apologies if you have been affected. I have asked Ryan to post the new bundle.
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 4/25/2006 7:42:30 PM
fiogf49gjkf0d
If you need the bundle before Ryan has a chance to upload - please contact me directly.
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 5/1/2006 11:46:04 AM
fiogf49gjkf0d
Post has been updated with Mike's new bundle. If you previously downloaded the bundle before please download and reinstall. The new posted bundle contains Mike's fixes, so the previously mentioned issues are no longer present.

Thanks.
-Ryan
 
David Henry
 

Re: E1 User Audit
Posted: 5/3/2006 9:44:28 AM
fiogf49gjkf0d
Mike,

Does the updated bundle work on 6.2.1 as well as 6.2.4?

Also, the ability to quick "FIND" a user is not on the form. However, the option to "DO NOT DISPLAY RETIRED USERS" is available. Do you have an updated bundle with both options?
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 5/3/2006 11:41:55 AM
fiogf49gjkf0d
Sorry, yes, the screenshots (as you can guess) apply to v5.2 when this was first done. The Find option doesn't work in 6.2 due to a missing call ("JumpToTypeAhead") - and the workaround is not efficient ! Yes, will work in any version of 6.x.
 
John Gundrum

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 5/15/2006 8:27:01 AM
fiogf49gjkf0d
Ugh.. I tested this in our development database and all worked fine. Now I tried installing the bundle to our production database and when I logged in I get this error

An unusual error has occurred when executing System:E!AS_DBOpen. Contact your system administratot. 0x0 @0: ActiveScripts System:E1AS_DBOpen Exception: Could not load plugin System:E1AS_DBOpen

I released the menu strip and set the dbopen and checked it. All seems fine. I'll check again just to triple check.

Any ideas?

Thanks,
John G.
 
John Gundrum

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 5/15/2006 9:00:47 AM
fiogf49gjkf0d
Ok.. Found out some interesting aspects for this. The bundle specifically states to release the menu strip. Thats all I released. For this I released it to the the group Marketing and the team Sales Managers. In the test system I tested using the Admin account (my bad)

When I logged in as myself it was giving the error. Which prompted the previous message. I started fiddling around some and tried releasing the menu strip to Everyone since thats how I did it in the development database. This did not work and ultimately was not who neede to see this.

I knew the other plug-ins were not released. I decided to release the DBOpen active script. This solved the login issue. But now I got an error when opening the audit form from the menu. Now I went back to Architect and release the active form and ..... it all worked!!! So with some trial and error this is what I've concluded as far as releasing the individual plug-ins

E1AF_UserAudit - Release to selective users
E1AS_DBOpen - MUST be released to Everyone
E1MS_UserAudit - Release to selective users

John G.
 
Jeff Wargin
 

Re: E1 User Audit
Posted: 5/30/2006 4:24:34 PM
fiogf49gjkf0d
First I want to say that I think this is a very cool application, unfortunately I ran into some problems. I installed this application and started noticing a problem with remotes getting updates made to account.account. Once I removed the plugin everything synchronizes just fine. I went back over the notes and back and forth in my test environment but I was unable to get my remotes to sync correctly with the plugin installed. Again I think it's a slick utility and hope to figure out what might be causing the conflict so we can use it in the future.
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 7/24/2006 6:08:34 PM
fiogf49gjkf0d
Just wanted to let everyone know that Mike updated the bundle to include the ComputerName and LoginName. From Mike:

"Following feedback from David Henry at National City Mortgage I added the ComputerName and the LoginName (that the client logged into via) to this util"

Thanks Mike!

-Ryan
 
Stuart



Re: E1 User Audit
Posted: 7/26/2006 6:23:55 AM
fiogf49gjkf0d
This is a great utility, thanks Mike.
 
Troy Dawson
 

Re: E1 User Audit
Posted: 10/27/2006 8:54:46 AM
fiogf49gjkf0d
I have successfully loaded the bundle, but I am getting an error when I try to use it. I select Tools>Manage>User Audit and get this error: 'Included Script: SYSTEM: EXPORT_GRID_RS_TO_EXCEL, is missing'. I have searched my database and I do not have this script installed. I am on version 6.1.1.1018. Is this a standard script? I recently inherited this system, so I do not know what may have been deleted or modified in the past. I don't necessarily need to export to Excel, if there is a way to skip this and just view it onscreen that would be adequate. *Note* - I am not a VB programmer...yet. Any help would be greatly appreciated, but feel free to 'dumb it down' if you can. Thanks!
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 11/19/2006 11:51:55 AM
fiogf49gjkf0d
Jeff - please download the latest bundle to resolve your sync issue.
Troy - sorry, will only work in 6.2 or above ! However, if you aren't planning to migrate any time soon then please contact me - you should be able to take the same script from 6.2 and it should work in 6.1
Everyone - I've asked Ryan to update the bundles - it now also stores/reports the last 5 logouts as well. There are two bundles - for 6.2.x and for v7.x

Regards
Mike
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 11/20/2006 3:57:25 PM
fiogf49gjkf0d
Added updated bundles from Mike.

Per Mike:
The bundle now stores the machine name and login name as well as the last 5 logouts (as well as the last 5 logins)

Thanks Mike!
 
Norman Rice



Re: E1 User Audit
Posted: 2/5/2007 4:13:25 PM
fiogf49gjkf0d
Awesome!


Norm
 
Galanda A. Brooker
 

Re: E1 User Audit
Posted: 6/7/2007 3:11:27 PM
fiogf49gjkf0d
I recently have put this utility in production and it works great.
However, I have a couple of questions.
1. The createuser and createdate are null for each record. Why is that?
2. I have a remote user and a remote office user whose audit information does not appear to have returned to production. I have no clue why and would like to know what I should look at to try and figure out why their info isn't being captured and/or why it isn't returning to production.
3. What does the modify date capture? I have some users with an audit record with information for login and logout with no modify user/date information.

Thanks for the assistance!
GAB
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 6/7/2007 5:33:52 PM
fiogf49gjkf0d
With (1) - no need, as they are added into a different column
2) - specific to your site - sorry !!
3) - same as (1) - the date/time are captured into the last 5 logins (after being shuffled backward).

Cheers
Mike
 
Galanda A. Brooker
 

Re: E1 User Audit
Posted: 6/8/2007 12:03:51 PM
fiogf49gjkf0d
Thanks Mike. I thought so #1 and #3, but I figured I would post so that when I received answer I would have "back up" for my supervisor.

As for #2, I understand that as well, I just thought there might be a setting on the user machine or the production that may have been able to give me a clue. I know the remote user is logging in as I am getting updated tef files every day, just not the audit info.

I'll keep digging, thanks!!!

Galanda A. Brooker
 
Stuart



Re: E1 User Audit
Posted: 6/12/2007 8:14:51 AM
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)
 
Janie Nutter



Re: E1 User Audit
Posted: 7/9/2007 3:01:09 PM
fiogf49gjkf0d
This tool is great. We have the Export to Excel function turned off for all the users - don't want our client list walking out the door - but the Excel Export still functions just fine for the Admin Login. Managers will just have to request a list.
I even customized the form with our logo... No Problem! thanks
 
Ron LeSieur
 

Re: E1 User Audit
Posted: 8/21/2007 8:14:13 AM
fiogf49gjkf0d
Mike,

Very slick! I now have a tool to ensure people are actually using the system as they are being intructed, and I didn't have to create my own.

Thanks!
 
Greg Jebb
 

Re: E1 User Audit
Posted: 1/9/2008 6:31:00 AM
fiogf49gjkf0d
Fantastic, I've been trying to figure out how to do this myself.

One question however, the tool records the time against the user on the DBOpen/Close events, how would it handle itself if a user were to terminate the saleslogix process? I'm guessing the DB Close script wouldnt be run and the 5 logon/off times would be offset?
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 1/12/2008 5:40:11 AM
fiogf49gjkf0d
"how would it handle itself if a user were to terminate the saleslogix process"

You are correct of course - nothing could handle that and the next login would overwrite the last in a round-robin fashion.
 
RJ Samp

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 1/17/2008 9:54:51 AM
fiogf49gjkf0d
I added a TABLE years ago to record every login and logout (on the same record for each 'pair' of user ins and outs)......it's part of the Global System script....... don't have to worry about last 5 only and overwriting.....

RJ Samp
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 1/17/2008 10:19:21 AM
fiogf49gjkf0d
How does it maintain it's size ? In my experience - no-one wants to know about year dot - just relevance. The overwriting is deliberate for self-maintenance purposes.
 
Greg Jebb
 

Re: E1 User Audit
Posted: 1/17/2008 10:27:18 AM
fiogf49gjkf0d
I plan on expanding the amount of data collected. We're in the process of changing our SLX licencing network vs concurrent. Seeing who uses slx when over a month period should help us calculate the most cost effective licencing scheme.
 
Frank Chaffin
 

Re: E1 User Audit
Posted: 6/9/2008 12:23:39 PM
fiogf49gjkf0d
Mike,
Does the tool capture WebClient logon/logout informaiton?
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 6/9/2008 12:26:38 PM
fiogf49gjkf0d
No, sorry Frank - just LAN. However, the table would be there anyway - so you could add the web into the mix with some web code. Which, afaik, no-one has done yet.
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 6/9/2008 12:53:46 PM
fiogf49gjkf0d
It would be easy enough to build this for the 7.2 Web client for logins, however, for logouts it would be different. Session timeouts would reflect as a logout, even though the user might not really have inteneded to logout, per se.
 
Frank Chaffin
 

Re: E1 User Audit
Posted: 6/9/2008 5:04:30 PM
fiogf49gjkf0d
The installation where I want to deploy a tool to capture WebClient logon's is running 7.0.2. I was hoping to find something to work with the older Web components.
 
Simon Morris
 

Re: E1 User Audit
Posted: 2/9/2009 10:26:48 AM
fiogf49gjkf0d
Great Bundle, very useful, Thanks.
 
Kevin
 

Re: E1 User Audit
Posted: 9/2/2009 10:28:48 AM
fiogf49gjkf0d
Mike - What needs to be done for this to run in a v7.5.1 LAN install? I installed the bundles, and the screen appears, but it is not tracking the logins. What am i missing?

Thanks!
 
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Re: E1 User Audit
Posted: 9/2/2009 10:48:30 AM
fiogf49gjkf0d
Hi Kevin
Did you remember to change the Tools | Client Options in Admin to set the startup scripts to EM_AS_xxx as per notes - send me an email directly for help - mike.spragg@empath-e.com
 
Kevin
 

Re: E1 User Audit
Posted: 9/2/2009 10:56:21 AM
fiogf49gjkf0d
Mike - That's the detail I was missing. It is working great now.

Many thanks!
Kevin
 
mark b
 

Re: E1 User Audit
Posted: 11/4/2009 9:07:24 PM
fiogf49gjkf0d
Has anyone been able to use this on the web client? We are using 7.5.1 atm and would love to be able to use this. Thanks in advance!
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2019 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 5/21/2019 2:39:39 PM