BizTalk360 allows you to create “Secure SQL Queries” that allow us to:

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.