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
Metadata
1 maintainer
Release files for qsense 0.8.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| qsense-0.8.4.tar.gz | 24.0 kB | Details |
Built distributions (wheels)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| qsense-0.8.4-py3.11.egg | Legacy Egg format | - | - | Details |
| qsense-0.8.4-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 132.7 kB
Release files / qsense-0.8.4.tar.gz
| Download URL | qsense-0.8.4.tar.gz |
|---|---|
| Size | 24.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
a0fff5e8671ad583e46f806e718155a66cef46c42fc5cc0cbe484673f8ae49b4
|
|
BLAKE2b-256 checksum How to use checksums |
89976e3afcd01dbabd043238081ac7e6a741819aa68992982eea22603156d07f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.2
|
Release files / qsense-0.8.4-py3.11.egg
| Download URL | qsense-0.8.4-py3.11.egg |
|---|---|
| Size | 68.8 kB |
| Tags | Egg |
|
SHA-256 checksum How to use checksums |
ac130ddddc6a27ca0a1bbaf4d06fefdcc68a7913335c70a49bfd827e6d5489a5
|
|
BLAKE2b-256 checksum How to use checksums |
4c79f97c9bcb0e333ebf3d2c380e4f763cb12cd5686d06a15da3e739465b7021
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.2
|
Release files / qsense-0.8.4-py3-none-any.whl
| Download URL | qsense-0.8.4-py3-none-any.whl |
|---|---|
| Size | 39.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
ffe5eede479dfd6859832c97a32e4cb1d7c20c075911b44966bac0ea167959e0
|
|
BLAKE2b-256 checksum How to use checksums |
0e691ceefb754721bd1d067d7bfd6a15d1ddd0728287f522a32e9a2034e32a21
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.2
|
