Reading CAL Allocation Details

[#1]

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

[Peter_Cammaert]

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

[#3]

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

[Peter_Cammaert]

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

[#5]

Hello Peter,

Sure, I will try with processing Event Log Files.

Thanks once again for valuable suggestions.

Thanks & Regards

Kiran Shinde

[Peter_Cammaert]

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

[Bill_Britt]

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