
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show users last login date
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!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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".

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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".

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much Kaushik. You helped a lot 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My pleasure.
Please mark the post as "Answered"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
— Nintendo Quit screen message

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How Can I check this for qlik sense saas?
