eapowertools-archive / qs-data-connection-analyzer

Unsupported - The Qlik Sense Data Connection Analyzer is a Qlik application that parses script log files and queries the QRS API, allowing analysis of data connection usage, patterns, age, and cleanliness across a Qlik site. In short, this app will help to run a leaner, more performant, and more easily and holistically governed Qlik Sense site.
MIT License
9 stars 1 forks source link

Reload time #4

Closed Eclogesh closed 3 years ago

Eclogesh commented 3 years ago

Scripting is running endless ( 3 hrs. + still running ) no way out except abort it. Do we really need to depend on every script log to get the Data connections used?
When the Number of Days is set 1 . Still it is checking the apps if it is within 1 day or not.

Is there an alternative way to get with API without going through log files 1.Get the Apps and its associated data connection?

  1. Apps latest refreshed time
danielpilla commented 3 years ago

Hello, please refer to this page to read more about why the application works this way, and the alternative approach: https://adminplaybook.qlik-poc.com/docs/asset_management/data_connections/remove_unused_data_connections.html

In essence, if you are only after the most recent lineage of the most recent reload, you can use /api/v1/apps//data/lineage. Just note the cons to this approach in the article above (like not tracking who reloaded it). The Data Connection Analyzer is far more robust and parses all script logs so you can do a comprehensive audit. Yes, it can take many hours to run at first, but it is incremental after that.

Cheers,