Entitlement Analyzer for Qlik Sense Enterprise SaaS (Cloud only)

[Jamie_Gregory]

We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like: 

• How can I track the usage of my Tenant over time? How are my entitled users using the Tenant? 
• How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements? 

The Entitlement Analyzer is only available for Qlik Cloud subscription types. Refer to the compatibility matrix within the Qlik Cloud Monitoring Apps repository for an overview of which monitoring app is compatible with which subscription type.

The Entitlement Analyzer app provides insights on: 

• Entitlement usage overview across the Tenant 
• Analyzer Capacity – Detailed usage data and a predication if you have enough 
• How users are using the system and if they have the right Entitlement assigned to them 
• Which Apps are used the most by using the NEW "App consumption overview" sheet
• And much more! 

The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time. 

 A few things to note: 

• This app is provided as-is and is not supported by Qlik Support. 
• It is recommended to always use the latest app. 
• Information is not collected by Qlik when using this app. 

The app as well as the configuration guide are available via GitHub, linked below. 

• QVF: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest/download/entitlement-ana...
• Release Notes: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest
• Installation Guide: https://github.com/qlik-oss/qlik-cloud-monitoring-apps/releases/latest/download/qlik-cloud-monitorin...

Any issues, questions, and enhancement requests should be opened on the Issues page within the app’s GitHub repository.

Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up to date with the latest Qlik Support announcements. Please give this post a like if you found it helpful! 

Kind regards, 

Qlik Platform Architects

Additional Resources:

Our other monitoring apps for Qlik Cloud can be found below.

• App Analyzer
• Reload Analyzer
• Access Evaluator
• OEM Dashboard (for OEM Partners and multi-cloud tenants)

[cata_pli]

Hello @Sonja_Bauernfeind ,

I followed your above link and I am trying to find Qlik Sense Business on the official Qlik Price List, but none of the products in the Price List are called Qlik Sense Business. Is that product still available. Is it called something different in the price list ?

Thank you. 

[Sonja_Bauernfeind]

Do you mean this link? Qlik Cloud user-based subscriptions 

EDIT, Correction from the 29th of February: The User-based subscriptions (Qlik Sense Enterprise SaaS and Qlik Sense Business listed in the link) are available still through our Sales Teams. To register for Qlik Sense Enterprise SaaS or Qlik Sense Business, go to Contact sales and complete the application form. (source: Register a Subscription) 

All the best,
Sonja 

[Sonja_Bauernfeind]

Hello @cata_pli 

My initial statement was done in error. The user-based subscriptions are still available (see the above comment for details).

All the best,
Sonja 

[cata_pli]

Thank you @Sonja_Bauernfeind ,

Do you know why Qlik partners can't see the prices for these user-based subscription in the official Price List? Could it be that partners are not allowed to sell these user-based subscriptions ?

Even if that is the case, we should still be able to tell some clients who are fit for that kind of subscription prices and conditions. How should we go about it ?

[Sonja_Bauernfeind]

Hello @cata_pli 

This is a great question and point to raise. Please contact your Partner Manager and raise this with them. They can help get clarity on this and raise the topic internally.

All the best,
Sonja 

[Jenil_Sangoi]

We have setup entitlement analyzer in our environment for 1st time and it is hitting 3 hours of the timeout and failing. The maximum time out that we can set it 10000.

I have also user optional configuration to get data only for 1 day with variable SET vu_initial_days_back = 1;

RestConnectorMasterTable << RestConnectorMasterTable
failed to complete reload: Failure: Request aborted (15 GENERIC ABORTED)
The following error occurred:
User abort (Reload canceled due to exceeding maximum duration)

[Sonja_Bauernfeind]

Hello @Jenil_Sangoi 

Please post your questions and issues you have around the app in the appropriate git hub section: Qlik Cloud Entitlement Analyzer 

All the best,
Sonja 

[Jenil_Sangoi]

Thanks @Sonja_Bauernfeind. I have raised it on github as suggested.

[paulcalvet]

hello,

This application is great.

I don't found the licences todate inside, if a user don't use his licence he does not appear in this application.

So I modify the script and add this section, to retrieve the licence of each user at the reload date. It is useful when you want to check if a user use his licence.

LIB CONNECT TO 'Common:REST_licensesassignments';

data:

load * inline [subject];

For i=0 to 400 

if i=0 then

 let vParameter = '';

else

 let vLast = SubField(Peek('href', -1),'?',2);

 let vParameter = '?$(vLast)';

end if

RestConnectorMasterTable:

SQL SELECT 

"__KEY_root",

(SELECT 

"subject",

"type",

"userId",

"excess",

"created",

"__FK_data"

FROM "data" FK "__FK_data"),

(SELECT 

"__KEY_links",

"__FK_links",

(SELECT 

"href",

"__FK_next"

FROM "next" FK "__FK_next"),

(SELECT 

"href" AS "href_u0",

"__FK_prev"

FROM "prev" FK "__FK_prev")

FROM "links" PK "__KEY_links" FK "__FK_links")

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION(Url "https://mytenant.eu.qlikcloud.com/api/v1/licenses/assignments$(vParameter)");

;

[datatmp]:

LOAD [subject],

[type],

[userId],

[excess],

[created],

[__FK_data] AS [__KEY_root],

    1 as NbUser

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_data]);

left join (datatmp)

LOAD [__KEY_links],

[__FK_links] AS [__KEY_root]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_links]);

left join (datatmp)

LOAD [href],

[__FK_next] AS [__KEY_links]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_next]);

Concatenate (data)

Load * 

Resident datatmp;

drop table datatmp;

DROP TABLE RestConnectorMasterTable;

next i;

NoConcatenate

data2:

Load 

Distinct 

    * 

Resident data;

drop table data;

store data2 into [lib://Monitoring apps (shared space):DataFiles/datavizLicenses.QVD](qvd);

drop table data2;

LicenseTodate:

LOAD

    upper(subject) as subject,

    "type" as LicenseTodate,

    NbUser as NbUserTodate

FROM [lib://Monitoring apps (shared space):DataFiles/datavizLicenses.QVD]

(qvd);

[andreaslarsen]

Hi,

Maybe this question has already been answered, but I was wondering what the requirement was for a user to show up as a consumer in the sheets. I have tested with a bunch of users, who have logged into the cloud tenant, opened an app, clicked around several sheets, but is not showing up as a consumer after reloading the Entitlement Analyzer app.

I have tried to fetch the API details from /v1/licenses/consumption and I can find the user within the API, so what am I missing here I wonder? Is there some sort of time cutoff for them to show up as a consumer of their license?