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

How to get List of Users which have license


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

1 Solution

Accepted Solutions
carlos_reyes_qv
Valued Contributor

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

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,

9 Replies
carlos_reyes_qv
Valued Contributor

Re: How to get List of Users which have license

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

Not applicable

Re: How to get List of Users which have license

Hi I cant fine Qlikview_Docs\AccessPoint path..

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

carlos_reyes_qv
Valued Contributor

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

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.

Not applicable

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

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

QVSettings.png

carlos_reyes_qv
Valued Contributor

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

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,

MVP
MVP

Re: How to get List of Users which have license

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/

Not applicable

Re: How to get List of Users which have license


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

carlos_reyes_qv
Valued Contributor

Re: How to get List of Users which have license

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

Not applicable

Re: How to get List of Users which have license

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

Community Browser