List of Doc CAL's

[renovero]

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?

[Miguel_Angel_Baeyens]

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).

[Colin-Albert · Accepted solution]

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

[renovero]

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.

[Colin-Albert]

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]

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?

[Colin-Albert]

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]

Thank you @Colin-Albert , I will try to move PgoAsXml to the beginning of paragraph.

[renovero]

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.