Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

cladup
New Contributor

Can I create an App with list of users and their custom properties ?

Hello, 

I am a QlikSense System admin in a decentralized organisation. 

We have a stream by departement/project. We use custom properties to grant access to a specific stream (and/or app)

When a departement want to add a new user, the 'owrner' contact me to grant access. 

The owners would like to have a view on the users that can access to their streams/apps.

It is not possible to export this information from the QMC.  (That could be a HUUUUUGE improvement for admins like me)

I would like to create an app where I can have a list of users with their stream and app acces but not as in the 'Licence monitor'.

I want to see the users even if they don't use their acces to QlikSense . Just the access right.

Is this information usable and where is it ?

Thanks for your help 

Labels (3)
3 Replies
gandalfgray
Valued Contributor II

Re: Can I create an App with list of users and their custom properties ?

Hi

Yes, you can do a lot of useful reports by reading from the Qlik Sense repository database QSR!

The info you look for is stored there.

cladup
New Contributor

Re: Can I create an App with list of users and their custom properties ?

Thanks Gandalfgray 

I  am working on an app using 'monitor_apps_REST_app' and 'monitor_apps_REST_user'.

It's what I needed

Highlighted
gandalfgray
Valued Contributor II

Re: Can I create an App with list of users and their custom properties ?

OK

I don't have much insight into using these rest connectors, I prefer databases.

So I am using ODBC to connect to the Sense postgresql database and gather the info from there.

Everything that is setup and visible in QMC is stored there.

 

It's great to have apps where you can search for stuff like:

Which users have what admin roles? (Not possible in QMC)

Which tasks have 1440 minutes session timeout? (Not possible in QMC)

etc