Hi,
Question: Does anybody know how I can find out weather a given web template is assigned to any role without having to go trough all roles?
We are tying to do a query-workbook-web template cleanup but has faced some problems. Basically we want to delete all queries/workbooks/web templates that isn't assigned to or neccessary for any objects in the roles we use, but we do not want to delete queries that is used by a webtemplate that is displayed in the roles we use.
We can easily do that via metadata repository for queries and woorkbooks but it does not work for web templates. If you look at a web template in metadata repository, you do not see what role it is assigned to. But if you look from a role, you see the web templates that is assigned to it. I find that surprising.Ideas?
Martin