topic Re: How to export list lease license in QlikView

How to export list lease license

Thu, 23 Oct 2014 04:41:24 GMT

Hi guys,

My boss asked me to export all of our lease license in the server..

i look out in Qlikview Management Console.. (screenshot attached)

but it's not complete.. there is no scrolling bar or something..

so.. how can i get list all of my lease license in server.. maybe i can export it to excel, so i can show it to my boss..?

Thanks in advance.

Re: How to export list lease license

ecolomer — Thu, 23 Oct 2014 04:56:09 GMT

Try to send to printer

Re: How to export list lease license

tresB — Thu, 23 Oct 2014 05:28:44 GMT

I could just copy and paste it. Else, have a look at Governance Dashboard if that helps.

Re: How to export list lease license

dinuwanbr — Thu, 23 Oct 2014 06:39:09 GMT

Hi,

Use a System Monitor Application and reload it.

In there you can see Users (CALs). Then export the list into an excel.

Link:

QlikView Application: System Monitor v5.1.23

BR,

Dinu'1

Re: How to export list lease license

Thu, 23 Oct 2014 08:22:57 GMT

No.. there isn't any printer button in Qlikview management console.

Already checked in Qlikview Management Console - Tab System - Licenses - Qlikview Server - Tab Client Access Licenses (CALS) - Tab History..

Re: How to export list lease license

Thu, 23 Oct 2014 08:24:19 GMT

i already download it..

where i can find my leased license ?

Re: How to export list lease license

Thu, 23 Oct 2014 08:26:25 GMT

i already reload system monitor..

i select field Authenticated User... but i think it is only CAL.. i want to find Leased License.

Thanks before.

Re: How to export list lease license

Colin-Albert — Thu, 23 Oct 2014 08:35:04 GMT

Have a look at the Licence Analyser app written by my colleague David Foster

This give users access to see the allocation of User Cals and Document Cals

http://community.qlik.com/docs/DOC-4774

Re: How to export list lease license

Thu, 23 Oct 2014 08:50:31 GMT

Thanks Colin Albert, i already download that file. but errors showed up..

i already change the path.. but it doesn't work either..

can you help me contact David Foster.. if it's possible...

I really appreciate your help.

Re: How to export list lease license

Peter_Cammaert — Thu, 23 Oct 2014 10:48:30 GMT

Use the document in attachment. It will read an XML export of the related PGO file from the Document Root.

Two important things to take care of before your reload the document:

Make sure that your QlikView Server exports PGO files as XML also. Close to every License Monitoring app requires this. See David Fosters License analyser for instructions. You posted in the accompanying thread already, so you know where to look.
By default, QVS places PGO files and XML exports in the Document Root. If you modified the document root, enter the new path in the input box before reloading.

Good luck,

Peter

Re: How to export list lease license

Colin-Albert — Thu, 23 Oct 2014 11:02:43 GMT

You need to set the Configuration sheet to the correct path for your Access Point Root folder in XML Path, and the correct Server LEF File Location usually \\Your-Server-Name\c$\ProgramData\QlikTech

If you change these values, remember to click anywhere on the sheet so the values are saved before you click reload.

Also check the root folder contains the PGO files after you have edited the settings.ini file and restarted the QVS service.

If these settings are correct and the PGO files are present, then reload the app.

Re: How to export list lease license

Fri, 24 Oct 2014 04:51:55 GMT

Peter Cammaert & Colin Albert

Thanks for your helpful answer...

but i have a little problem to generate pgo as xml.. i already add in settings.ini.. and then restart qlikview server service (in services.msc)

which step that i do wrong ?

i have to restart service or qlikview server machine ?

or i have to restart all of qlikview services ?

Thanks before guys.

-------------------- edited ------------------------------

it seems, i have to restart qlikview server machine.

http://community.qlik.com/docs/DOC-4774#comment-9909

sorry i didn't read this comment before, i have to wait because we can't restart qlikview machine anytime.

Regards,

Aditya Christian Surjantoro. ~ www.facebook.com/aditya.christian ~

Re: How to export list lease license

Colin-Albert — Fri, 24 Oct 2014 07:56:46 GMT

You do not need to restart the server, just the QVS service.

The service must be stopped to allow changes to the settings .ini file.

When you restart the service after adding the PgoAsXmlAlso=1 setting you should see some pgo files in the Access Point root folder.