Recent Documents
-
App Metadata Analyzer (Windows)
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 @D... Show MoreWe 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).
This app iterates over every application metadata endpoint along with several other QRS calls (Nodes, Apps, Proxies, LB audit), ultimately providing a comprehensive dashboard to analyze your application metadata server-wide. This allows you to have a holistic view of the makeup of all of your Qlik applications, enabling you to have awareness at a granular level of the types of applications in your organization. This application is 100% native to Qlik without any installer, and is easy to configure within the Qlik Sense Enterprise environment as the app takes advantage of the existing 'monitor_apps_REST_app' connection to drive all of the REST calls.As of the Qlik Sense June 2018 release, a new application level metadata endpoint is available. Data is populated for this endpoint per app post-reload in a June 2018+ environment. You can view this application metadata within your own June 2018+ environment at:http(s)://<server>/api/v1/apps/<GUID>/data/metadatawhere <server> is your Qlik Sense Enterprise server and <GUID> is the application ID. Note that the application is not lifted into RAM as metadata is fetched.
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* reload time* app RAM base footprint* field metadata including cardinality, tags, total count, RAM size, synthetic keys* table metadata including fields, rows, key fields, RAM size, circular referencesFor 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
- v2.2.2 (July 2020) >
-
QlikView Governance Dashboard app
QlikView Governance DashboardQlikView Governance Dashboard is a comprehensive analysis tool that allows QlikView administrators to effectively manage ... Show MoreQlikView Governance Dashboard
- QlikView Governance Dashboard is a comprehensive analysis tool that allows QlikView administrators to effectively manage the QlikView environment to gain a detailed understanding of its operation and performance. Optimize your company’s investment in QlikView and improve your productivity by streamlining tasks.
- Analyze QlikView Server performance, task reload history, license utilization, and QlikView app metadata.
- See a demo example of the Governance Dashboard HERE!
- v2.1.4 (Aug 7, 2019) Fixes blank [Node Name] (GOVDASH-191); Handles QVW and QVD names including [ ] ' (GOVDASH-190); Updated Help links (GOVDASH-189)
- v2.1.2 Sheet Usage in Sense Profile Score incorrect: only showing sheets used with AuditType=Document, AuditMessage=Open (The first sheet you open in a QV app). Fixes that issue (GOVDASH-188) -- June 21, 2019
- v2.1.1 Addresses issue of not loading tasks for which the Tasks.xml has not been modified within the configured months of history (GOVDASH-185)
- v2.1.0 Addition of "Sense Profile Score" (supersedes 2.0.5)
- It is highly recommended to split logging files daily or at least monthly, especially before an upgrade to 12.30 or later.
- NOTE: Audit logging must be enabled in QlikView Server in order for Sense Profile Scoring to work properly.
- Compatibility: QlikView 12.40, QlikView 11.20 SR10 and later, QlikView 12.10, 12.20. Note that if you upgraded to QV 12.30 GA you must split log files as described above (due to change in column order in QlikView Server log files.
