Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reading CAL Allocation Details

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

UserCAL TypeAssigned OnAssigned ByIsActive (Not Deleted)
User 1Named CAL10/01/2015QVAdminYes
User 2Named CAL28/02/2015QVAdminNo
User 3Document CAL30/03/2015QVAdminYes
User 4Document CAL20/04/2015QVAdminYes

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

Thanks & Regards,

Kiran Shinde

6 Replies

Re: Reading CAL Allocation Details

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

Not applicable

Re: Reading CAL Allocation Details

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

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

Not applicable

Re: Reading CAL Allocation Details

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

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

Employee
Employee

Re: Reading CAL Allocation Details

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

Community Browser