Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
moll_whit
Contributor II
Contributor II

How to Monitor which QVDs are being used in Apps

I'm trying to create a monitoring app that outlines all of the QVD files being read into each dashboard and the file path for each of those QVDs. We want to have visibility to this so if we need to change, update, delete a QVD, we know which dashboards we are going to touch. 

We started accomplishing this by reading in the most recent Log File being saved in either ArchivedLogFiles or ServerLogFolder. For the most part, I am able to grab the most recent script log file for each app and parse through it to grab just the records containing QVD Files. 

During testing, I saw that there are chunks of code that are present in the Data Load Editor, not being carried over to the Log File. It occurs during a for loop and creates a corresponding empty record for each line in the for loop. This resulted in us not having visibility to all of the QVDs being used in the App. 

Questions: 

1. What is the difference between ArchivedLogFiles and ServerLogFolder? What is the cadence and situation when each would get updated? 

2. Is there an easier way to accomplish this file monitoring? We are currently using QlikSense, for reference.  

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A more comprehensive solution would be to use the Qlik Catalog and Lineage product:

https://www.qlik.com/us/products/catalog-and-lineage

If I was going to RYO, I think a better approach may be to get the lineage data from your apps using the GetLineage API method

https://help.qlik.com/en-US/sense-developer/August2022/Subsystems/EngineJSONAPI/Content/service-doc-...

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A more comprehensive solution would be to use the Qlik Catalog and Lineage product:

https://www.qlik.com/us/products/catalog-and-lineage

If I was going to RYO, I think a better approach may be to get the lineage data from your apps using the GetLineage API method

https://help.qlik.com/en-US/sense-developer/August2022/Subsystems/EngineJSONAPI/Content/service-doc-...

-Rob

deepanshuSh
Creator III
Creator III

Hi, Is there any video tutorial for the same, and is this product part of already being used qlik infrastructure or do we have to pay for it?

Trial and error is the key to get unexpected results.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Some of the lineage function is included in the SaaS Impact Analysis feature. I'm not sure how the Catalog and Lineage connector is currently licensed. Maybe someone from the Qlik Sales team can comment. 

-Rob