
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
App Metadata Analyzer (Windows)
Nov 15, 2024 8:44:14 PM
Aug 5, 2020 8:16:38 AM
We are excited to share the official release version of the Sense "App Metadata Analyzer" app!
This is a "productized" version of the super app that @Daniel_Pilla and @Levi_Turner posted on Qlik Branch (qs-app-metadata-analyzer).
Data from this endpoint is derived as part of the app reload process, and therefore does not include any object or expression related metadata. The data from the endpoint includes:
* server metadata including number of server cores, total server RAM
For a deeper analysis of the application including a demo video, please refer to: https://adminplaybook.qlik-poc.com/docs/asset_management/apps/analyze_app_metadata_analyzer.html
June 2020 Update: In version 2.2.1 and forward of the App Metadata Analyzer, a new Alerting sheet has been added, along with two new variables in the load script. The purpose of this sheet and added capability is to make integration with Qlik Alerting as simple as possible. This new capability and view allows for a Qlik administrator to easily see what applications have breached what thresholds (as well as how many) and be quickly alerted on them. It also allows for the administrator to disable alerts for specific applications and mark others as under review, which might have a different cadence. Please see the attached guide for much more detail and example policies/configurations.
Version History
- v2.2.2 (July 2020) >
- Replaced the "AppName" field with the "AppNameUnique" field in many visualization objects to properly visualize identically named apps.
- v2.2.1 (June 2020) >
- Resolved incremental load issue to include imported apps with metadata that had not yet been reloaded on the server
- Resolved issue with application tag values not appearing
- Resolved autonumber collision issue with "FieldNameUnique" and "TableNameUnique" fields, due to AutoNumber() being used pre and post QVD
- Resolved issue where some threshold breaches were stored to QVD, forcing applications to be reloaded before a change of threshold would take effect
- Removed system fields and system tables
- Modified chart "Field # Records" to "Field Cardinality" on "Dashboard" sheet
- Modified "Threshold Analysis" sheet to use boolean logic for measures over/under thresholds vs a dynamic range
- Added in the sheet "Alerting" for visualizing threshold breaches and allowing for simple tie-ins to Qlik
- Alerting and NPrinting
- Added flagging of circular references
- Added ability to ignore applications from "Alerting" page with specific tag value
- Added threshold reference lines to "Dashboard" objects
- v1.1.0 > Fixed Incremental loading bug (field count changes over time) (QB-981)
- v1.0.2 > Added back error handling "loop" in load script to handle missing apps (QLIK-98225)
- v1.0.1 > Small fix to correct the KPI for Table Footprint
- v1.0.0 GA > First official release, compatible with June 2018 Sense and later, target release September 2019
- Required Configuration: In the "configuration" section of load script, update the vu_central_node_host_name and vu_virtual_proxy_prefix variables as described in the load script
Sheets:
Dashboard
Threshold Analysis
App Analysis
Alerting
App Availability


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Tyler,
On our customer's Qlik Sense platform we have disabled Centralized logging. Since this change for a couple of months ago the Metadata Analyzer stopped working as the QLog connector is removed from the platform.
So far we have not been able to find out whether we can get this app to utilize the physical logfiles and QVD files to reload the log data, like the other monitoring apps which are working as intended (e.g. Operations monitor).
Do you know any way to get this Metadata app to work again in an environment where centralized logging is disabled? Or the new version of app can do so?
Best regards
Ali


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
@AliAzizi : This app does not use Centralized Logging in any way whatsoever. What is "not working"? Is there an exception in the script log?


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Sorry, my bad. It is not this app but Sense System Performance Analyzer which is not reloading after the centralized logging was disabled.
Sorry for this mistake.
Br
Ali


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
@AliAzizi : Ahh. The Sense System Performance Analyzer exclusively uses Centralized Logging due to exclusively present information (i.e. performance counter information for services other than the Engine) which is not found in the underlying log files. So it will just not work if Centralized Logging is not configured / running / working.


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thank you for helping.
Br
Ali

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
This looks amazing - but I have a question - can it drill down to sheet owners? In the case that we have multiple contributors, we'd like to see who 'owns' each sheet so that they can be contacted should the sheet be too larger (taking up too much load time) etc. Thank you!


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
@crichter14 : What type of analysis are you after? I ask because this app provides insight into the data model of a Qlik app. It does not do any interrogation of what elements of the model are used (or unused) in any sheet or visualization inside of the sheet.

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Levi! I might be barking up the wrong tree - but at times we make data changes and we want to know who is using the change (so let's say a field changes its base underlying assumptions). We want to know how to reach out to a contributor who used that field or created that sheet so we can make sure they know there was a change. Does that make sense? Is that anything I can use to do that? I was using the Document Analyzer but it doesn't include users/owners.