How to get List of Users which have license

[#1]

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

[Carlos_Reyes]

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

[#3]

Hi I cant fine Qlikview_Docs\AccessPoint path..

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

[Carlos_Reyes]

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.

[#5]

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

[Carlos_Reyes · Accepted solution]

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,

[stevedark]

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/

[#8]

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

[Carlos_Reyes]

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

[#10]

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