Transact sql query for BizTalk Orchestrations general properties

At times the BizTalk Administration Console is just not enough when it comes to quickly retrieve well formatted list of BizTalk services.

That's why I at times rather turn to SQL Server to get a detailed overview.

Below is a transact sql query for all BizTalk Orchestrations general properties.

Running this query will present the following properties of all your orchestrations:
  • Names
  • Statuses
  • Host instances
  • Assembly
  • Application
  • Last modified
  • Description

1 comment: