To help track disk space on a cluster, here’s a simple batch script that works on Windows. It accepts a list of hostnames, and outputs the size and free space on each server to a log file.Continue reading “Windows Server Reporting – multi-server total and free space logging via batch script”
Following a system restart, an overnight shutdown or a system update, some Windows services don’t always come up successfully. This script runs via Windows Task Scheduler and accepts one or more service names.
If the service isn’t running, it attempts to start it – and produces a log file to capture the incident.Continue reading “Check a Windows Service, if it’s not running, start it via batch script”
The main benefits of this script are that it requires a single row addition per log, with no manual increment of the version number, and the version control information can be surfaced by the engine either to the UI or via the APIs.
This assumes a HidePrefix of %.Continue reading “An updated Version Control tab for Qlik Sense & QlikView”
This simple snippet works with Qlik Sense and QlikView 12+ to recursively collect metadata from QVD files.
The snippet is available below, or the latest version is on GitHub.Continue reading “Recursive QVD index script snippet for Qlik Sense & QlikView”
Qlik Sense log files usually contain a reference to a build or engine number, and I’ve not yet found a complete list – so I’ve created one.
This list contains the current (at time of writing) list of Qlik Sense external version names to build number, release dates and end of support dates.
For the latest version of this list (and in CSV format), visit https://github.com/withdave/qlik-releasesContinue reading “Qlik Sense Release Version & Support List”
Following on my previous post, I had a look at the performance impact of enabling QVD and QVF encryption in Qlik Sense.
In this test, I’m using Qlik Sense Enterprise November 2019 release on an Azure B4ms (4 vCPU, 16GB RAM) VM running Windows Server 2019. Qlik Sense encryption settings were left at default.Continue reading “QVD read/write performance comparison in Qlik Sense Enterprise with QVD and QVF encryption”
From Qlik Sense Enterprise on Windows September 2019 (the option became configurable via the QMC in November 2019), users have the option of enabling one or both of QVD and QVF encryption – adding at-rest protection from people who shouldn’t have access to your valuable files. This is enabled server-wide and applies to all content on the environment.
The big issue that I see is that any security office is going to require that any and all encryption is enabled – without understanding the issues this could cause.Continue reading “Qlik Sense QVD / QVF Encryption (Qlik Sense Enterprise on Windows)”
As an update to my previous post on using lambda to automate snaphots, I’ve finally logged back into the Lightsail console and seen they have added a new feature – automatic snapshots.
It looks like the feature was added in October, based on the help site.Continue reading “AWS Lightsail snapshots – now automatic for Linux”
In QlikView, you had the ability to select multiple variables and delete them en-mass. In Qlik Sense, the UI permits you to undertake this activity one-by-one, and each takes two or three clicks.
This bookmarklet (Chrome only this time, not tried elsewhere) removes ALL variables from a Qlik Sense application by cheating the APIs used by the Qlik Sense client.Continue reading “Remove (destroy) all variables in a Qlik Sense application”
This .gitignore is based on experience of using various Windows, Mac and Linux OS – and a few unexpected commits. It is my go-to for Qlik projects, and was built using the GitHub gitignore repo.
Script below, or latest version on GitHub.Continue reading “.gitignore for Qlik Sense and QlikView projects”