currently active users list and open apps in Qlik Sense

[diwakarreddy]

Hi ,

Is there a way to track real-time traffic in Qlik sense environment , like the current users and current open apps ?

Kindly share any related documents / process for live monitoring.

Thank you.

Regards,

Diwakar.

[Jeff_R_Robbins_SC]

Ctrl-Q on GitHub from Ptarmigan Labs shows all active Virtual Proxy sessions.  While not exactly the equivalent of Qlik engine session with an open app, a Virtual Proxy session typically indicates the user has an open Qlik app (or is about to open one in the very near future).  So, Ctrl-Q can let you know if there are any active users on the system, before you make any potentially disruptive configuration changes. I've attached a ps1 PowerShell file and py python script to streamline the workflow slightly.

Cheers!

Jeff R. Robbins

[kevincase]

If you have access, you can use PGADMIN to connect to the repository Postgres database.  You can then run a query to get the active users realtime.  When I had access, I used to run this query.  (this was on a previous version of Qlik so I do not know if it would need to be adjusted as fields may have changed)  It is possible.

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

Kevin .....