Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, July 7, 2025 
 
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!
 Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: SalesLogix - Get Unused Licensed Count Using SQL
Kevin Austin
Posts: 105
 
SalesLogix - Get Unused Licensed Count Using SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jun 10 9:26 AM
Hi,

Is there a SQL statement I can run to get the number of unused licenses within SalesLogix? All help appreciated.

Kind Regards
Kevin
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: SalesLogix - Get Unused Licensed Count Using SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jun 10 10:48 AM
The closest to this is the ability to get a Count of Concurrent Users available.
This can be done via an SLX Stored Procedure called Slx_GetConcurrentAvailable

Returns the number of concurrent licenses available, up to the number requested.
Input parameters:
1 Alias
2 Number

Resultset:
1 Concurrent available
[Reply][Quote]
Kevin Austin
Posts: 105
 
Re: SalesLogix - Get Unused Licensed Count Using SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Jun 10 4:50 AM
Thanks for this but I'm getting a bit stuck with what to enter for the parameters, what ever I set the 'Number' parameters to seems to be returned in the record set, even if I set it to 1 million, it returns 1 millions and I know we don't have that many licenses (would be nice though).

Any chance you provide an example that will return the desired result? Also I'm unsure exactly what the alias does...

Many thanks
Kevin
[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/7/2025 3:50:58 PM