idea Re: Operations Monitor for Qlik Sense SaaS in Suggest an Idea

Operations Monitor for Qlik Sense SaaS

veronica1 — Tue, 27 Sep 2022 08:30:56 GMT

Hi,

a lot of users asked us if there is the possibility of monitoring users' sessions on Qlik Sense SaaS apps.

I checked all the monitoring apps that exists for SaaS, but none of them monitor who access which application and for how long.

For starters, we'd just need an easy way to check which users access an application in a certain range of time.

Re: Operations Monitor for Qlik Sense SaaS

chrislofthouse — Thu, 29 Sep 2022 09:33:27 GMT

It would also be useful to be able to audit user downloads and ideally what filters were applied.

Re: Operations Monitor for Qlik Sense SaaS

BISquad — Sun, 02 Oct 2022 13:53:31 GMT

Did you checked this?

https://help.qlik.com/en-US/sense-admin/August2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Monitoring_QSEoW/Operations-monitor-app.htm

Re: Operations Monitor for Qlik Sense SaaS

chrislofthouse — Mon, 03 Oct 2022 11:15:58 GMT

We are specifically referring to SaaS.

Re: Operations Monitor for Qlik Sense SaaS

BISquad — Mon, 03 Oct 2022 14:02:39 GMT

For Qlik SaaS did you tried to upload via QMC the:

App Analyzer for Qlik Cloud customers

https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-Sense-Monitoring-Applications-for-Cloud-and-On-Premise/ta-p/1822454

Re: Operations Monitor for Qlik Sense SaaS

paulcalvet — Mon, 24 Oct 2022 09:49:22 GMT

Hello, you can use the entilement analyzer ?

https://community.qlik.com/t5/Support-Updates/Latest-Version-of-Entitlement-Analyzer-for-Qlik-Sense-Enterprise/ba-p/1817404

it contains sessions duration and a lot of things. Beside it stores QVD with this data.

Regards,

Re: Operations Monitor for Qlik Sense SaaS

veronica1 — Mon, 24 Oct 2022 10:51:42 GMT

@BISquad @paulcalvet as I stated in the original post, the Entitlement Analyzer and App Analyzer don't contain session details like the Operation Monitor does, which is what we need

Re: Operations Monitor for Qlik Sense SaaS

paulcalvet — Mon, 24 Oct 2022 11:53:20 GMT

Hello,

You have this information in the QVD of this application.

I load the QVD generated by this application (exemple below), you can also load the app.qvd and user.qvd to complete the data model.

LogContent:
Load
id,
userId as _KeyUser,
sessionId,
1 as session_count,
appId,
endTime as _date,
%MonthKey,
duration,
Interval(round(duration/1000)/(60*60*24),'hh:mm:ss') as duration_time,
durationMinutes as _durationMinutes,
allotmentId,
capacityUsed,
minutesUsed,
licenseUsage
from [lib://Monitoring:DataFiles/entitlement_analyzer_Consumption_1.0.0.qvd] (qvd)
;

Re: Operations Monitor for Qlik Sense SaaS

veronica1 — Mon, 24 Oct 2022 14:26:40 GMT

Thanks, I'll try. Where do I find the app.qvd and user.qvd? The entitlement analyzer only generates:

entitlement_analyzer_Assignments_1.2.11.qvd
entitlement_analyzer_Consumption_1.2.11.qvd
entitlement_analyzer_Consumption_Overview_1.2.11.qvd

Thanks,

Veronica

Re: Operations Monitor for Qlik Sense SaaS

paulcalvet — Mon, 24 Oct 2022 14:57:45 GMT

Ah sorry, I believed that the original application generates this QVD but I added code for that.

You will find here my version which stores QVD :

https://community.qlik.com/t5/New-to-Qlik-Sense/Entitlement-analyzer-stores/m-p/1996191#M216921

Paul

Re: Operations Monitor for Qlik Sense SaaS

veronica1 — Mon, 24 Oct 2022 15:37:18 GMT

Don't worry, I already added several QVDs in my version of the app.

I've been able to develop a simple application with session durations for each app.

Thank you so much! You've been a lifesaver @paulcalvet

Re: Operations Monitor for Qlik Sense SaaS

jordan_weinstein — Fri, 28 Oct 2022 17:39:13 GMT

And see what sheets they're using and for how long

Re: Operations Monitor for Qlik Sense SaaS - Status changed to: Delivered

Ian_Crosland — Fri, 09 Dec 2022 11:52:18 GMT

The Entitlement Analyser app contains the following fields in the usage consumption section:

Dual(Month(Floor(endTime))&' '&Year(Floor(endTime)),Num(MonthEnd(endTime))) AS %MonthKey,
'$(vTenantID)' &'_'& Month(Floor(endTime))&' '&Year(Floor(endTime)) AS %TenantMonthKey,
[duration],
round(duration/60000)AS [durationMinutes],

and the Users sheet has a consumption chart showing app, user and duration :

Thanks for submitting

Ian