Qlik Community

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

List and kill Qlik Sense Enterprise Sessions

cancel
Showing results for 
Search instead for 
Did you mean: 
Clever_Anjos
Employee
Employee

List and kill Qlik Sense Enterprise Sessions

This powershell script is capable of listing all active sessions of all virtual proxies. Then you can choose a session to terminate (if you want)

I've shared it into Github using MIT license, so you can use freely with no charges.

https://github.com/cleveranjos/qlik-cli-utils/blob/master/list-sessions.ps1

 Capturar.PNG

 

Thank you Luciano Assad for the idea

Comments
Pheaxx
Contributor III
Contributor III

Hi,

When I run the script I have a list off ~144 sessions but it does not show the userId that i would expect of a user.

So how does one see which sessions belongs to which user?

Thank you,

Regards,

Nick

0 Likes
Clever_Anjos
Employee
Employee

Hi, can you attach a screenshot?

0 Likes
Pheaxx
Contributor III
Contributor III

i have sent to via pm a screenshot.

Each userid is the same as the service account that u run the script on.

 

0 Likes
Clever_Anjos
Employee
Employee

Some sessions are attributed to service account because of monitoring apps, they connect to the API's so they are valid sessions

0 Likes
Pheaxx
Contributor III
Contributor III

a right, so i need to run the script on the engines which houses the users?

0 Likes
Clever_Anjos
Employee
Employee

No as long as I know, because the script list the sessions based on which virtual proxy the user is connected

All your sessions are being attributed to service_account?

 

If possible change this

$sessions | Format-Table

to

$sessions | Export-Csv -Path output.csv and send it to me

0 Likes
Pheaxx
Contributor III
Contributor III

Correct. there is only one different but that's the service account from Nprinting pointing to centralnode.

i have created the file. but there is no option to add files in here or in a pm.

 

0 Likes
jheasley
Luminary Alumni
Luminary Alumni

any way to add a line that will exclude a specific account or accounts? for example, one of my service accountids is "qlikserviceprod", and im not interested in those sessions. 

gandalfgray
Specialist II
Specialist II

Hi!

Our main VP has no prefix and 

Get-QlikSession -virtualProxyPrefix $vp.prefix

seems to return nothing when $vp.prefix is empty

 

How can one get the sessions for a VP without prefix using Qlik-CLI?

 

rzenere_methode
Partner
Partner

Nice script, thanks for sharing!

0 Likes
Version history
Last update:
‎2018-12-26 04:19 PM
Updated by: