How to get the number of licenses currently enabled for each user and also know whether that user is enabled or not from TIBCO Spotfire Server application database

How to get the number of licenses currently enabled for each user and also know whether that user is enabled or not from TIBCO Spotfire Server application database

This article describes a way to get the number of licenses currently enabled for each user and also know whether that user is enabled or not.

 

Here is an example SQL query that can be executed on the TIBCO Spotfire Server application database to retrieve the number of licenses currently enabled for each user and also know whether that user is enabled or not:

SELECT USER_NAME,ENABLED, COUNT(CUSTOMIZED_LICENSE_ID) AS 'NO. OF LICENSES'
FROM CUSTOMIZED_LICENSES AS CL
INNER JOIN GROUP_MEMBERS AS GM 
ON CL.GROUP_ID=GM.GROUP_ID
RIGHT OUTER JOIN USERS AS U 
ON GM.MEMBER_USER_ID=U.USER_ID
GROUP BY USER_NAME,ENABLED

The above query includes default TIBCO Spotfire service accounts like 'monitoring', 'scheduledupdates' , 'automationservices', 'nodemanager' and 'sbdfcache'.
Below is a modified SQL query example which excludes default TIBCO Spotfire service accounts:

SELECT USER_NAME,ENABLED,COUNT(CUSTOMIZED_LICENSE_ID) AS 'NO. OF LICENSES'
FROM CUSTOMIZED_LICENSES AS CL
INNER JOIN GROUP_MEMBERS AS GM 
ON CL.GROUP_ID=GM.GROUP_ID
RIGHT OUTER JOIN USERS AS U 
ON GM.MEMBER_USER_ID=U.USER_ID
GROUP BY USER_NAME,ENABLED,DOMAIN_NAME
HAVING DOMAIN_NAME!='SPOTFIRESYSTEM'

   

Column ENABLED:	0	means user is inactive and will not be able to login/use TIBCO Spotfire
	1	means user is active

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.