Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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".
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".
Thank you very much Kaushik. You helped a lot 🙂
My pleasure.
Please mark the post as "Answered"
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;
How Can I check this for qlik sense saas?