The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Logged in users list?
Posted: 27 Mar 08 8:47 AM
|
I know this topic has been discussed before in the various tech forums....
But I'm really looking for a way to show a sales manager which of his salesmen are currently logged in. Since the information is not available anywhere in the database, I've been looking for other solutions. The E1_Audit solution catching the DB_login and DB_logout events doesn't seem to work for me since many of our Citrix users like to kill their sessions....
But somehow the information must be available since it's displayed in Administrator!
So I started browsing through the various SLX objects on my machine, and in the SLXLicenseMgr, I've found something called "LoggedInUsers". Does anyone have experience with this class and know how to use it?
Thanks & Kind Regards
Stefan Held |
|
|
|
Re: Logged in users list?
Posted: 27 Mar 08 9:33 AM
|
| Are they network or remote users..? Network users you should be able to tell via the Admin. Remote user.. best is to use Mike's E1 module |
|
|
|
Re: Logged in users list?
Posted: 27 Mar 08 10:35 AM
|
They are network users.
Of course I can tell via the admin. But I would like to give this feature to specific users who don't have Admin.
That's why I'm tryingto find out how to use that license mgr thing.... because I guess this is what's used inside admin...
|
|
|
|
Re: Logged in users list?
Posted: 27 Mar 08 1:41 PM
|
| You can use the E1 Audit module for *all* users. It'll be the only way you'll get a list of users. That function is strictly tied inside the Admin and has yet to come out of it, despite the massive volume of requests. |
|
|
|
Re: Logged in users list?
Posted: 28 Mar 08 8:17 AM
|
Originally posted by Jeremy Brayton
You can use the E1 Audit module for *all* users. It'll be the only way you'll get a list of users. That function is strictly tied inside the Admin and has yet to come out of it, despite the massive volume of requests. |
|
Even As of v7.2.2 - we still cannot make a "call" to get the list of logged in users...
--
RJLedger - rjlSystems
|
|
|
|
Re: Logged in users list?
Posted: 29 Mar 08 5:11 PM
|
| We've utilized a global script that writes the login and logout events to a table. Nonetheless if a user exits in a non-conventional manner, the logout is never, well, logged. For the most part it serves the purpose. A similar tool for Admin and Architect would be useful... does E1 Audit cover all SLX apps? |
|
|
|
Re: Logged in users list?
Posted: 30 Mar 08 3:46 AM
|
Well, I think there is a way you can accomplish this outside of SalesLogix, although it would be a roundabout way of doing it.
As I understand it, the following line won't work in a VBS script unless someone is logged into SalesLogix:
Set objSLX = CreateObject("SalesLogix.ClientObjix")
You can just trap the errors, and if an error occurs, the person isn't logged in - no error, and the person is logged in. If the user is logged in, you can either use the object you created and call a function to insert a small record into the database, showing at least the userid and the last checkin time, or you can hit the database directly so you don't interrupt the user's experience. If you hit the database directly, I would definitely create a very restricted account on SQL server to perform that task so you don't have vital login information available to every user.
Then it's up to you to create a screen that checks the "check in" table. |
|
|
|
Re: Logged in users list?
Posted: 30 Mar 08 8:33 AM
|
Originally posted by Rick Smith
We've utilized a global script that writes the login and logout events to a table. Nonetheless if a user exits in a non-conventional manner, the logout is never, well, logged. For the most part it serves the purpose. A similar tool for Admin and Architect would be useful... does E1 Audit cover all SLX apps? |
|
E1 (and the User Tracking App I wrote) basically does it the same way...
Mine uses a SalesLogix Global Event Handler (they are the "global scripts.. bad name.. really global event handlers) to catch the initial login - ONCE - so does E1. W catch the "last logout" (that's all you can capture) using the classic Db Close event.. Which happens many.. many times.... and is not triggered (as you point out) if someone terminates SalesLogix and does not "exit" normally.
--
RJLedger - rjlSystems |
|
|
|