topic Re: How to get List of Users which have license in QlikView

How to get List of Users which have license

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

in MY QMC i see list of users page by page,,,

is there any backend file or palce where i could get list of all users. it is not convinient to copy page by page..

Thanks

Re: How to get List of Users which have license

Carlos_Reyes — Thu, 26 Sep 2013 17:28:24 GMT

If you want to monitor users you may use the app that David Foster uploaded. I haven't tried it but it may be good:

License_Analyser_K3FDS.qvw

Re: How to get List of Users which have license

Thu, 26 Sep 2013 18:53:10 GMT

Hi I cant fine Qlikview_Docs\AccessPoint path..

I have changed settings.ini file but i cant find CalData.pgo.xml

Re: Re: How to get List of Users which have license

Carlos_Reyes — Thu, 26 Sep 2013 19:29:30 GMT

Well.. I hand't tried it, but now I have and although it is supposed that you must change the paths in the "Configuration" tab, I did that and tried to reload and got the same error as you. So I suppose you may ignore those variables in the Configuration tab and instead change the paths at the end of the "Main" tab in the script.

For instance... I changed those as following:

// Path for LEF file on QV Server

set vLEF_Path = 'C:\ProgramData\QlikTech' ;

// Path where txt data generated by QV Powertools batch file are saved

set vAccessPoint_Path = 'C:\Users\MyUser\Documents\QVS\Configuration' ;

After doing that I reloaded and it worked.

The first path is usually the same, or very similar, since it's very rare that somebody changes that. But the second is more likely to change so you must check in your QMC: System\ Setup \ QlikView Severs \ Folders \ Root Folder which folder is selected as root folder.

Hope it helps.

Re: Re: How to get List of Users which have license

Thu, 26 Sep 2013 20:20:50 GMT

Hi , I ahve done following steps.

Stopped servers and updated settings.ini file and added PgoAsXmlAlso=1.

restarted servers and in QMC Root Folder is pointing E:\QlikView_Docs\QVSettings to this. After restart it did not create required file,, so got this error

Cannot open file '\\qlikview-pw00.esc.win.colpal.com\e$\QlikView_Docs\QVSettings\CalData.pgo.xml' The system cannot find the file specified.

The QVSettings folder has thgese files only aqs shown below

Re: Re: Re: How to get List of Users which have license

Carlos_Reyes — Thu, 26 Sep 2013 20:50:11 GMT

First, you only have to stop QlikViewServer service, it is no required to stop all.

Second, where did you put the PgoAsXmlAlso=1 line? You have to put it in the Settings section, not in the Authentication part. See below:

[Settings 7]

DocumentDirectory=C:\Users\Carlos Reyes\Documents\Evolcon\QVS\Configuración

CanDynamicUpdate=1

NumberOfDocuments=-1

UserCalList=C:\ProgramData\QlikTech\QlikViewServer\FUL.dat

DocumentList=C:\ProgramData\QlikTech\QlikViewServer\FDL.dat

ServerLogFolder=C:\ProgramData\QlikTech\QlikViewServer

HF820UpdateCalNamedCals=0

PInfoX=EVPOQCZKPCTGUHZJNZQEFONIBSUYUHNKSKRSVCNKJD

