View the earlier version.Version 7.10

BizTalk360 allows users to execute queries against the BizTalk Message Box database (BizTalkMsgBoxDb) to get the list of suspended service instances and running service instances. When the query is executed from the UI, BizTalk360 triggers a service call that retrieves the list of service instances and their current state. In addition, the service call will retrieve other information related to the service instance such as creation time, error code associated with the error and its description.

Follow the steps as shown below to query the message box database and retrieve the information:

  1. Log in to the BizTalk360 application
  2. Click 'Operations' tab in the Navigation panel
  3. Click the expand button against 'Data Access' tab and select 'Message Box (Queries)'
  4. In the Message Box (Queries) screen, under Build Query Expression:
    1. Select Query - Choose one of the options from the drop down (All In-progress service instances, Running service instances, Suspended Service Instances) to retrieve the status of service instances
    2. Max Matches - Select the number of records to be fetched from the message box database. Ex. 10, 25, 50, 100....
    3. Add a filter - To filter the results based on different parameters. The parameters will vary while retrieving the status of In-progress service instances, running service instances, and suspended service instances. Once the filter criteria is selected, you will automatically see the values for the filter getting listed in the drop down. Ex. Host Name, Is Equal To, BizTalkServerApplication. When host name is selected from the drop down, the value BizTalkServerApplication & other host names will automatically be listed in the drop down. The user can select the required value
    4. The operator in most cases is 'Is Equal To'. But in the case of the category 'Creation Time', the operator will be 'On or Before'  or 'On or Later'.
    5. - To delete the filter criteria
  5. Click Execute Query. The Query Results section displays the list of All In-progress service instances, Running service instances, and Suspended Service Instances
BizTalk360 v8.0 allows users to export the Query Results. Click Export to Excel link to download the report to your computer.
Once a filter item is chosen from the drop down and while adding a new filter, the previously selected item will not be visible in the drop down.

Click the sliders to view the process of generating the list of the state of all in-progress service instances.

biztalk360 message box queries filter executing biztalk message box queries biztalk360 message box query conditions

Click the sliders to view the process of generating the list of the state of all running service instances.

adding a new query to the biztalk message box adding filter to biztalk message box query biztalk message box query results

Click the sliders to view the process of generating the list of the state of all suspended service instances.

view biztalk message queries suspended service instances in biztalk message box selecting a query in biztalk message box