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!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Saleslogix OLE DB Provider Data

JB
Posts: 11

Saleslogix OLE DB Provider Data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Aug 06 4:14 PM

Does anyone know how I could access the Saleslogix provider to read session data from it. I am looking to determine who is signed into a saleslogix database (userids, etc) and also how many active connections there are to a particular Saleslogix database at one time. I am looking to get the total connections that includes all connections to the database, not just the sales client. I want the architect, admin etc included as well.

If the provider is not the place to look for this information, what avenues might I explore to obtain this information?

Any ideas appreciated.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Saleslogix OLE DB Provider Data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Aug 06 4:50 PM

Finding out the number of connections to a database is straight forward (you wouldn't need the SLX provider for this, this is database level stuff). Something like this should work:

select *  
from   master..sysprocesses 
where  dbid = db_id('database_name_here') 
           and spid > 50

BTW, you can make it dynamic so you don't need to hard-code the database name by changing it to this:

select *  
from   master..sysprocesses 
where  dbid = db_id(db_name()) 
           and spid > 50

[Reply][Quote]

JB
Posts: 11

Re: Saleslogix OLE DB Provider Data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 06 9:43 AM

Thanks for the help on the session piece. Any ideas regarding the currently signed in users?

I am looking to obtain a list of the signed in Saleslogix users for a database. I am looking to give the SLX user a list of the people signed into the system in a view screen for call center call routing.

Do you know of a stored proicedure for the Saleslogix Provider or an application function that can be used to retrieve a list of the currently signed in Saleslogix userids? Correct me if you know anything different, but I was told by SDK support at Sage that it is held in memory of the provider and nothing is written into the database itself. Any idea how to retrieve this data.

I can write this screen in an external .NET winforms app or VBS active form in the client, so if there is a way in either coding option I can use it..

Have you ever pulled this data before or is this something that cannot be done? This would be a great article for the site as I know many SLX BP developer friends that are always looking to do this, but no one I know has been able to yet...

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Saleslogix OLE DB Provider Data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 06 10:31 AM

The easiest route is to run a script when a user logs in that flags the logged in user on some table, and then remove it via another script when the user logs out. You can see an example of this in the bundle here: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=82

[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 4:21:02 PM