Qlik Sense

Qlik Sense Metadata

• Qlik Sense data in the Datalogz Control Tower comes from four sources: the QRS API, the Engine API, server audit logs, and the NPrinting API

• Together, the information from these sources paint a detailed picture about what resources are stored in the Qlik Sense and NPrinting environments and how they are used

• Metadata is aggregated across sources to generate comprehensive alerts and insights

  • For instance, be aggregating across data from the QRS API, Engine API, and audit logs, we can determine if third party tools, such as VizLib, are going unused

QRS API

• From Qlik’s Repository Service API, we fetch most metadata about users and resources in the Qlik Sense environment

• This includes details about apps, data connections, tasks, users, licenses, and user directories

• In platform, this information makes up the Inventory page and backs several monitors and visualizations in the Insights and Exec views

Datalgoz Table	API Endpoint	Description of Data
qlik_sense_apps	/app/full	Metadata about apps in Qlik, including when it was created and last reloaded at, which stream it belongs to, its publication status, file size, and more.
qlik_sense_data_connections	/dataconnection/full	Metadata about data connections in Qlik, including the connection string, connection type, who the owner is and who last updated it.
qlik_sense_license_access_type_overview	/license/accesstypeoverview	A snapshot of the total number of licenses of each type and a breakdown of how many are used vs. available.
qlik_sense_analyzer_license_users	/license/analyzeraccesstype/full	All users with the analyzer license type.
qlik_sense_professional_license_users	/license/professionalaccesstype/full	All users with the professional license type.
qlik_sense_streams	/stream/full	Metadata about streams in Qlik, including the owner and when it was created and last updated.
qlik_sense_tasks	/task/full	Metadata about the various tasks in Qlik (reloads, external programs, user syncs, and distributes), including the last execution duration and status, whether it is manual or automatic, and the next execution time.
qlik_sense_user_directories	/userdirectory/full	Metadata about the user directories in the Qlik environment, including the type of directory and when it last successfully synced.
qlik_sense_users	/user/full	Metadata about users in Qlik, including their roles and attributes and which directory they’re a member of.

Engine API

• From Qlik’s Engine API, we are able to fetch more detailed information about apps than is available in the QRS API

• This includes an overview of the types of visualizations in each app as well as lineage information, such as which QVD files are referenced in an app

• In platform, this metadata is used in the Insights page

Datalgoz Table	API Endpoint	Description of Data
qlik_sense_app_elements_agg_engine	GetAllInfos	A mapping of each element type to the apps that contain it.
qlik_sense_qvd_files_agg_engine	GetLineage	A mapping of each QVD file to the apps that reference it.
qlik_sense_apps_agg_engine	GetAllInfos, GetLineage	A comprehensive apps metric table, including the app element types and QVD files in each app.

Audit Logs

• From Qlik’s server audit logs, which we ingest via a connection to an S3 bucket, we are able to obtain user activity information, including app opens, file uploads, and logins

• When combined with data from the QRS and Engine APIs, this information is used to produce alerts and insights regarding unused apps and licenses, as well as governance and security concerns such as suspicious logins or unauthorized app access

Datalgoz Table	Source	Description of Data
qlik_sense_activity_audit	C:\ProgramData\Qlik\Sense\Log\Repository\Audit\AuditActivity_Repository	An audit log of user actions in Qlik, such as app opens and file uploads.
qlik_sense_security_audit	C:\ProgramData\Qlik\Sense\Log\Repository\Audit\AuditSecurity_Repository	An audit log of security-related user actions in Qlik, such as logins and user directory syncs.

NPrinting

• From Qlik’s NPrinting API, we fetch metadata about the resources and users in the NPrinting environment

• Together, this metadata provides another layer of usage information about the apps in the Qlik Sense environment

Datalgoz Table	API Endpoint	Description of Data
qlik_sense_nprinting_apps	/apps	Metadata about apps in NPrinting, including when it was created and last updated.
qlik_sense_nprinting_connections	/connections	Metadata about connections in NPrinting, including the connection status, source, and associated app.
qlik_sense_nprinting_reports	/reports	Metadata about reports in NPrinting, including the report type and output formats.
qlik_sense_nprinting_roles	/roles	Details about each of the role types in NPrinting and whether it’s enabled in the environment.
qlik_sense_nprinting_task_executions	/tasks/<task_id>/executions	A log of the task executions in the NPrinting environment, including the execution type and completion status.
qlik_sense_nprinting_tasks	/tasks	Metadata about tasks in NPrinting, including the task type, whether it is enabled, and the associated app, when applicable.
qlik_sense_nprinting_user_roles	/users/<user_id>/roles	A mapping of NPrinting users to the roles assigned to them.
qlik_sense_nprinting_users	/users	Metadata about users in NPrinting, including their email and domain account.