Change Management module query samples

Using BMC Remedy ITSM Change Management, you can create a simple or complex query. A simple query uses only one key and one value. A complex query compares one or more keys and one or more values.

Simple query sample

Using the values in the following table, you can create a query using the query 1 input of <value>'key 1' = "value 1" </value>, returning changes for the ABC Company.

Inputs for sample simple query in BMC Remedy ITSM

HP ServiceCenter users can create simple and Advanced Find queries. A simple query that uses the values in the following table returns all changes where the ID equals 137.

Inputs for sample simple query in HP ServiceCenter

You can use two key/value pairs to create a simple query in HP ServiceCenter as shown with the values in the following table. The query returns all changes where the ID equals 137 and the name contains Jones.

Inputs for sample simple query in HP ServiceCenter using multiple search criteria

Complex query sample

Using the values in the following table, you can create a complex query in BMC Remedy ITSM using two additional values:

<value> 'key 1' = "value 1" or 'key 2' = "value2"</value>

This query returns all changes opened by the CEO and all changes that have a high priority.

Inputs for complex query sample

Advanced Find sample

You can create an Advanced Find query in HP ServiceCenter through a BMC Atrium Orchestrator workflow. The query string from the HP ServiceCenter Advanced Find is split into two inputs within the workflow. The query 1 input contains the field and operator, and the value 1 input contains the value. Using the values in the following table, all changes for the ID with an impact of High are returned.

Sample HP ServiceCenter Advanced Find query inputs