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 WINDOWSKEY-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