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";