topic Re: Verify how many users logged into the Qlik Sense HUB in Management & Governance

Verify how many users logged into the Qlik Sense HUB

hugo_andrade — Thu, 24 Mar 2016 23:42:52 GMT

Hello everyone,

In QlikView we could verify in real-time how many applications were open and what users were connected to Access Point.

Is there a way to verify what applications in use and users logged in the Qlik Sense HUB?

Any method is OK.

Verifying the LOGs, API call, anything that's precise.

Thank you.

Re: Verify how many users logged into the Qlik Sense HUB

Gysbert_Wassenaar — Fri, 25 Mar 2016 06:53:39 GMT

Afaik that's what the Operations Monitor app is for: Session Overview ‒ Qlik Sense

Re: Verify how many users logged into the Qlik Sense HUB

hugo_andrade — Fri, 25 Mar 2016 18:38:29 GMT

Gysbert, thank you.

I understand your point.

I am assuming we cannot view it in real time. But the Session Overview tab is useful if you had just reloaded the application and select the latest time period.

Again, thank you. Any time I want access to this information, I will reload the app.

If there's another way, I am interested as well.

Thanks.

Re: Verify how many users logged into the Qlik Sense HUB

Gysbert_Wassenaar — Fri, 25 Mar 2016 18:53:39 GMT

Well, there's no one stopping you from reloading the monitor app if you want to see the actual status of current sessions. Sessions don't tend to have durations of seconds, so real time isn't really significantly more accurate in practice if you reload before opening the app. But you can always use another tool to read the session log files if you want millisecond real time status information.

Re: Verify how many users logged into the Qlik Sense HUB

hugo_andrade — Fri, 25 Mar 2016 19:00:18 GMT

I like where you are going. Maybe one application that loads the latest session log and bring me the information.

Another good thing: the load will be shorter than the entire Operations Monitor app.

Thank you for your help!

Re: Verify how many users logged into the Qlik Sense HUB

hugo_andrade — Fri, 25 Mar 2016 21:47:24 GMT

Gysbert, again, thank you for your input.

check the attachment. I just finished it.

Please set the server name in the script. The app has no data.

Re: Verify how many users logged into the Qlik Sense HUB

korsikov — Tue, 29 Mar 2016 15:05:16 GMT

i have 2.0.5 QS server and in audit doesnot have document. only AppId. And this anon users active session is negative vaule

Re: Verify how many users logged into the Qlik Sense HUB

korsikov — Wed, 30 Mar 2016 05:57:07 GMT

As I thought, a negative value was due to the fact that at the time of launching the application users already in the system and simply disconnect from it. Now shows the correct value.

Re: Verify how many users logged into the Qlik Sense HUB

mountaindude — Tue, 26 Jul 2016 21:17:34 GMT

Parsing log files is fine, but on a big Sense cluster it takes time, even when done incrementally.

Let's say we want an update on user count every minute, in order to be able to for example use a corporate instant messaging tool to let all current users know that Sense will be restarted in x minutes. Or other similar use cases.

Reloading the operations monitor takes 15 minutes or more, that's not an option.

The only options I can see are

1. Use the session begin/end log messages and keep track of what users have open sessions, at any given time. Bit of an ugly solution... much better would be

2. Call an API to get a list of currently active users. But I can't find that API... Does it exist??

Re: Verify how many users logged into the Qlik Sense HUB

lucienorrin — Thu, 15 Dec 2016 16:33:41 GMT

Did anyone find a solution for this?

Thanks.

Re: Verify how many users logged into the Qlik Sense HUB

mountaindude — Thu, 15 Dec 2016 16:59:52 GMT

Sort of.

We listen to session begin/end and connection open/close events from the logging framework, and keep counters based on those events. Works ok.

That work has been packaged in the Butler project, GitHub - mountaindude/butler: Node.js proxy, extending Qlik Sense with both out- and in-bound connectivity

I have also created a small node.js server that monitors the health API, https://help.qlik.com/en-US/sense-developer/3.1/Subsystems/EngineAPI/Content/GettingSystemInformation/HealthCheckStatus.…

Works ok too, at least as long as you send your request to the root endpoint of a server - that API returns incorrect information when used against a virtual proxy.

Re: Verify how many users logged into the Qlik Sense HUB

kevincase — Thu, 22 Dec 2016 19:05:07 GMT

You can always run a query against the postgres DB. That's how I determine who is active. Have not figured out how to tell which application they are connected to though.

select "Users"."Name", "LicenseUserAccessUsages"."ModifiedByUserName" as "Login", "LicenseUserAccessUsages"."UseStartTime" - Interval '5 hours' as "SessionStart", "LicenseUserAccessUsages"."LatestActivity" - Interval '5 hours' as "LastActivity", 'User Access' as "AccessType"

