How to Control the Size of the Results List
On the Group Hub page of the BizTalk Server Administration console, the Query results pane contains so many columns of information that you need to scroll to view them. You can add or remove columns in the pane to display only the information that you need. To add or remove columns, right-click any part of the Query results pane and click Add/Remove Columns on the context menu.
Prerequisites
You must be logged on as a member of the BizTalk Server Administrators group to perform this procedure.
To add or remove columns in the results list
Right-click any cell in the Query results list, and then click Add/Remove Columns on the context menu.
Note
Items that are already present in the results list appear on the right side under Displayed Columns. Items that are not present in the results list appear on the left side under Available Columns.
To add a column, select one of the items from Available Columns and click Add to move that column to the list of Displayed Columns.
To remove a column, select one of the items from Displayed Columns and click Remove to move that column to the list of Available Columns.
You can control the number of results that the query returns by using the filters that are provided when you create or run a query.
Columns in the Query Results List
The query results are displayed in the Query results pane at the bottom of the view that originated the query. You cannot directly access the results list. The context menu shows all of the actions you can perform on the selected record within the currently active view. For example, if the record contains a Service Instance ID, then service-related actions appear. If there is a Message ID, then message-related actions appear.
Because you might not need all the information contained in this complete list, you can select only those columns you want to view, or you can replace columns that you removed. When you sort the results list by time, the instances sort up to milliseconds, even if no milliseconds appear on the list. When you reuse a saved query the results show only the columns selected each time the query is run.
The following table shows a complete list of the items that appear in the results list.
| Service or Message field | Description |
|---|---|
| Service Name | Name of the service instance. |
| Event Type | Type of service (for example, messaging (reported as Pipeline), orchestration, transport adapter). |
| Error Description | Description of the error if one occurred. |
| State | State of the operation when the query was run. |
| Error Code | Code of the error if one occurred. |
| Decryption Certificate | Shows the certificate information relating to the message or service. |
| Duration | Time for the operation to complete. |
| Port Name | Port involved in the flow of the instance. |
| Signature | Digital signature information of the message. |
| Size | Size of the message in bytes. |
| Start Time | Time the operation started. |
| End Time | Time the operation ended. |
| Part Count | Number of parts in the message. |
| Party | Identifier of the party starting the operation. |
| URI | URI of the initiating party. |
| TimeStamp | Time the operation started. |
| Host | Name of the BizTalk Host running the service instance. |
| Assembly Name | Name of the .NET assembly that implements the service instance. |
| Assembly Version | Version number of the related assembly. |
| Deployment Time | Time that the service instance assembly deployed into BizTalk Server. |
| Activity ID | Identifies unique service instance activity (for example, messages sent/received by the pipeline/orchestration have the same ID). |
| Service Instance ID | Globally unique identifier (GUID) that identifies a run of a service instance. |
| Message Instance ID | Globally unique identifier (GUID) that identifies a message instance. |
| Service ID | Globally unique identifier (GUID) that identifies a service. |
| Service Class | Type of class (pipeline or orchestration). |
| Service Class ID | A service-independent GUID that identifies a service (for example, orchestration). |
| Icon | Icon of the result row. |
| Adapter | Adapter used in the operation. |