topic Where to read license usage from? in QlikView

Where to read license usage from?

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I want to create an application for license usage analysis, but I don't know where to read that info from, and I've given up on making the QMS API work. Any help will be appreciated, thanks.

Where to read license usage from?

Mon, 27 Jun 2011 19:43:11 GMT

I suspect this may be what you are looking for?

http://community.qlik.com/qlikviews/1029

Where to read license usage from?

Mon, 27 Jun 2011 23:08:18 GMT

that's a good app, but it only reports based on usage, not on what was assigned..in other words, if somebody has assigned a named or doc CAL and doesn't use it, I won't see it in that app.

Re: Where to read license usage from?

Tue, 28 Jun 2011 01:33:05 GMT

Seems that maybe you could parse the XML file that the server generates

to get your assigned CAL's?

Re: Where to read license usage from?

Tue, 28 Jun 2011 02:16:58 GMT

that sounds interesting..do you know the name of that file?

Re: Where to read license usage from?

Tue, 28 Jun 2011 04:27:56 GMT

You would need to dig into the licenses.htm (and likely the css

stylesheets) to figure out where its calling for the CAL details. Sorry,

haven't done any web development in a decade so I'm a bit rusty... there are

also several .pgo files which I suspect store the license details but no

clue how to open/parse them (likely proprietary).

Where to read license usage from?

Tue, 28 Jun 2011 16:33:54 GMT

I took a look at licenses.htm but after playing around with included js functions , I give up. Do you know of an easier method to do this?

Where to read license usage from?

dvasseur — Wed, 27 Jul 2011 14:16:55 GMT

I have just started playing with QMS API and I have created a small application to retrieve CAL definitions (Named CAL/Doc CALs, documents authorizations if using DMS). These informations are stored in xml files which can be loaded in a QVW.

Some remarks:

NET 3.5 required (same as Qlikview Server)
You have to be in the "Qlikview Administrators" and "Qlikview Management API" groups
QVS and DSC have to be on the same server
I have just loaded to files in the QVW, there is no design yet (feel free to contribute 😉
This is just a beta/proof of concept application, use at your own risk !

You can download the file here: http://dl.excelcio.com/QVSCALManager_beta.zip

Next step: do the same in a WebService so that info can be retrieved within Qlikview with a "load from http://xxx"

PS. for those interested in developping their own applications, check this file C:\Program Files\QlikView\Management Service\QMSAPIDocumentation.chm (should have be stored in the SDK folder IMO...)

Where to read license usage from?

Thu, 28 Jul 2011 20:46:48 GMT

Hi David,

I'm trying to download but it seems dl.excelcio.com is not available. thanks,

Re: Where to read license usage from?

dvasseur — Thu, 28 Jul 2011 21:27:30 GMT

Hummm, strange... see the attached file

Re: Where to read license usage from?

Fri, 29 Jul 2011 15:53:16 GMT

Hi David,

I've added myself to the Qlikview Management API but I'm getting a "Service Key has expired" error. Please see attached image.

Thanks!

Re: Where to read license usage from?

dvasseur — Fri, 29 Jul 2011 16:33:43 GMT

Humm, strange ! Service key is valid for 1 min I think, do you have a lot of cals/documents on your server ? Or maybe AD groups resolution is taking some time...

Anyway, here is an updated version with some more calls to retrieve a service key, quick and dirty but should be enough for now !

Re: Where to read license usage from?

Fri, 29 Jul 2011 20:58:56 GMT

It works now and it's exactly what I needed, thanks a lot!

One question, is it possible to run the exe file in batch mode? I'd like run it everyday as part of my publisher tasks.

Re: Where to read license usage from?

dvasseur — Fri, 29 Jul 2011 23:18:36 GMT

Great !

Right now, it cannot be run in batch mode. I could rewrite it that way but I may prefer to implement it as a web application. That way you could directly extract data into a qlikview application, for example:

CALS:

load * from [http://<server>/qvscalmanager/get_cals];

Docs_info:

load * from [http://<server>/qvscalmanager/get_docsinfo];

...

The only drawback is that it would require IIS support, hummm... Or could it be integrated into QVWebServer ? Or maybe I could write it as a plugin for QVSource (hi Chris ;-))...

Well, as I said, it just a beta/poc right now, I'll be happy to have your feedback on this ! So 'batch exe file' or 'integrated into IIS/webserver' ?

Re: Where to read license usage from?

Sun, 31 Jul 2011 03:52:30 GMT

Integrated into webserver is a much better idea.

On Jul 29, 2011, at 6:18 PM, David Vasseur <

Re: Where to read license usage from?

Wed, 10 Aug 2011 19:25:42 GMT

David, great example!

At our site there is a need to run this in batch mode, could you possibly make the Server configurable (app.config) & the Retrieve command execute on run perhaps? That would be great. If you lack the time I could do this if you send me the source code. Thanks, Diederik

Where to read license usage from?

rwunderlich — Wed, 10 Aug 2011 22:33:47 GMT

Great tool David! Thanks for posting it.

-Rob

Where to read license usage from?

dvasseur — Thu, 11 Aug 2011 09:35:57 GMT

Good to see you find it useful !

I'm on vacation right now but I'll be back at the end of august and will do a web and command line version. I will also release the source code after some cleanning!

In the meantime, feel free to create a nice QVW for it

Where to read license usage from?

Thu, 11 Aug 2011 14:52:39 GMT

Hi David,

I'm very happy with your application, but i also want to schedule it or want to execute it during the script.

Maby you can change it in a way so you can execute it in a cmd line en add a paramater for the servername.

I hope i triggered you're fingers .

Thanks anyway!

Greetz, Halmar

Where to read license usage from?

Mon, 15 Aug 2011 09:24:45 GMT

Hello,

I have just downloaded your program. Unfortunately I just get the message »Connecting to QMS server 'localhost'...failed!«.

Any idea why I can't connect to the server even though I'm executing the program directly on the server.

Thanks & regards