from "LicenseUserAccessUsages", "LicenseUserAccessTypes", "Users"

where "LicenseUserAccessUsages"."Deleted" = 'f'

and "LicenseUserAccessUsages"."LatestActivity" >= Now() + '3:30'

and "LicenseUserAccessTypes"."ID" = "LicenseUserAccessUsages"."UserAccessType_ID"

and "Users"."ID" = "LicenseUserAccessTypes"."User_ID"

union

Select "Users"."Name", "LicenseLoginAccessUsageSessions"."ModifiedByUserName" as "Login", "LicenseLoginAccessUsageSessions"."CreatedDate" - Interval '5 hours' as "SessionStart", "LicenseLoginAccessUsageSessions"."LatestActivity" - Interval '5 hours' as "LastActivity", 'Login Access' as "AccessType"

From "LicenseLoginAccessUsageSessions", "LicenseLoginAccessUsages", "Users"

where "LicenseLoginAccessUsageSessions"."Deleted" = 'f'

and "LicenseLoginAccessUsageSessions"."LatestActivity" >= Now() + '3:30'

and "LicenseLoginAccessUsages"."ID" = "LicenseLoginAccessUsageSessions"."LicenseLoginAccessUsage_ID"

and "Users"."ID" = "LicenseLoginAccessUsages"."User_ID"

Re: Verify how many users logged into the Qlik Sense HUB

jaisoni_trp — Thu, 22 Dec 2016 20:22:22 GMT

Thanks Kevin for sharing the sql.

Re: Verify how many users logged into the Qlik Sense HUB

Anonymous — Thu, 22 Dec 2016 21:19:05 GMT

Is that SQL giving accurate count Kevin ?

Re: Verify how many users logged into the Qlik Sense HUB

kevincase — Thu, 22 Dec 2016 21:37:44 GMT

It is close but sometimes not 100% accurate. I rely on the last activity time mostly to see if the user is still doing any work. One thing that I have noticed is that when a user connects via a user access pass, their session does not always get set as deleted right away when they close the browser. Plus, I have the session activity timeout set to 30 minutes. That's why I check the LatestActivity >= Now() + '3:30'.

Another thing, The query has been modified to take into account Daylight Saving Time here in the US. You may need to adjust the - Interval '5 hours' to read - Interval 4 hours. The timestamps were in GMT time so I subtracted hours to get the time to be the current Eastern Standard Time. If GMT time works for you, you can remove this entirely.

Re: Verify how many users logged into the Qlik Sense HUB

jim_chan — Sun, 26 Mar 2017 09:28:00 GMT

hi there,

what if i am in the 2 nodes environment, how and where can i check

- which user is accessing to which server - central node or rim node?

- user A is accessing App A from central Node or Rim Node?

Rgds

Jim

Re: Verify how many users logged into the Qlik Sense HUB

kevincase — Mon, 10 Jun 2019 15:13:58 GMT

Here is an updated query for all of those interested.

--Need to adjust time interval for daylight saving time -> Spring Interval = 4 Hours, Fall Interval = 5 Hours
select "Users"."Name", "LicenseUserAccessUsages"."ModifiedByUserName" as "Login", "LicenseUserAccessUsages"."UseStartTime" - Interval '4 hours' as "SessionStart", "LicenseUserAccessUsages"."LatestActivity" - Interval '4 hours' as "LastActivity", 'User Access' as "AccessType"
from "LicenseUserAccessUsages", "LicenseUserAccessTypes", "Users"
where "LicenseUserAccessUsages"."LatestActivity" >= Now() + '3:30'
and "LicenseUserAccessTypes"."ID" = "LicenseUserAccessUsages"."UserAccessType_ID"
and "Users"."ID" = "LicenseUserAccessTypes"."User_ID"
union
Select "Users"."Name", "LicenseLoginAccessUsageSessions"."ModifiedByUserName" as "Login", "LicenseLoginAccessUsageSessions"."CreatedDate" - Interval '5 hours' as "SessionStart", "LicenseLoginAccessUsageSessions"."LatestActivity" - Interval '5 hours' as "LastActivity", 'Login Access' as "AccessType"
From "LicenseLoginAccessUsageSessions", "LicenseLoginAccessUsages", "Users"
where "LicenseLoginAccessUsageSessions"."LatestActivity" >= Now() + '3:30'
and "LicenseLoginAccessUsages"."ID" = "LicenseLoginAccessUsageSessions"."LicenseLoginAccessUsage_ID"
and "Users"."ID" = "LicenseLoginAccessUsages"."User_ID"

Re: Verify how many users logged into the Qlik Sense HUB

Daniele_Purrone — Thu, 13 Jun 2019 08:51:55 GMT

Hi!
This could help: https://support.qlik.com/articles/000025281

Cheers!

Daniele