topic Re: How to fetch licensed people info in qlikview ? in QlikView

How to fetch licensed people info in qlikview ?

nikhilgarg — Thu, 02 Jul 2015 08:47:48 GMT

Hello,

I want to sho the people name who have qlikview license. But how can i fetch the info about qlikview licensed people and show it in dashboard?

Thanks

Re: How to fetch licensed people info in qlikview ?

Gysbert_Wassenaar — Thu, 02 Jul 2015 08:54:53 GMT

See these documents:

Extracting PGO Data and Analysing License Allocation

License_Analyser_K3FDS.qvw

Re: How to fetch licensed people info in qlikview ?

alexandros17 — Thu, 02 Jul 2015 08:58:23 GMT

When you install qv server there is a wanderful document showing all information about licences, users and so on, the name should be QVSMonitoe or something like this

Re: How to fetch licensed people info in qlikview ?

Siva_Sankar — Thu, 02 Jul 2015 09:11:31 GMT

Nikhil,

The source for analyzing the license related information for most of the tool is pgo.xml, settings.ini, LEF text file.

You may pull these files and create dashboard on your own and do the analysis or you can use the already freely available tools that do the job for you example Extracting PGO Data and Analysing License Allocation

QlikView Application: System Monitor v5.1.23 License_Analyser_K3FDS.qvw or governance dashboard.

Now choice is yours.

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 07:54:21 GMT

Hey,

Thanks Gysbert but when i go thru the document: Extracting PGO Data and Analysing License Allocation

I found there is a folder mentioned as : Qlikview_Docs\AccessPoint . But i couldn't find that folder . Can you help me in this?

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 07:55:02 GMT

Hey,

Thanks Shankarece , but when i go thru the document: Extracting PGO Data and Analysing License Allocation

I found there is a folder mentioned as : Qlikview_Docs\AccessPoint . But i couldn't find that folder . Can you help me in this?

Re: How to fetch licensed people info in qlikview ?

Peter_Cammaert — Fri, 03 Jul 2015 08:01:36 GMT

That is because David actually refers to the "root document folder" (mentioned immediately before the path you're talking about) which is probably different on every QlikView server platform. The path "Qlikview_Docs\AccessPoint" is an example.

To find out what your path value looks like, open QMC and navigate to System->Setup->QlikView Servers->Select yours->Folders->Document Folders and look in the Root Folder field.

Peter

Re: How to fetch licensed people info in qlikview ?

Siva_Sankar — Fri, 03 Jul 2015 08:04:02 GMT

May be here C:\ProgramData\QlikTech\Documents\CalData.pgo.xml

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 08:24:42 GMT

Hey,

Thanks so regarding the following path mentioned in the qvw, to what path should i change, bcoz i dont have the Qlikview_docs folder ?

set vAccessPoint_Path = '\\172.21.10.19\c$\Qlikview_docs\AccessPoint' .

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 08:25:00 GMT

Hey,

Thanks so regarding the following path mentioned in the qvw, to what path should i change, bcoz i dont have the Qlikview_docs folder ?

set vAccessPoint_Path = '\\172.21.10.19\c$\Qlikview_docs\AccessPoint' .

Re: How to fetch licensed people info in qlikview ?

Siva_Sankar — Fri, 03 Jul 2015 08:31:34 GMT

Niklhil,

You have to use the path where CalData.pgo.xml is located.

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 08:56:57 GMT

ooopss, sorry my bad.

Thanks

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 03 Jul 2015 09:48:13 GMT

Hey,

While going thru the script under load.pgo,

Why #Licenses and #UserCals and #UserDocCals are taken as different fields when all these fields means the same ?

For Table: Cals :

1: 0 as %DocKey is taken? // It is acting as primary key then why 0 ?

2: 0 as UserDocCals ?

3: What info this Cals table giving ?

For Table DocCals:

1: What does %Key_PerDocumentCalData..... indicates ?

2: Why 0 as #UserCals ?

3: DocCals table is giving the info about Document Cals, ryt?

For Table PerDocumentCalData:

1: It is giving high level og info about each Documen cal, ryt?

For Table CalsInUse:

1: What info this table giving?

2: How does this table differ from Cals Table ?

For table NamedCalInUse:

1: What is #InUseUserCals and #InUseUserDocCals ?

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Tue, 07 Jul 2015 08:17:40 GMT

Hey,

In my server machine, i couldnot find any program data folder so couldn't find settings.ini file.

can you help me in this?

Thanks

Re: How to fetch licensed people info in qlikview ?

Peter_Cammaert — Tue, 07 Jul 2015 08:42:06 GMT

By default, ProgramData is a hidden folder (so that no one accidentally wipes out information in this directory) so thread carefully.

Open Windows Explorer, enable the Address Bar, and in ths bar type C:\ProgramData and press the Enter key.

Peter

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 17 Jul 2015 03:26:39 GMT

Hey,

I am trying to fetch Prod server info from QA server by setting the Prod Server IP but by default it is taking current server config only i.e QA server config only. Although i have commented all the QA server setting in my config file.

Wat can be the reason ??

Thanks

Re: How to fetch licensed people info in qlikview ?

nikhilgarg — Fri, 17 Jul 2015 03:27:07 GMT

Hey,

Wat can be the reason ??

Thanks