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