slxdeveloper.com Community Forums

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!

Web Forums - SalesLogix Web Client (Pre-7.2)
Forum to discuss using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Client (Pre-7.2) | New Thread

View: Search:

Author

Thread: Number of users logged in - SQL code

Darren O'Donnell
Posts: 12

Number of users logged in - SQL code Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Apr 09 9:46 AM

Hi Guys,

I know in the Administrator that the number of logged in users is displayed, and the "Login" icon is different for logged in users . . .

I need to capture usage trends, so was looking to run a scheduled DB script to count the number of logged in users, and write the number c/w date/Time back to a temp table, for analysis at a later date.

Has anybody done this before, or, if not, does anybody know where the "login" status ih held? I can find last login, but not a yes/ne to say thatthe user is logged in OR out?

Any help would be appretiated, as I dont fancy going into Administrator every hour!

Cheers

Darren

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Number of users logged in - SQL code Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Apr 09 4:33 AM

This job is probably not as easy as you were hoping, I am afraid.

See here for something which should get you started:

http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=82

You cannot (AFAIK) capture the SLX logged-in users' status, even though it is displayed in Administrator - infuriating isn't it?

You might also find the results of running the SLX Profiler of interest ...

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

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): 11/22/2024 5:40:13 AM