Hola amigos buenas.
I am trying to get the information of all the Vault properties to create an analysis tool that allows me to visualize the properties, its provider, the vault to which it belongs and in general all the information that I can get in the Vault dialog box but in excel pivot table format that allows me to filter in a customized way and without the need to navigate between the different vaults and properties, the idea is automate tasks to make the export and transform the different tables with power query, this way the information is kept up to date with only one automated export task.
I have tried to make an export config but at the moment of opening and analyzing the udp.xml file the information is really limited or at least I can't find how to clean it in order to transform it into a useful data model that allows me to reach the final goal.
I have already done something similar with the information of the users, groups, roles, vault and it works as I wish my goal is to do something similar with the information of UDP'S, anyone has any suggestion or idea of how to achieve this goal, any idea or suggestion is welcome! (I do not pretend to manage or that the properties are editable, just that it is a read only file and serve me as a guide is already a great improvement for the administration and auditing of the udp's).
