BizTalk360 allows you to create “Secure SQL Queries” that allow us to:
- Write optimized SQL queries and store them with friendly names in BizTalk360
- Assign who will have permissions to run the queries
- and run the queries, of course
This will allow us to easily check if any policy is in a non-compliance state.
With this SQL Server Query, you can check what are all your BizTalk Server BRE Policies, highest versions, that aren’t in the deployed state.