Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are moving tow of our databases to a new server. I have about 400 QVWS that I need to scan to see if they reference the databases that are moving. Anyone know of a way I can do this without having to open each one at a time? I think it can be done with the governance dashboard, but I cant Figure out how.
Open the qvw with an editor like notepad++ and then search for your database - I assume that you find this information by LineageInfo --> Discriminator. If the approach worked you may create an appropriate batch (or adjust something similar which you will probably find with google). Maybe easier could be to use Qlik which could read these information if the qvw is read as xml - for an appropriate loop-logic with dirlist/filelist take a look on the help by for each ...
- Marcus
The only other option would potentially be the Governance Dashboard:
https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/What.htm
Regards,
Brett