Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
renovero
Contributor

List of Doc CAL's

Hello,

how could I list all of users who have access to document, and which one, from Document Cal assigned?
My Qlik is 12.10 SR7.

Clicking on documents one by one and write down who has access is really brutal.
And what if I want to know to which document my user has right to? I have to click all docks and search for that user?

1 Solution

Accepted Solutions

Re: List of Doc CAL's

Have a look at this app. This will show how many Full Cals & Doc Cals you have, and which apps and users the Cals are assigned to.

https://community.qlik.com/t5/QlikView-Documents/License-Analyser-K3FDS-qvw/ta-p/1493801

View solution in original post

8 Replies

Re: List of Doc CAL's

To search for a particular user, use the "Users" tab in the QMC, type the username and it will display all the licenses and documents the user has access to.


To see a list of all assigned document CALs, either use the QlikView QMS API for that (see here: https://help.qlik.com/en-US/qlikview-developer/November2018/APIs/QMS+API/html/7b30b3a1-77da-4bbe-bdc...) or check with Qlik Support to store your PGO files (where some info about licenses is stored) also in XML format (using PgoAsXML, not recommended unless troubleshooting).

Re: List of Doc CAL's

Have a look at this app. This will show how many Full Cals & Doc Cals you have, and which apps and users the Cals are assigned to.

https://community.qlik.com/t5/QlikView-Documents/License-Analyser-K3FDS-qvw/ta-p/1493801

View solution in original post

renovero
Contributor

Re: List of Doc CAL's

Hello @Miguel_Angel_Baeyens,
Thank You for Your response, I have never noticed that entered user name in search field, will return that user Documents access.
But about Your link, I don't even know what to do with it.

Hello @colin_albert
Thank You  for link to Your app, I find it very useful, I can't wait to test it, but as I saw, I have to restart Qlik process, so I will try it in the evening. As I understand, the only thing to configure is, to add one line in settings.ini-qlik-file, and to complete paths, to two places, inside Your app, on configure tab, yes? Nothing in script, am I right?

With regards.

Re: List of Doc CAL's

There is no change to the script.
Just remember to click away from the input boxes for the root folder and LEF file location so the change is saved.
The extra line in settings.ini saves the user data to PGO files.  This does require the service to be stopped so the ini file can be saved.

renovero
Contributor

Re: List of Doc CAL's

I may need Your help @colin_albert
I have stopped QV Server service through services.msc.
I have moved to C:\ProgramData\QlikTech\QlikViewServer and in Settings.ini I have added PgoAsXmlAlso=1 at the end of [Settings 7] paragraph, right before [Authentication] paragraph.
I have saved and close the document.
Next I have started QV Server service.
But when I have entered C:\ProgramData\QlikTech\Documents i don't see CalData.pgo.xml, but only CalData.pgo, and when I add direction to this file in Configuration tab there is an error right after "Reload".
Am I missing something?

Re: List of Doc CAL's

I usually add the PgoAsXml=1 line immediately after the [Settings 7] line.

You should see the pgo.xml files in the root folder alongside the pgo files once the service restarts.

Your root folder is set in the QMC    System / Setup / QlikView Servers / {Your Server Name} / Folders

 

https://community.qlik.com/t5/QlikView-Deployment/PGO-to-XML-conversion-to-get-the-list-of-users-in-...

renovero
Contributor

Re: List of Doc CAL's

Thank you @colin_albert , I will try to move PgoAsXml to the beginning of paragraph.
renovero
Contributor

Re: List of Doc CAL's

Now it works. I had to take a look on a script and manually insert paths to LEF and CalData.pgo, and now, everything is perfect.
TY all, guys.