|
| 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. | |
|
| 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? | |
|
| 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? | |
|
| 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. | |
|
| Re: E1 User Audit
Posted: 3/21/2006 10:44:54 AM | fiogf49gjkf0d Wolbo - see the other utility - E1 Sync Report. | |
|
| Re: E1 User Audit
Posted: 3/21/2006 10:44:59 AM | fiogf49gjkf0d Wolbo - see the other utility - E1 Sync Report. | |
|
| Re: E1 User Audit
Posted: 3/21/2006 10:45:07 AM | fiogf49gjkf0d Wolbo - see the other utility - E1 Sync Report. | |
|
| 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... :) | |
|
| 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 | |
|
| 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 | |
|
| 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.
| |
|
| 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 | |
|
| 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 | |
|
| 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. | |
|
| 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. | |
|
| |
| 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 | |
|
| 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!) | |
|
| 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 | |
|
| 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. | |
|
| 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. | |
|
| 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? | |
|
| 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 | |
|
| Re: E1 User Audit
Posted: 4/19/2006 11:47:31 AM | fiogf49gjkf0d Oh. That makes sense.
Thank you (again).
- enlightened | |
|
| 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 | |
|
| 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 ! | |
|
| 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. | |
|
| 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. | |
|
| 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 | |
|
| 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? | |
|
| 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. | |
|
| 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. | |
|
| 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. | |
|
| 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.
| |
|
| 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 | |
|
| Re: E1 User Audit
Posted: 7/26/2006 6:23:55 AM | fiogf49gjkf0d This is a great utility, thanks Mike. | |
|
| 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!
| |
|
| 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 | |
|
| 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! | |
|
| Re: E1 User Audit
Posted: 2/5/2007 4:13:25 PM | fiogf49gjkf0d Awesome!
Norm | |
|
| 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 | |
|
| 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
| |
|
| 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
| |
|
| 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)
| |
|
| 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 | |
|
| 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!
| |
|
| 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? | |
|
| 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. | |
|
| 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 | |
|
| 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. | |
|
| 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. | |
|
| Re: E1 User Audit
Posted: 6/9/2008 12:23:39 PM | fiogf49gjkf0d Mike,
Does the tool capture WebClient logon/logout informaiton? | |
|
| 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. | |
|
| 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. | |
|
| 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. | |
|
| Re: E1 User Audit
Posted: 2/9/2009 10:26:48 AM | fiogf49gjkf0d Great Bundle, very useful, Thanks. | |
|
| 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! | |
|
| 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 | |
|
| 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 | |
|
| 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! | |
|