Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where to read license usage from?

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.

74 Replies
Not applicable
Author

Hello David, I'm really keen to use your exe but it's not working for me. I'm usign QV server v11 and probably your application was designed for v9 or v10.

When I try to execute it I receive the message: "Connecting to QMS server 'localhost'.. failed".

I checked your config: you use a function called BasicHttpBinding_IQMSBackend.

I opened http://localhost:4799/QMS/Service in my server and that function doesn't exist, I wonder if maybe it was used in the v9/10 and not anymore in the v11. Any clues?

Also, do I need to execute the exe from a specific folder in the server?

Regards,

Daniele

dvasseur
Partner - Creator III
Partner - Creator III

Hello Daniele,

Indeed QlikTech broke (ok, improved ;-)) a few things. I've quickly patched the existing application to make it work on QV 11 but have not really tested it so use at your own risks ! There is also a command line version available, if you find the application to be useful just tell me and I'll also upgrade it.

You don't have to execute it in a specific folder.

Regards,

David

Update:

see here for latest version: http://community.qlik.com/message/221814#221814

Not applicable
Author

Hi Andre,

I'm also experiencing the same problem.

Did you manage to get it to work?

Thanks!

Not applicable
Author

Hello David,

     excellent work! I have tried the exe and it works on v11. I will play with it and give you my feedback, meantime thank you!

Regards,

Daniele

Not applicable
Author

Hello David,

   I have worked with your application. My goal is to have an analysis like this:

Document CALs allocated to this document: 20

Document CALs assigned to users: 10

Number of Users Authorisations: 30

The first info is on the "Document.xml" file created by your application.

 

The second one is missing, can you add it in the same document as a new tag? (I hope is possible, you already have the tag <DocumentCALsEmbedded>)

 

The third one is on the "documentName.qvw.Meta" file. The issues are: 1 this is not a structured file so is difficult to extract the info. 2 There a different file for every doc so you need to update manually the loader if you create a new doc or create a kind of cursor to check all your docs every time. Any clues? Do you have a different approach? Do you think you can add those info in your application?

Thank you again for the support!

 

Regards,

Daniele

dvasseur
Partner - Creator III
Partner - Creator III

Hello Daniele,

Please find attached an updated application and a Qlikview document using the generated XML files (put the qvw in the same folder and reload). This is still in beta but you should have the information you want.

Regards,

David

*** For QV v11 only (not tested with SR1) ***

UPDATE:

See here for latest version: http://community.qlik.com/message/221814#221814

Not applicable
Author

Hi David,

This application is just what we have been looking for but at present it relies on someone having to manually run the applictaion to update the xml files, is there anyway to do this via a bach or integrate it into QlikView loads?

Many thanks again for this, as even as it is it's a massive help.

Regards,

K

dvasseur
Partner - Creator III
Partner - Creator III

Hi K,

here is the command line version. You can use parameters to define which info you want to retrieve but basically, the following should be enough:

QVSCALManager.exe -SERVER localhost -LICENSE_CALS -DOCUMENTS -CALS -DOCUMENTS_AUTHORISATIONS

This will generate xml files in the current folder.

You can execute the program within QV script with the "execute" keyword.

I also have a IIS plugin version which can be called with a "load * from http://xxx" in the QV script but:

  • it requires IIS
  • it's a bit more complicated to configure

Are you using the associated QVW application or only the program to generate XML files ? If so it would be nice to have your feedback on it !

Regards,

David

*** For QV v11 only (not tested with SR1) ***

UPDATE:

See here for latest version:
http://community.qlik.com/message/221814#221814

Not applicable
Author

Hi David,

Unfortunately I am not having any luck with the command line version, it says "Error connecting to QMS server 'localhost', I am using QV10, would that make a difference?

I have been using the basic QVW application you posted initially and it has been great to help tidy up and document licenses. I plan to try and integrate this into a cutdown and slightly customised version of the QlikView Monitor to give our power users better visibility of the licenses as currently there is no way to keep them updated other than sending out spreadsheets!

Many thanks,

K

dvasseur
Partner - Creator III
Partner - Creator III

Hi K,

Sorry, I thought you were referencing the previous message from Daniele and so QV 11. If you are using QV 10 please use this version.

There is an updated QVW (see above my last answer to Daniele), it's v10 and v11 compatible.

Regards,

David

*** For QV 10 (SR1+) only ***

UPDATE:

See here for latest version:
http://community.qlik.com/message/221814#221814