Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i need some help on how can i find APP name which is generating the QVD file
I am storing my qvd files in google drive
i am not using documentname() while generating qvd's
any automation read from google drive and get app name of the qvd?
The QVD files contains the APP ID which created the qvd. You can read the QVD in XML format and that will contain the app id. I know the monitoring apps have code you can copy to get the name of the apps and their app ids.
The QVDTableHeader has the CreatorDoc field which holds your appid
Hi i use this script
LIB CONNECT TO 'SpreadSheets';
QVD_Table:
LOAD QVDs as QVDs;
SELECT QVDs
FROM GetWorksheetV2
WITH PROPERTIES (
worksheetKey='ABS-BB:_0',
gidOverride='',
generatedNumberedColumns='false',
skipRows=''
);
for each qvd in FieldValueList('QVDs')
QVD_Details:
Load '$(vQvdPath)\$(qvd)' as _file_,
FileBaseName('$(vQvdPath)\$(qvd)') as fileName,
FileSize('$(vQvdPath)\$(qvd)') as fileSize,
//timestamp(FileTime('$(vQvdPath)\$(qvd)')) as fileModifiedTime,
// replace(FilePath('$(vPath)'),'lib://DataFiles', '$(vSystemPath)') as filePath,
Timestamp(QvdCreateTime('$(vQvdPath)\$(qvd)')) as filieCreateTime,
//SubField(TextBetween(concat([<?xml version="1.0" encoding="UTF-8" standalone="yes"?>],'##'),'STORE','.qvd'),'/',-1) as QVDName,
TextBetween(Concat([<?xml version="1.0" encoding="UTF-8" standalone="yes"?>],'##'),'<CreatorDoc>','</CreatorDoc>') as QVDSourceAppID
FROM [$(vQvdPath)/$(qvd)];
Next qvd;
Drop Table QVD_Table;
Exit Script;
this script works for me