Automatic License Usage report

  

Hi,


To retrieve the current number of AO used, I can access a link in Service Center : LicenseUsage.aspx.

I was wondering if there is any automatic way to generate this report, using an SDK or a REST API.


Thanks,

George

Maybe this SQL can get you started. Run it in your OutSystems DB. IT will show you the SoftwareUnis used for each espace. You can then use this anywhere you like to generate an automatic report.


SELECT  DBO.[OSSYS_ESPACE].NAME
      , DBO.[OSSYS_REPORT_SU].[OMLCOMPLEXITY] AS SoftwareUnits
      FROM  DBO.[OSSYS_APPLICATION]
INNER JOIN  DBO.[OSSYS_APP_DEFINITION_MODULE]
        ON  DBO.[OSSYS_APP_DEFINITION_MODULE].[APPLICATION_ID] =  DBO.[OSSYS_APPLICATION].[ID]
INNER JOIN  DBO.[OSSYS_MODULE]
        ON  DBO.[OSSYS_MODULE].[ID] =  DBO.[OSSYS_APP_DEFINITION_MODULE].[MODULE_ID]
INNER JOIN  DBO.[OSSYS_ESPACE]
        ON  DBO.[OSSYS_ESPACE].[ID] =  DBO.[OSSYS_MODULE].[ESPACE_ID]
INNER JOIN  DBO.[OSSYS_REPORT_SU]
        ON  DBO.[OSSYS_REPORT_SU].[ESPACEID] =  DBO.[OSSYS_ESPACE].[ID]
     WHERE  DBO.[OSSYS_APPLICATION].[IS_ACTIVE] = 1

Advanced SQL version:

SELECT  {Espace}.[Name]
      , {Report_Su}.[OMLComplexity] AS SoftwareUnits
      FROM  {Application}
INNER JOIN  {App_Definition_Module}
        ON  {App_Definition_Module}.[Application_Id] =  {Application}.[Id]
INNER JOIN  {Module}
        ON  {Module}.[Id] =  {App_Definition_Module}.[Module_Id]
INNER JOIN  {Espace}
        ON  {Espace}.[Id] =  {Module}.[Espace_Id]
INNER JOIN  {Report_Su}
        ON  {Report_Su}.[EspaceId] =  {Espace}.[Id]
     WHERE  {Application}.[Is_Active] = 1