QlikView 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.

"QlikView Governance Dashboard" introductory video.

We have a UDC (Active Directory) on Qlik Sense server. It has a daily trigger. In QMC, I found their last-sync time stamps are different. As you can see, user sync task was last executed on 3/18/2024 22:18. (see User sync task.png). But the UDC was last sync'd on 3/19/2024 14:23. (see UDC sync.png) Why the time are different?

• License Monitor: Explore license allocation and utilization over time by license type, user, and app.
  
  • v7.18.0  (June 2019 release) 
    • *June 27, 2019 update: Fixes not showing anonymous usage of Analyzer Capacity minutes -- no change to data model (QLIK-96593)
    • *Jun 7, 2019 update*: bugfix QLIK-96354 - reload fails if Analyzer Capacity allocated but unused.
    • "Usage Snapshot" sheet for quick reference of license usage (easy one-page screen shot of historical license utilization)
    • "Unified Licensing History" sheet showing Professional/Analyzer/Capacity usage across Sense and QlikView (requires signed license with Sense and QlikView Server April 2019; requires configuring the monitor_apps_qlikview_logs data connection) 
    • Addition of historical Analyzer Capacity Minutes used (Jun'19 and Apr19 patch 1 forward)
    • Compatibility:  April 2018 and later, but requires updating the following monitor_apps_REST data connections: *_user_condensed, *_license_analyzer, *_license, *_license_professional, *_license_overview

Hello Qlik Community, 
Recently I was posed with a question around .DS_Store Vulnerabilities that came up during a vulnerability scan on a Qlik Sense Server that a customer of mine has. I reviewed the vulnerability, and it seems that if customers uses Apple Products and browse folder structures, they can leave junk files that can open vulnerabilities, like .DS_Store. I was wondering if there was a Qlik Sense Level way of preventing these vulnerabilities. 

Outside of Qlik Security, in Windows GPO, you can block extension types. It would be required to remove any of the .DS_Store files to clear the vulnerability, but blocking the extensions at the user GPO level should prevent new .DS_Stores from being added. Regular File Scans for the extension type could also be a good practice. 

I would like to be able to recommend a Qlik Level solution as I manage Qlik for the clients, not Windows. Any advice from the Qlik Community? 

Thanks! 

• Sense Connectors Log Analyzer: Explore logs from Qlik Enterprise Connectors (ODBC & REST) to understand usage and search error messages.
  • v1.0.0 GA release in February 2019 patch 1 or April 2019 release
    • Can be configured to also load other Sense log data generated by the Operations Monitor
    • Requires REST connector version 1.7 or later and ODBC connector version 5.12 or later.

Details

Overview

Hello Everyone,

Need steps for the following.

how to configure or map the existing qlik sense environment to new postgresql server ( linux ). We have qlik sense on Windows and Postgresql on Linux already.

We want to add a new postgresql vm to the existing qlik environment.

Need steps iin how to map this new VM - postgresql on linux to exisitng qlik sense on windows  

• Operations Monitor: Investigate Sense system activity and performance, including app reloads, user sessions, sheet usage, QMC changes, Sense Engine performance logs, and errors and warnings.
  • v7.16.0.2 (April 2020 release)
    • No change in data model, but just UI update to facilitate Export Links to QCS: New sheet called "Export Links for Cloud"
  • v7.16.0 (September 2019 release)
    • June 27, 2019: Fixes missing Export CSV (QLIK-96596) and checks for empty log files to avoid reload failure (QLIK-96349) - 7.16.1.qvf
    • June 20, 2019 Fixes issue with mismatched Session End and Session Start visible on Session Details sheet (QLIK-93738)
  • v7.15.0 (April 2019 release)
    • Sheet usage within an app, including which sheets not used in given time periods (requires Sense February 2019 or later) 
    • Compatibility: February 2019 forward, though can be used with April 2018 and later with a few minor chart issues (missing "Always one selected value")
      • Also update the monitor_apps_REST_user_condensed data connection to add the appropriate userId and password, the same userId & password for the other monitor_apps_REST data connections

Hello,

i have a problem in the application Licence Monitor , 

I can't find all months in the dashboard : 

Any solution for this ? 

Thanks 

Regards 

Hi

Other than using Qlik Cli or powershell, is there any other way we can configure or develop an app?

Which notifies a group via SMTP/email, when a task(or a batch of tasks) completes or an app loads successfully.

Thanks in advance.

Hi

How I can track which streams have a particular CUSTOM PROPERTIES item value or I want to search all the Stream names which contain 1/many custom properties item value same was as tags(list of occurance).

Note: Those CUSTOM PROPERTIES are Resource Type: Streams and has different Values.

Thanks

I like to get the list of all the task names, Host Server, Where Status=Started

Scenario:

We have 3-4 Qlik Engines, Schedulers in cluster. 

This morning, while some ETL pre-processing running, I manually checked each started tasks for the host server name. Found 2 servers where doing all the tasks. So immediately I restarted the Engine & Scheduler services on the 3rd server.

Because I took that proactive action, when the huge number of apps started to load, all servers started participating. Thus speeding the whole process.

So I need a good way to get the list of host servers which can give me a quick picture of whats happening with all the tasks recently processed/processing.

Hope I could explain properly. 

*Qlik Sense November 2021 Patch 12.

Same Copies of logs in 2 locations C:\ProgramData\Qlik\Sense\Log and C:\Users\All Users\Qlik\Sense\Log

Are these duplicate or pointed/referenced file? 

Exactly same metadata (datetime, attributes, contents).

If duplicate, that means drive space feeling up x2 as much for each log.

Please let me know if any concerns or way arounds to avoid.

And Log>QlikMobilityRegistrar folder seems have millions of log files. Will it cause any performance bottleneck. 

• Sense System Performance Analyzer: Dive into system and service performance counters, Windows events, and Sense logs captured by Qlik Logging service (QLogs database)
  • v1.0.0 GA release in April 2019
    
    • Requires Qlik Logging Service configured and enabled
    • Compatibility: April 2019 and later
  • Beta released in February 2019 but replaced by v1.0.0

Regarding how to configure Qlik Logging Service, please refer to the help: Qlik Logging Service.

QlikView 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.

"QlikView Governance Dashboard" introductory video.

Hey Qlik Admins,

For Qlik Sense on Windows there is a massively useful resource in the Qlik Admin Playbook (https://adminplaybook.qlik-poc.com/) for administrators to guide them in administering a Qlik Sense site. However, more and more of our customers are moving to Qlik Cloud and a lot of tasks in the playbook do not translate directly to tasks in managing a Qlik Cloud tennant. 

Is there a similar resource available for managing Qlik Cloud Tennants? If so, please share!

If not, please share below tasks (and if possible the cadence you suggest) for activities that could be in such a playbook, so that we can start formulating some best practices together. To start, I have gone through all the topics in the current playbook to see if I think they are applicable to Qlik Cloud and added some of the tasks I can currently think of that should be added:

Curious for your input!

Ps. My current focus is on the "Analytics Services" side of Qlik Cloud, but feel free to also suggest tasks for the "Data intergration" part if you have any.

Hi Team,

We are trying to do POC for Qlik alerting and Insight advisor integration with Teams/slack. Can you please define the steps what need to be  check from server side  for integration with teams/slack for insight advisors.

Hello experts,

From the logs Engine>Trace>System_Engine.txt i got the records which mention,

"QrsSecurityManagement: Retrieved privileges in xx ms from the QRS"

What is privleges means here? Is it section access or retrieving privileges from Security rules for app?

In some cases i saw consecutive records of this. Why does Qlik retrieve this info for same user and app three times?

example

Also i saw some records of this which takes retrieve info +300000ms which equals 5minute.