Is it possible to track all .qvw's that are accessing a particular .qvd?

[#1]

Hi All,

I have a get of .qvd's that are commonly used across many .qvw's. I want to search the .qvw's that are accessing a particular .qvd. Is there any way to do that?

Thanks in advance!

Regards,

Anand

[prieper]

If you have switched on the log-files, you can inspect all logs for certain keywords.

HTH
Peter

[#3]

Thanks Peter!

Is a way to write a script within QV to automate this task?

Regards,

Anand

[#4]

Something like this might work:

LOAD
@1
FROM *.qvw.log (txt, codepage is 1252, no labels, delimiter is '\n', msq)
WHERE wildmatch(@1, '*.qvd*');

It reads all the lines in the logfile where the text '.qvd' is found.
Further improvements can of course be done by using text manipulation functions.
This removes anything on the line before the FROM keyword:

mid(@1, index(upper(@1),'FROM')+5,999) as qvdFile

Hope it helps you.

/Fredrik