qSense
qsense is a python library and command line tool for QLIK QlikSense. It contains some useful functions for administrators/developers of QLiksense
It is built on top of the python libraries qsAPI and pyqlikengine
Installation
pip install qsense
Usage
export LOGLEVEL=DEBUG
NAME
qsense - qsense is a python library and command line tool for Qliksense administrators
SYNOPSIS
qsense COMMAND
DESCRIPTION
qsense is a python library and command line tool for Qliksense administrators
COMMANDS
COMMAND is one of the following:
add_entity
add a new entity (user, stream, dataconnection,...)
deallocate_analyzer_licenses_for_professionals
Deallocate analyzer license fom users with a professional license
deallocate_unused_analyzer_licenses
Deallocate analyzer license not used for N days
delete_removed_exernally_users
Delete users that were removed externally (from active directory?)
delete_user_session
delete user session
entity
Get a specific entity by ID or entity list or count
export_apps
Export (published or passing any other filter) applications to qvd files
get
generic get http from Qlik (service can be qrs or qps)
get_app_connections
Extract the connections from an app
get_app_dataconnections
Extract the dataconnections found in the app script
get_app_script
Extract the ETL script from an app
healthcheck
Get a specific entity by ID or entity list or count
old_apps
Find old apps using 'modified_date' and 'last_reload_time' filters: then you can export them or delete or notify via email the owners
open_doc
Load an app in memory, useful for preloading an app / cacha warmer
post
NOT TESTED: generic post http to Qlik (service can be qrs or qps)
update_custom_property_with_users_list
update the values of a custom property with the list of all qliksense users
update_entity
update an entity (user, stream, dataconnection,...)
user_sessions
user sessions
users
Get users with groups
users_with_unpublished_apps
Find users with too many unpublished apps
Look at the source file qsense/command_line.py for details
Examples
Changing all data connections after a file server migration
JSONFILE=ds-shares.json
rm $JSONFILE
qsense get qlikserver.redaelli.org client.pem /qrs/dataconnection/full --pFilter "connectionstring sw '\\\\\\\amzn'" | jq '.' > $JSONFILE
sed -e 's/amznfsx94rgsb1e/amznfsxe9chyjel/g' ${JSONFILE} > new-${JSONFILE}
qsense update_entity qlikserver.redaelli.org client.pem dataconnection new-${JSONFILE}
Exporting and/or deleting old applications
Not published and not updated/reloaded in the last 120 days
qsense old_apps qlikserver.redaelli.org client.pem /qrs/dataconnection/full --target_path /tmp --modified_days=120 --last_reload_days=120 --export --delete
Published in some specific streams and not updated/reloaded in the last 120 days
qsense old_apps qlikserver.redaelli.org client.pem /qrs/dataconnection/full --target_path /tmp --modified_days=120 --last_reload_days=120 --published --pFilter "(stream.name eq '000' or stream.name eq 'AAA' or stream.name eq 'BBB' or stream.name eq 'CCC')" --export --delete
Removing analyzer licenses for professional users
qsense deallocate_analyzer_licenses_for_professionals qlikserver.redaelli.org client.pem --nodryrun
Top users with unpublished apps
qsense users_with_unpublished_apps qlikserver.redaelli.org client.pem --threshold 30
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
qsense-0.8.4.tar.gz
(24.0 kB
view details)
Built Distributions
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
qsense-0.8.4-py3.11.egg
(68.8 kB
view details)
qsense-0.8.4-py3-none-any.whl
(39.9 kB
view details)
File details
Details for the file qsense-0.8.4.tar.gz.
File metadata
- Download URL: qsense-0.8.4.tar.gz
- Upload date:
- Size: 24.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.2 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a0fff5e8671ad583e46f806e718155a66cef46c42fc5cc0cbe484673f8ae49b4
|
|
| MD5 |
95115bdb15be1f27a81f3c58776a15c3
|
|
| BLAKE2b-256 |
89976e3afcd01dbabd043238081ac7e6a741819aa68992982eea22603156d07f
|
File details
Details for the file qsense-0.8.4-py3.11.egg.
File metadata
- Download URL: qsense-0.8.4-py3.11.egg
- Upload date:
- Size: 68.8 kB
- Tags: Egg
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.2 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ac130ddddc6a27ca0a1bbaf4d06fefdcc68a7913335c70a49bfd827e6d5489a5
|
|
| MD5 |
e367b53ec1a22c48b0623a5decb44601
|
|
| BLAKE2b-256 |
4c79f97c9bcb0e333ebf3d2c380e4f763cb12cd5686d06a15da3e739465b7021
|
File details
Details for the file qsense-0.8.4-py3-none-any.whl.
File metadata
- Download URL: qsense-0.8.4-py3-none-any.whl
- Upload date:
- Size: 39.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.2 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ffe5eede479dfd6859832c97a32e4cb1d7c20c075911b44966bac0ea167959e0
|
|
| MD5 |
2f10bad8406c6e35dc7702e65a296c06
|
|
| BLAKE2b-256 |
0e691ceefb754721bd1d067d7bfd6a15d1ddd0728287f522a32e9a2034e32a21
|
