Qlik Cloud Monitoring Apps - App Analyzer Update -... - Qlik Community

Michael_Tarallo · ‎2024-07-16

In august 2020 we introduced the App Analyzer for Qlik Cloud tenants, a powerful monitoring tool which tracks metrics such as an app’s memory usage, ensuring you stay within your quotas. It also aids in app optimization by revealing field and table sizes, and highlighting potential data modeling issues like synthetic keys and data islands.

robert99 · ‎2024-07-24

Hi Daniel

I can see the sheet_id. But is there any easy way to obtain the sheet Name in the table (as opposed to a link to the sheet)

Thanks

AlexOmetis · ‎2024-07-24

@robert99 - I looked into this and, at the moment, the Sheet Name is only accessible through Engine APIs (which potentially requires a session and web sockets etc), not the REST APIs that the monitoring apps use.

The way I worked around it was to run a Qlik-CLI script to run through all apps, exporting a list of the Sheet IDs and names to CSV... then imported this to an app that could link to the rest of the data on Sheet ID.

Here's the (somewhat untested) PowerShell I used... it takes a long time (hours) to run on a big environment. Apparently it's possible to pararellise in PS but that's beyond my skills!

.\qlik context use $Context

$apps = .\qlik app ls --json --limit 10000 | ConvertFrom-Json

$apps | Export-Csv data\$Context-apps.csv -NoTypeInformation

$sheetList= @()

foreach ($app in $apps)
{

	Write-Host APP: $app.name

	$sheets = .\qlik app object ls --no-data --json --app $app.id  | ConvertFrom-Json | Where-Object {$_.qType -eq 'sheet'}

	foreach ($sheet in $sheets)
	{
		Write-Host SHEET: $sheet.title $sheet.qId
		$sheetList += [PSCustomObject]@{
			appId		= $app.id
			sheetId		= $sheet.qId
			sheetTitle 	= $sheet.title
		}
	}

	# Inside the loop so we can see the file building as we go
	$sheetList | Export-Csv data\$Context-sheets.csv -NoTypeInformation

}

Daniel_Pilla · ‎2024-07-24

Hi @robert99 ,

As @AlexOmetis states above, you unfortunately can only fetch this data from the Engine API at this point in time, which requires something like the Qlik-CLI (which importantly can open apps without data for this information) to scan a tenant.

This metadata is on our roadmap to surface via REST as part of a larger initiative, but I do not have a timeline for when that will become available. When it does, rest assured (pun intended) that it will be included in the app ASAP.

Cheers,

robert99 · ‎2024-07-25

@Daniel @AlexOmetis

Thanks for the replies. I will give this a go as manually doing this using the sheet link is a bit boring (I was about 30% through and hoped there was an easier way).

But now it partly entered in the much improved App Analyser (using an Excel load and apply map) I think the sheet information is almost essential. I will get it all set up and report back. As to what the most popular sheet layouts are.

Thanks Robert

BTW. Qlik will not let me enter Daniel_P*lla.

The message body contains P*ll, which is not permitted in this community. Please remove this content before sending your post.

Ken_T · ‎2025-01-30

the link for the one resource "The Qlik Sense Monitoring Applications for Cloud and On Premise" no longer works, and gives an error...

vikram234

Hi ,

What do we mean by "Staging Apps" in this in this app. I see huge number of them on my tenant.

And saw the below definition in Qlik Help document.

"As a tenant or analytics admin, you can select a space for staged apps.

Do the following:

In the Administration activity center, go to Content > Apps.
Select Staged.
Select one or more apps and click Set space.

In the Select space dialog, select the space where you'd like to add the apps, and then click Confirm."

But it doesn't make any sense to me. Are these the apps that are impact of the people leaving the organization and then they become idle that come under this category ? Or

Are they actually displaying in the app from the On-Prem server ? Or Any others ?

Thanks

AlexOmetis

@Ken_T - the link has some invalid characters at the end - try this one: The Qlik Sense Monitoring Applications for Cloud a... - Qlik Community - 1822454

@vikram234 - Staged apps are those distributed from on-prem to Cloud that haven't yet been assigned to a space. For more, see Distributing apps to Qlik Cloud | Qlik Sense for administrators Help and Cloud distribution | Qlik Sense for administrators Help. However if you've had issues in your tenant or run certain Qlik-CLI commands, it's possible these are apps showing as staged if they're published but without a space (which should really only happen with cloud distribution) ...

vikram234

@AlexOmetis , Thank you for your response.

While we were setting up the CLI , I remember hardly moving 100 to 150 apps. With the help of Monitoring App , To my surprise I see almost 500+ apps that are staged.

Is there anyway to check the apps creation date when they were initially onboarded to SAAS from On-Prem ?
Anyway to check if these apps are really used by someone ?
Also , Is it possible that these apps become staged when the prior employee leaves the org and since his email ID becomes invalid , The apps related to him becomes staged ?

Thanks again !

Vikram

Qlik Cloud Monitoring Apps - App Analyzer Update - Session Level Data