Show users last login date

[elifsena]

Hi community,

I'm an intern so this whole qliksense is new for me 🙂

I'm currently using qmc screen for giving report allocations and licenses. But i have limited qliksense license, so if an user didn't login in last 3 months i'll delete their license and give it to another user that uses qliksense more effectively. In this case, i want to see users last login date that have analyzer allocations license. How can i do that? 

Thank you for your help!

[kaushiknsolanki · Accepted solution]

Hi,

You should go to Qlik Sense  -> QMC -> License Usage Summary -> and click on the Analyzer Access Allocation and there you should use one field against each user license named "Last Used".

[elifsena]

Thank you very much Kaushik. You helped a lot 🙂 

[kaushiknsolanki]

My pleasure.

Please mark the post as "Answered" 

[SonOfJeffGoldblum]

if you have any monitor rest license user tables setup as data connections

LIB CONNECT TO 'monitor_apps_REST_license_user';

RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u0",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"lastUsed",
"quarantined",
"quarantineEnd",
"deletedUserId",
"deletedUserDirectory",
"privileges" AS "privileges_u0",
"schemaPath",
"__KEY_root"
FROM JSON (wrap on) "root" PK "__KEY_root";

[root]:
LOAD [id_u0] AS [id_u0],
[createdDate],
[modifiedDate],
[modifiedByUserName],
[lastUsed],
[quarantined],
[quarantineEnd],
[deletedUserId],
[deletedUserDirectory],
[privileges_u0] AS [privileges_u0],
[schemaPath],
[__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);

DROP TABLE RestConnectorMasterTable;

[Susovan1]

How Can I check this for qlik sense saas?