Written by

Question Cache Newbie · Aug 26, 2021

Question about Highest License Use in the System Dashboard

#Caché

Hi guys,

Is there a way for me to break down the what contributes to the 100% highest license use so i can clearly analyze what processes or user has consume these licenses which cause the 100% license usage?

Product version: HealthShare 2017.2

Discussion (3)0

Add reply

Comments

Eduard Lebedyuk · Aug 26, 2021

Check %SYSTEM.License queries. There are queries which provide summary and detailed information on license consumption. You can than create a task which runs every minute and if license consumption exceeds say 80%, store current license users into a separate table with a timestamp. Later you can use this table to analyze usage patterns.

0 0

Cache Newbie Aug 27, 2021 to Eduard Lebedyuk

is there a way for me to execute in SQL for the above? Sorry i'm new to cache.

0 0

Eduard Lebedyuk Aug 27, 2021 to Cache Newbie

is there a way for me to execute in SQL for the above?

Of course!

Queries are TVFs, you can CALL them or SELECT from them:

SELECT *
FROM %SYSTEM.License_ConnectionAppList()

Summary:

SELECT *
FROM %SYSTEM.License_Counts()

0 0