How to find out the list of users who have not used the Qlik Cloud in the last 6 months

[AnalyticExplorer7]

I am the tenant admin, and we are currently managing the following licenses in the Qlik Cloud:

• Analyzer licenses: 4200
• Professional licenses: 200

As our licenses are reaching their threshold limit, we would like to delete users who have not used Qlik Cloud in the last 3 months. Using the Entitlement Analyzer, we are identifying inactive users by checking the max(lastendtime) field to find their last usage.

In the image above, you can see that out of 4200 Analyzer licenses, 3481 are occupied, and out of 200 Professional licenses, 24 are occupied. However, in the Entitlement Analyzer, when I created a KPI with the field 'count(distinct email)', it is only fetching 2070 user emails, as shown in the image. On the other hand, the Access Evaluator is providing me with the correct count of users emails.

Image is taken from Entitlement Analyzer:

My question is: Why is there a difference in the user count between the Access Evaluator and the Entitlement Analyzer? Additionally, how can I accurately find the last usage for all users who have not accessed Qlik Cloud in the last 3 months?

Could anyone please help me?

Talend Administration Center   Qlik Cloud  

[David_Friend]

Open your management console, open the users section, click the ellipses in top right-corner and choose 'export users'

Then in the CSV you can do a filter by last login.

[rubenmarin]

Hi, I tried to do the same and found that userSubject was the only field with values on all cases, assigneeName has more values but still some are returned as null, and email has still more null values than assigneeName.

I don't fully remember but I think the lack of info was related to inactive users, users that didn't have a logging or didn't have openend an app yet.

[AnalyticExplorer7]

Hello @David_Friend ,

Thanks for the reply.

But I am unable to see the "Export Users" option. Please see the image below. Can you please guide me? Thank you.

[AnalyticExplorer7]

Hello @rubenmarin 

How are you deleting the users(last used) with the entitlement analyzer if not by how? Could you please let me know?

[rubenmarin]

Hello, sorry but I don't understand your question.

Btw, what I did was that for a customer who wanted to know users accesing the server lately, it was a specific question in a point of time.

I didn't deleted any user. I just made a table with userSubject, assigneeName, email, CurrentAssigneeType and "Date(Max(endTime))". It also needed a manual review to identifiy the userSubject without email or name.