How to export list of users from QMC

[ziadm]

Hi

Is there a way to export the list of User and Login Access from the QMC.  I have tried the Monitor App also there is non can do this

Appreciate it

Thanks

[NareshGuntur]

When you say list of users from QMC....

is it for a particular task?

or all the users who have distribution to any of the document(from any task)?

Check if this is useful. I can see the list of users in a qvw.

Analyze your QVPR and Server Task Structure

[Levi_Turner]

Honestly your best source is going to be the underlying Repository Database. This, of course, is not ideal from the standpoint of supportability but so long as you are just reading the data then there is a very minor risk of complications.

Additionally the logs will contain the relevant information. Minimally you'd just need the Repository > System > License to show the license usage.

Edit: Do keep in mind that all of these methods will show who has used or has been assigned one. There's further complications when trying to compute who could access a token which would depend on the rules setup and would be quite complicated.

[reddy-s]

Hi Zaid,

Its better doing it from the underlying database or source. I don't think there is an option as such in QMC.

Or If you have the Monitoring apps, you can export the list of users who have logged in and other stuff from there.

Thanks,

Sangram.

[Michael_Tarallo · Accepted solution]

HI Ziad,

Yes there is via the Repository API - before you continued, are you comfortable with API calls, methods, headers etc?

AND - IT IS NOT RECOMMENDED TO USE THE UNDERLYING DATABASE DIRECTLY.

If so you can check out the online developer documentation and these other resources:

• Qlik Sense Repository Service API ‒ Qlik Sense
• General path structure and use ‒ Qlik Sense
• Using Xrfkey headers ‒ Qlik Sense
• Connecting with Postman ‒ Qlik Sense
• Create Stream API - Qlik Sense
• Qlik Branch Repository API Windows App

After I have a working example here - I will also share it.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[Michael_Tarallo]

Here is an update, check this screen shot out that shows the postman addon for chrome.

• url: https://<machine>/qrs/user/full?Xrfkey=123456789ABCDEFG
• method should be GET
• key: X-Qlik-Xrfkey value: 123456789ABCDEFG
• key: X-Qlik-User value: UserDirectory=internal;UserId=sa_repository
• Authorization NO Auth

When you click Send and you are prompted to accept the Qlik Client cert just say yes or accept.

Let me know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[samuli_attido]

You could use the QVPR Analysis tool to get a list of users with access to applications based on distribution lists, however, if you're using other than named users e.g. groups this may not give you an exhaustive solution. See more:
https://community.qlik.com/t5/QlikView-Documents/Analyze-your-QVPR-and-Server-Task-Structure/ta-p/14...