Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cladup
Contributor II
Contributor II

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)
8 Replies
gandalfgray
Specialist II
Specialist II

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
Contributor II
Contributor II
Author

Thanks Gandalfgray 

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

It's what I needed

gandalfgray
Specialist II
Specialist II

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

 

s_bonora
Contributor
Contributor

Hi @cladup , did you succeed in creating app showing list of users and their custom properties?

What did you do? I am in the same situation now, and it willbe useful to get this insight

 

kumarbala
Partner - Creator
Partner - Creator

Its very nice idea. I too thought of creating insight for this. have you completed this ? 

EliGohar
Partner - Creator III
Partner - Creator III

Hi @cladup ,

I wrote a script that displays one custom property (Called Language) and user values.

Make sure first to create a data connection for Qlik DB (QRS).

Here's my script, just change the word Language to the name of your custom property.

 

Language:
LOAD ID as "Definition_ID", 
	Name as CusomeName
    Where "Name"='language';
SELECT "ID", 
	"Name", 
	"ValueType", 
	"ChoiceValuesString", 
	"ObjectTypesString", 
	"CreatedDate", 
	"ModifiedDate", 
	"ModifiedByUserName" 
FROM "public"."CustomPropertyDefinitions";

Inner Join

LOAD 
	Value,  
	Definition_ID, 
	User_ID
;
SELECT "ID", 
	"Value", 
	"CreatedDate", 
	"ModifiedDate", 
	"ModifiedByUserName", 
	"App_ID", 
	"ContentLibrary_ID", 
	"DataConnection_ID", 
	"EngineService_ID", 
	"ServerNodeConfiguration_ID", 
	"ProxyService_ID", 
	"RepositoryService_ID", 
	"SchedulerService_ID", 
	"Extension_ID", 
	"ReloadTask_ID", 
	"ExternalProgramTask_ID", 
	"Stream_ID", 
	"Definition_ID", 
	"User_ID",
	"VirtualProxyConfig_ID", 
	"UserSyncTask_ID", 
	"PrintingService_ID", 
	"AppContentQuota_ID", 
	"WebExtensionLibrary_ID", 
	"Widget_ID", 
	"SharedContent_ID", 
	"AnalyticConnection_ID" 
FROM "public"."CustomPropertyValues";

Left Join

LOAD ID  as User_ID, 
	UserId, 
	UserDirectory;
SELECT "ID", 
	"UserId", 
	"UserDirectory", 
	"Name", 
	"RolesString", 
	"Inactive", 
	"CreatedDate", 
	"ModifiedDate", 
	"ModifiedByUserName", 
	"RemovedExternally", 
	"Blacklisted", 
	"DeleteProhibited" 
FROM "public"."Users";

//Loading data to Users table
Users:
LOAD //ID  as User_ID, 
	UserId, 
	UserDirectory,
    'UserDirectory='&UserDirectory&'; UserId='&UserId as UserFilter;
SELECT "ID", 
	"UserId", 
	"UserDirectory", 
	"Name", 
	"RolesString", 
	"Inactive", 
	"CreatedDate", 
	"ModifiedDate", 
	"ModifiedByUserName", 
	"RemovedExternally", 
	"Blacklisted", 
	"DeleteProhibited" 
FROM "public"."Users";

left join

load UserDirectory,UserId,
     Value as Language,
     'UserDirectory='&UserDirectory&'; UserId='&UserId as UserFilter
resident Language;

drop table Language;

 

 

Result:

image.png


Hope this is what you meant.

Eli.

cladup
Contributor II
Contributor II
Author

Yes I did manage to load all the data and model it as expected using 'monitor_apps_REST_app' and 'monitor_apps_REST_user'.

Regards, 

jpjust
Specialist
Specialist

Hi Cladup - Would you mind sharing the code / Joins between those 2 rest connectors to get the information that you were looking for? I am looking forward for the same information which is not available in the License monitor.

Thanks