You can using script to read log files and find all apps that load QVD files
- Create a folder connection (ex 'Log_Folder' ) to Scripts log folder (ex:..\Qlik\Sense\Log\Script)
- Read data from Logs file by this script (you can edit if you want )
for each FoundFile in filelist( 'lib://Log_Folder ' & '\*.log' ) FileList_TMP: Load left(Right('$(FoundFile)', len('$(FoundFile)') -index('$(FoundFile)','/',-1)),36) as App_ID ,Replace(@1,'/','\') as QVD_FILES ,FileTime('$(FoundFile)') as ReloadTime FROM '$(FoundFile)' (txt, utf8, no labels, delimiter is '\t', msq) where Upper(@1) like '*.QVD*'; next FoundFile NoConcatenate FILE_QVD_TABLE: load App_ID, left(Right(QVD_FILES,len(QVD_FILES)-Index(QVD_FILES,'\',-1)),len(Right(QVD_FILES,len(QVD_FILES)-Index(QVD_FILES,'\',-1)))-1) as QVD_FILES ,ReloadTime Resident FileList_TMP where App_ID <>'13470956-078b-4287-a711-c055f9449fa1'; // exclude Current App Drop Table FileList_TMP;
Here is my result
This gets me close enough to mark as correct for anyone else who comes by.
Ideally, I'd only read the logs of a given timeframe to avoid getting duplicate counts. Also, I'd need a way of excluding from QVD_Files those entries that are the timestamped log entries and not the parsed QVD rows.
Thanks for the creativity of examining the logs.
The GetScript api would also work, but would need to be parsed to find the QVD files.