Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Malar
Contributor II
Contributor II

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

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!

Labels (2)
1 Solution

Accepted Solutions
Nicolae_Alecu
Creator
Creator

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


 

View solution in original post

3 Replies
Nicolae_Alecu
Creator
Creator

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
Contributor II
Contributor II
Author

Thank you @Nicolae_Alecu !

How do we read logs in Qlik?

Nicolae_Alecu
Creator
Creator

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);