How can I get a list of all functions on all tables from my Privacy project file

I have a projectfile and like to have a list of all the functions and the tables in my Privacy Project file. How can I extract this from my template?

Step-by-step guide

  • Start Windows PowerShell (use "Windows" key+R → PowerShell)
    Then type this command:

  • ([xml](Get-Content -Path <PRIVACYPROJECTFILE>.dpv)).project.states.state.pattern |select schema,table,identificatier,type


You can add or or remove columns from your output. Available fields on this Path are:

  • connection

  • enabled

  • excludenulls

  • identifier

  • isrecursive

  • name

  • table

  • type

  • schema