PInfoY=YGcPSCZKPCTGUHZJNZQEFONIBSUYUHNKSKRSVCNKMZQCEJRJPaUEVCFLFaUYSCZKPCTGUHZJNZQEFOZJJSTOUKZJPCLcUEZJHKVcUHRFcCVeECdJTCLKELdJMaQeEHVFDSUYVIRJJaSMVEVIXCICECVJJSTSUJRKSKQIVHJKTCLEUKFJMCVSEHRLBCRaUEZJJaUIFJFIEaTEVCNKMJRMVHRJDaTcUWMISCXCECVJJSTSUJRKSKQIUHJKFaUYCBVKJCTIVEZJcKVGVKFISKSeUJRFFSVeEGNIPSTaSBJKcKVGVKFISKSeUJRFOCVASAVKUCSeEJFJUKWYVJVISSVSUBFJPCLYVEZJJaQSUHBEEKRASJVITKSGcJaJAJRcEQQJBCIGUHZJTaTYUARFOCVASAVKUCSeEJFJUKWYVKNKVKQEVEdJTCICUKRKFSTIVEZIJaQCECdJTCLcEKBEBKVIFEdJSKSIVMRLFaUIVABEDaTaEIFIDOEHcGGIMBXYUHNIBCTYCHRKAJQKFKBJPSUSEKFLcKQKFKVIOCVSUBFIDKSGcJaJARTIFGVJMJRIVEFKVKRIVABEPSQYUEdIBCVeEJFJBCXcUEZKFCTASHJIMKSOUARKPSUSUHBEBCTIVHRFBG

PInfoZ=RCbbXJVFRJLKTWIGRJLCTbAHTJOSTaQGSBOaCbAGRJOGDcUGSBNaScAGYZNCTccGQJNaSYAGQRMYSJVFRJLKTWIGRJLCTbAHTJOSTaQGSBOaCbAGRJOGDcUGSBNaScAGYZNCTccGQJNaSaEGTBLGVWEGNJMaCYQFTKLCTWUGNRMCTWEGXBOGTcEHVBNEDcUFWBMCTcMGYJNEDaUFZBMQTbEGZZNATaUFRBMATZQFTKLCTWUGNZMETWUGUBNYSJVFRJLKTWMGSJLKDaUGMZUaSYUFVJLMDWMKNJMaCZUFRBLGVWEGNJNaSYEGMZUaSYUFVJLCTaQFTKLCTWIGNBMYSJVFRJLKTWYGUJLCDYQFTKLCTWEGWJLCDZIGYBOYCJA

NumberOfUserCals=25

NumberOfSessionCals=-1

NumberOfUsageCals=-1

NumberOfInfrequentNamedCals=0

NumberOfConcurrentInfrequentNamedCals=0

SessionCalsInUse=0

NumberOfDocumentCals=5

UsageCalAvailable= -1

MarginTop=20

PgoAsXmlAlso=1

DocumentMounts="Productivo","C:\Users\Carlos Reyes\Documents\Evolcon\QVS\Aplicaciones de Usuario",1;

Other_String=Otros

[Authentication]

Serial=1006 5608 4315 9802

Organization=EVOLCON

Name=EVOLCON

Check=0283721204

LastLefUpdateAttemptDate=2013-04-18 E587B7F1-3183CFF8-27D6B0AD-0A1B561C-3D568A95

Third, you have to save the Settings.ini and start the QlikViewServer service, then you should see the new CalData.pgo file.

Fourth, reload the app.

Regards,

Re: How to get List of Users which have license

stevedark — Thu, 26 Sep 2013 20:59:25 GMT

Hi Faisal,

I retrieve this information on a couple of sites by using QlikView Power Tools (see: http://community.qlik.com/docs/DOC-3059)

Install this and then configure the QV User Manager to talk to your server. You can then use a command line and pipe the output to a file. I then pull this file in as an addition to the QlikView Ops Monitor - so as well as seeing which users have licences you can see how much they have been using them. If you wish this file to be updated regularly you can call the command line from Windows Scheduler.

Please post back if you require further information on this solution.

Hope that helps.

Steve

http://www.quickintelligence.co.uk/

Re: How to get List of Users which have license

Thu, 26 Sep 2013 22:03:45 GMT

Excellent ,, it worked,, and i can download list of all users,,,,, i wish i could give you 100 points

Re: How to get List of Users which have license

Carlos_Reyes — Thu, 26 Sep 2013 22:07:14 GMT

I wish that too hahaha, but you can give me 10 if you mark my answer as correct.

Re: How to get List of Users which have license

Thu, 26 Sep 2013 22:15:37 GMT

Done,,, Thank You for Your help.......