topic Re: Reading CAL Allocation Details in QlikView

Reading CAL Allocation Details

Mon, 26 Jan 2026 18:19:17 GMT

Hello QlikView Experts,

I need your advice whether we can find CAL Allocation activity details?

I need to trace these activities & present it in dashboard.

I need something like this

User	CAL Type	Assigned On	Assigned By	IsActive (Not Deleted)
User 1	Named CAL	10/01/2015	QVAdmin	Yes
User 2	Named CAL	28/02/2015	QVAdmin	No
User 3	Document CAL	30/03/2015	QVAdmin	Yes
User 4	Document CAL	20/04/2015	QVAdmin	Yes

I have some idea about Events.log files but fetching data from it in this format is not straightforward.

Thanks & Regards,

Kiran Shinde

Re: Reading CAL Allocation Details

Peter_Cammaert — Fri, 28 Aug 2015 07:42:39 GMT

Have a look at David Foster's License_Analyser_K3FDS.qvw‌. This document uses CalData.pgo to get a list of assigned CALs and the dates they were last used. You will have to put QVS in a special mode so that it maintains a copy of CalData.pgo in XML format which can be read by QlikView.

Reading all Events logs may still be necessary if you do need the original CAL assignment dates.

Best,

Peter

Re: Reading CAL Allocation Details

Fri, 28 Aug 2015 08:46:14 GMT

Hello Peter,

Thanks for your suggestion.

Document you suggested have latest info about all assigned CALs,

but I didn't find any information about who assigned CAL & at what time / date.

Can it be possible to read this info easily?

Thanks & Regards,

Kiran Shinde

Re: Reading CAL Allocation Details

Peter_Cammaert — Fri, 28 Aug 2015 08:53:28 GMT

A I said, you'll need to process all Events log files if you want to get hold of the original CAL assignment date. AFAIK that's the only way...

Peter

Re: Reading CAL Allocation Details

Fri, 28 Aug 2015 09:02:38 GMT

Hello Peter,

Sure, I will try with processing Event Log Files.

Thanks once again for valuable suggestions.

Thanks & Regards

Kiran Shinde

Re: Reading CAL Allocation Details

Peter_Cammaert — Fri, 28 Aug 2015 09:07:32 GMT

Apparently, in all QVS versions since SR7, audit information has been added to the Events log file about which administrator did the actual CAL assignment. So one place to find all missing data.

Good luck,

Peter

Re: Reading CAL Allocation Details

Bill_Britt — Fri, 28 Aug 2015 12:31:20 GMT

Hi,

The setting Peter is referencing to is put in the QVS settings.ini file. Located by default at C:\ProgramData\QlikTech\QlikViewServer

Under the heading

[Settings 7]

PgoAsXmlAlso=1

This will cause QVS to write the PGO files as XLM files also.

Bill