How can I, per .qvw file see the assigned CALs on Qlikview server?

[#1]

Hi Qlik-community,

At one of our clients I got a question if it is possible to load from Qlikview server the assigned CALS per .qvd file on the accesspoint.

They for example have 75 CALS assigned to a set of couple of .qvw docs...

They now have a lot of .qvw's in the accesspoint, with a lot of CAL's assigned to them so users can use them...

What they like to load into a .qvw file is

- per .QVW

- which CAL's are assigned to which .QVW file

Is that possible?

We know that we can check the .qvw files one by one in the Qlikview management console, but we like to load this into qlikview to be better able to manage CAL-assignments and identify CALs assigned to documents where it is not needed.

My first thought was that it might be possible with the governance dashboard from the Qlikview market, but it seems that this governance dashboards only checks things inside .qvw files and cannot provide what i want (...).

Someone ideas how to get this in a simple overview?

Thanks!

Roberto

[RedSky001]

You can use the Qv User Manager part of the power tools to get this information and save it to a file.

See this link http://community.qlik.com/docs/DOC-3059

Once you've installed this program

update the following file

qv-user-manager.exe.config

Replacing the server name with your servername

<endpoint address="http://TSQVLIVE:4799/QMS/Service" binding="basicHttpBinding"

Start > Run > cmd

CD to the path where qv-user-manager.exe is installed

Run the following command to list all CAL's and output the result to cals.txt

qv-user-manager  --list cal > cals.txt

Hope that helps

Message was edited by: Mark Sheraton Added some more detail

[#3]

Hi,

Thanks for this promising answer. I tested at an internal test-env, and I could use qv-user-manager to list some CALs. To test if it is really what I need, I need to execute it here (at our client), since their config is a bit different...

But there a problem comes in, and I hope someone can help me out:

When I execute the command you suggested (and which worked on my test-env somewhere), I get this error:

The message with Action 'http://ws.qliktech.com/QMS/11/IQMS/GetTimeLimitedServiceKey' cannot be processed at the receiver, due to a ContractFilter mismatch at the EndpointDispatcher. This may be because of either a contract mismatch (mismatched Actions between sender and receiver) or a binding/security mismatch between the sender and the receiver.  Check that sender and receiver have the same contract and the same binding (including security requirements, e.g. Message, Transport, None).

I think the problem is something in the config file or in the webServiceUrl.

In both config-files (qv-user-manager.exe.config) I have this setting:

      <client>

          <endpoint address="http://localhost:4799/QMS/Service" binding="basicHttpBinding"

              bindingConfiguration="BasicHttpBinding_IQMS" contract="QMSAPI.IQMS"

              name="BasicHttpBinding_IQMS" behaviorConfiguration="ServiceKeyEndpointBehavior" />

      </client>

When I put the http://localhost:4799/QMS/Service URL in the browser of the server, in the test-Env I get an XML-page (so it seems like a webservice as I'm used to see...)

But when I put this url on the server where it doesn't work, I get a popup to enter my credentials, and when I enter the QV admin credentials or other admin-credentials, I get a page not found, HTTP error 400 - bad request.

What setting can I check to make sure that the powertools work?

Or is it some licensing thing or another setting that I have to activate (or security setting somewhere)?

Any help is appreciated!

[both envs are QV11]

[RedSky001]

Internet Explorer is probably locked down on the server. 

The simple solution is to run qv-user-manager from another computer on the network which is not locked down...

[#5]

Hmz, I did try that, with no luck (on this server).

Additionally, I tried to access that URL http://localhost:4799/QMS/Service from an external computer (by replacing localhost with the computer's ipaddress of course.

No luck: the login-popup comes again.

Is that URL 100% correct? Or is there some place where I can send the credentials? It just seems that credentials are required (...). Or perhaps I need to change some other setting?

On the server where it DID work, I only had to change the URL in the config... Shouln't that be enough?

[RedSky001]

When you copy and paste http://<YourServerName>:4799/QMS/Service into IE it should load the page with the XML.  The login-popup screen will stop qv-user-manager from running as it assumes you have permission to the URL.

Can you access the the QMC from the remote machine?

Go to http://<YourServerName>:4780/QMC/SystemSetup.htm and click 'Management Service' you can see the URL on the right, check that's what you are using. 

This sounds like a permisions issue with you and the QMC.

[#7]

Thanks for your reply...

On that page (management service) I see this URL

http://IPADRESS:4799/QMS

If I paste THAT url in Internet explorer, I do get XML (no matter if it is done on the server or on an external computer).

Note that the /Service part is missing...

But assumed that I should use this URL, I tried this in the .exe.config file and retested the working of the program

now I got this error while executing it:.

There was no endpoint listening at  http://IPADRESS:4799/QMS  that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.

Any other clues?

(and of course thanks a lot for all the replys so far! your help is greatly appreciated)

[RedSky001]

Try 'http://IPADDRESS:4799/QMS/Service' as the end point

(Intresting name for a server too!)

[#9]

Yes, I already tried that (and did retry), but in that case the login/password popup pops up again (...).

Where could that pop-up come from?

#edit

(you might have guessed that I removed the ipaddress / servername in the URL. Not that much can be deducted from it though...)

[RedSky001]

Add yourself to the 'QlikView Management API' windows group on the server!  That must be it