How to obtain the list of Assigned CALs?

[kevinpintokpa]

Is there a way to obtain, via program or script, a list of the currently Assigned CALs?  Especially the Name and the Last Used (UTC)?  This would be helpful for periodic housecleaning, where we can release the CALs of persons who are not actively using the system or who have left the company.  See the attached pic.

I'm using QlikView 12.20 SR4 and in the process of moving to 12.40

[Chip_Matejowsky · Accepted solution]

Hello @kevinpintokpa,

You can use the PGO as XML functionality of QlikView Server to dump the contents of the CalData.pgo file to XML.  See the Qlik Support article "Reading PGO contents and CAL assignments / PGO to XML " for details.  Please note the warning in the article which states Running this feature may degrade performance of the server, feature should be activated, xml files created, then deactivate feature, so be sure to turn off after capturing the information.

Also, I suggest that you review the Qlik License Agreement regarding the assignment/re-assignment of Named User CALs, so that compliance to the license agreement is maintained.  Any CAL used by an identified user may not be transferred to another user, unless the transfer is due to a change in the employment status or work duties of the prior user, in which case there is a 7 day quarantine (or 24 hour quarantine depending upon the version of QlikView)  before the CAL be transferred to another user.

[atoz1158]

Hi

We copy and paste the names and date last used from the tab you are showing into text and after a little bit of cleaning up it gives us a usable list.

I would suggest that you change the number of entries per page to 100 as this make it a little quicker.

Regards

Adrian

[Brett_Bleess · Accepted solution]

The last option would be the SDK/APIs for the QMS:

https://help.qlik.com/en-US/qlikview-developer/April2019/APIs/QMS+API/html/7b30b3a1-77da-4bbe-bdc2-1...

Regards,
Brett