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!
|
| |
|
Re: Access who is logged in outside of administrator
Posted: 20 Jul 06 4:20 PM
|
fiogf49gjkf0d I believe this info is held with the provider and not with the database, so if there isn't a way to read this from the provider you can't.
Another option would be to customise the client to log when a user has login and logged out.
|
|
|
|
Re: Access who is logged in outside of administrator
Posted: 20 Jul 06 4:43 PM
|
fiogf49gjkf0d I guess I should have worded this post better. Yes, I need to access the connection list of the SLX provider the same way the administrator does.
When they log in and out as well as other info about the client is taken care of by a global script I wrote and I use a crystal report to display it. What I need here in simplest terms is a web page with a list of users logged in at that moment. At the moment I can open administrator to the all users tab and see this info and make a print screen. The next steps will add emailing capability and logging snapshots throughout the day. |
|
|
| |
|
Re: Access who is logged in outside of administrator
Posted: 21 Jul 06 1:05 PM
|
fiogf49gjkf0d I don't think it's in the Provider, or if it is it is an internal function that is somehow blocked from the SLXProfiler. The profiler shows these 3 statements every minute or so and when I press the "Refresh login count" button:
SELECT LICNUM FROM BRANCHOPTIONS
SELECT A1.COMPANYNAME FROM SYSTEMINFO A1 WHERE (UPPER(A1.SYSTEMINFOID)='PRIMARY')
SELECT A1.LICNUMBER, A1.USERID FROM LICENSES A1
call slx_GetConcurrentAvailable('SALESLOGIX', 0)
If I had to guess, it is doing some internal checking against the licenses and before or after the slx_GetConcurrentAvailable call is where the hidden routine is returning the logged in users. It could be an internal stored procedure only Administrator can access or it could be a routine entirely within Admin.exe itself. It's pretty clear based on the license check that they want very much to keep this contained for security reasons but exposing an external GetLoggedInUsers() function would be ideal. |
|
|
|
Re: Access who is logged in outside of administrator
Posted: 21 Jul 06 3:33 PM
|
fiogf49gjkf0d If you use a global script to capture a login timestamp and a logout timestamp it would be pretty easy to tell who is logged in. If logindate > logoutdate then your user is currently logged in. The only problem with this is if the client closes unexpectedly, I don't believe a global Application_Logout script will fire which will leave the database thinking you're still logged in.
Not as eligant or as reliable as a slx_GetLoggedInUsers() function but at least you wouldn't have to wait for Sage to pull that one out of their poop chute. |
|
|
| |
|