Is there a table where I can get the content of the load scripts of all the Apps in Qlik Sense ?

[Malar]

Hallo , 

I have a requirement to replace an old qvd with a newly transformed qvd . I wanted to find the list of the apps that refer to the old qvd. 

Is there a way to find it out ? 

Thanks in Advance!

[Nicolae_Alecu · Accepted solution]

Hello,

I had the same problem.

I've made a QVD Tracker App by reading all QVD's Metadata and all tasks logs. 

From QVD Metadata you can get info about app that created QVD and when, and from the logs you can find out who is reading that QVD.

Also this might help:
https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-App-QVD-Meta-Data-Viewer/ta-p/1490077


 

[Malar]

Thank you @Nicolae_Alecu !

How do we read logs in Qlik?

[Nicolae_Alecu]

In QMC -> Service Cluster you will find Archived logs root folder, there you will find all logs, but you must read all logs from Script Folder.

This might help:

ReadLog:

Load
  left(Right('$(FoundFile)', len('$(FoundFile)') -index('$(FoundFile)','/',-1)),36) as Read_App_ID
  ,Replace(@1,'/','\') as QVD_FILES
 ,FileTime('$(FoundFile)') as ReadTime
FROM '$(FoundFile)' (txt, utf8, no labels, delimiter is '\n', msq)
where Upper(@1) like '*FROM*' and   Upper(@1) like '*.QVD*';  

 
And after that you have to Join app name, you can get it from REST connection or from QSR.

LIB CONNECT TO 'monitor_apps_REST_app';
select 
"id",
"name" 
FROM JSON (wrap on) "root" PK "__KEY_root";

As for the QVD Metadata (QVD Owner) you can use this:

CREATE:
 LOAD
    Replace(upper(Right(FilePath(),Len(FilePath())-index(FilePath(),'/',-2))),'/','\') as ID_QVD,
     CreatorDoc as Create_App_ID,
      ApplyMap('MapApps',CreatorDoc) as Create_App_Name,
     FilePath() as FilePath,
     FileName() as FileName,
     FileDir() as FileDir,
     FileTime() as CreateFileTime,
        FileSize() as FileSize
 FROM [$(vQVDPath)/*.qvd]
 (XmlSimple, table is QvdTableHeader);