Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Reese
Employee
Employee

Reading pgo files

Reading QlikView Server pgo Files and CAL Allocation Reporting

Background

Reporting on both active CALs and CALs not in use/never used helps clients understand their session activity as a percentage of licenses available.  In addition, it assists NAMs in gauging capacity and future licensing needs (when that information is made available).

  • The QVSCalManager is able to report on both allocation and usage. However, it does not contain any the operational detail found in the Governance Dashboard.  -https://community.qlik.com/docs/DOC-5281


Retrofitting one of the apps above to combine it with the other would present a series of complexities and challenges.   QVSCALManager is also not supported by Qlik as it was created by partner, Excelio.

This document details the process of using pgo files to read total license availability, which can then be easily incorporated in the Governance Dashboard.  (GD currently does not yet include any session or usage CAL information.)


Steps

There is a setting that can be added to Settings.ini, which will force a copy of the pgo files to be created in xml.  This allows pgo license data to be read in real-time and it works on QlikView 10 and 11.

  1. Stop QlikView Services
  2. Edit the QlikView Server’s Settings.ini file.
    Locate Settings.ini C:\ProgramData\QlikTech\QlikViewServer and add the following entry under the [Settings 7] node:  PgoAsXmlAlso=1
  3. Start Services. Load pgo.xml into QlikView.


PGO Details

Tables below describe relevant files and attributes.

File

Description

  1. Settings.ini

Stores the QlikView Server (QVS) settings. Manual changes in this file require restart of QVS. This file is always stored in the “Data” folder (see Overview (page 53)).

The configuration information is stored in Persistent Global Objects (.pgo) files.  The different .pgo files contain information on borrowed CALs, CALs in use, server settings, and ticket data.

File                            

Description

  1. BorrowedCalData.pgo

Keeps track of borrowed Client Access Licenses (CALs).

  1. CalData.pgo

Keeps track of CALs.

  1. IniData.pgo

Coordinated version of Settings.ini.

  1. ServerCounters.pgo

Keeps track of statistics.

  1. TicketData.pgo*

Keeps track of tickets.

Within CALData.pgo.xml, the following fields will provide license allotment and instance name:

    1. ServerName
    2. LefCalInfo/NoOfNamedCals
    3. NoOfDocumentCals
    4. NoOfSessionCals
    5. NoOfUsageCals


IniData.pgo.xml stores Settings.ini entries as attributes of the fields below:

    1. Name
    2. Value


ServerCounters.pgo.xml provides rolling 2 day aggregate metrics on document loads and failures:

    1. CounterDate
    2. CounterDocLoadFailsSinceMidnight
    3. CounterDocLoadFailsYesterday
    4. CounterDocLoadsSinceMidnight
    5. CounterDocLoadsYesterday
    6. CounterSessionStartsSinceMidnight
    7. CounterSessionStartsYesterday


*No definition available

Linking CALData.pgo.xml to Governance Dashboard

In Governance Dashboard 1.1.1, the SessionTaskAuditMaster table contains session and audit details.

The Node_Name field in this table can be linked to ServerName in CALData.pgo.xml.

Summary

All license allocation can be reported in Governance Dashboard by adding an entry in Settings.ini and reading CALData.pgo.xml

Other Relevant Resources

  1. Settings.ini https://community.qlik.com/message/196178#196178
  2. PgoAsXmlAlso - I added the following function to the pgo xml load script example to convert time fields.

Performance Disclaimer

  1. Various factors specific to each environment impact how PGOAsXMLAlso affects performance.  These factors should be taken into consideration before using in a production environment.
  2. It also does not work in clustered environments.
  3. **Other options for CAL reporting include development with the QVS Management API.  TicketData.pgo.xml can also provide real time ticketing information, but it was not designed for production enterprise implementations.
2 Replies
Daniel_Seo
Support
Support

Hi

I have CalData.pgo.xml as follows.

but I can't understand the status.

What does it mean by "<ToBeDeleted>" in CallData.pgo.xml ?

Does it mean that Allocated Cal is deleted ?

<CalAllocEntry>
<Name>OCBCNISP\BAYU.PRIMAPUTRA</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E53FCD5419CA25</LastUsed>
</CalAllocEntry>
<CalAllocEntry>
<Name>OCBCNISP\BAYU.SATRIO</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E53F444FD585E1</LastUsed>
</CalAllocEntry>
<CalAllocEntry>

 

Thanks.

Brett_Bleess
Former Employee
Former Employee

What that should be indicating is the Named CAL assignment is in 'Quarantine' status, so until the quarantine period is reached, it will not be deleted, it is to be deleted as soon as the quarantine period is reached.  

I would like to provide the following link to the License Metrics document that explains when you can remove users from Named CALs as well, as there are only two instances that this should occur, the employee is terminated, or they change positions and no longer need access to the product.  Deleting users from Named CALs just because they have not used it in a period of time is technically violating this agreement, and I wanted to point that out, here is the link to the document:

https://www.qlik.com/us/-/media/files/legal/license-agreements/qlikview/qlikview-license-metrics-en....

That will download the PDF, the section you want to read is Section 3. Identified Users, second paragraph there explains things pretty clearly hopefully.  Hope this helps.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.