Licence and module overview

Issue description

To check which user licences are assigned to and if the modules are set to active, one has to go to Administration->Add-ons->coresuite administration->Administration and three different tabs (Licence management/Global module configuration/User configuration) and select each user separately.


Solution

run the following query to get a comprehensive overview:

SELECT T0."U_ModuleGuid"
,T2."U_IsActive" AS "Globale module configuration"
,T4."U_IsActive" AS "User module configuration"
,T1."USER_CODE" AS "User Code"
,T1."U_NAME" AS "UserName"
,T2."U_LicCount" AS "Total Available Licences"
,(SELECT Count (T3."U_ModuleGuid")
FROM "@COR_COR_LICENCE" T3
WHERE T3."U_IsLUsed" = 'Y'
AND T3."U_ModuleGuid" = T0."U_ModuleGuid") AS "Licences already assigned"
FROM "@COR_COR_LICENCE" T0
LEFT JOIN "OUSR" T1
ON T0."U_UserId" = t1.INTERNAL_K
LEFT JOIN "@COR_COR_MODULES" T2
ON T0."U_ModuleGuid" = T2."U_ModuleGuid"
LEFT JOIN "@COR_COR_MODULESUSER" T4
ON T0."U_UserId" = T4."U_UserId"
AND T0."U_ModuleGuid" = T4."U_ModuleGuid"
WHERE T0."U_IsLUsed" = 'Y'
ORDER BY T0."U_ModuleGuid";
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.