Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More

How To Find QVD Dependencies

Creator III
Creator III

How To Find QVD Dependencies

The QvdDependancies.qvw is an application that finds all the dependencies of every qvd file on the machine's local drives, defining which qvw file is the creator of the qvd and which are the qvw files that use this qvd in a LOAD statement.


If you would like to use it you should enable macros as it has some vbscript code running in order to define the names of the local drives and store them in a variable.


Special credit to gwassenaar‌ whose code from this discussion helped me a lot! !


Update 5/8/2016: Added functionality not to perform a full system scan if not necessary (ver 1.2)

Tags (3)
Labels (3)
Attachments
Comments
Partner
Partner

Hi Dimitrios,

what if the user doesn't want to scan ALL the local drive?

I've got tons of QV artefacts from previous projects and have no need to view them alltogether.

It would me much better if the user was able to specify the exact folder to scan into.

Have a look at my similar app, where the option of selecting folder is pre-built: Lineage / Dependency Analyzer for QlikView

Creator III
Creator III

This functionality is one of the to-dos for the next version of the app...:)

In my case scanning all the local drives was a necessity because the file system of the development server was truly a mess and no one knew which qvd was dependent where...

Running the app on my development server and scanning a total of 1TB of local drive space the app execution time was under 2 minutew...

0 Likes
Not applicable

Thanks Dimitrios! Very usefull application!

Specialist
Specialist

Hi Dimitrios,

thanks for this great app!! i agree with Vasily here but if it will be included in your next release i'll be waiting!

Thanks a ton!

Creator III
Creator III

I will do my best to prepare the next release between the next few days...

Thank you and everyone else commenting on my app, it means alot to me!

0 Likes
Specialist
Specialist

It would be great if you could include some guidelines on which variables to change etc...

Thanks! Very helpful

0 Likes
Creator III
Creator III

What do you want to change, can you be a little more specific?

I am currently working on a new version that will give the user the

opportunity to scan only the folders that he wants as well with the current

functionality of the full scan...

Than you for your comment!

On Tue, Aug 2, 2016 at 2:18 PM, Hartley Julian <qcwebmaster@qlikview.com>

0 Likes
Creator III
Creator III

Good evening to everyone.

I have added the functionality not to perform a full system scan if not necessary (ver 1.2).

I hope that you will find the app useful.

Any comment will be appreciated a lot!!!

Creator II
Creator II

Excellent! Thanks a lot!

Master
Master

thanks for sharing

very helpful

Version history
Revision #:
1 of 1
Last update:
‎2016-07-28 08:22 AM
Updated by: