Question about Highest License Use in the System Dashboard

Question

Question

Cache Newbie · Aug 26, 2021

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

Log in or sign up to continue

Eduard Lebedyuk · Aug 27, 2021

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

score 1 · Answer 1 · 2021-08-26T08:38:32-04:00

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.

score 0 · Answer 2 · 2021-08-27T05:25:59-04:00

Cache Newbie · Aug 27, 2021

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

0 0