Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Gandalfgray
I am working on an app using 'monitor_apps_REST_app' and 'monitor_apps_REST_user'.
It's what I needed
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
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
Its very nice idea. I too thought of creating insight for this. have you completed this ?
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:
Hope this is what you meant.
Eli.
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,
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