Use the Query Window

Applies to User Roles:

System Administrator

Example: Retrieve all device records where the logical name begins with the character A.

In this example, we use the equal to (=) relational operator to perform an Advanced Search on records in the device.qbe form and returns all values in the logical.name heading that begin with the letter A.

To use the Query Window:

  1. Click Tailoring > Database Manager.
  2. Type =device in the Form field, and then click Search.
  3. On the Asset Information form, open the More Actions menu.
  4. Select Expert Search.
  5. In the Query field, type logical.name#“A”, and then click Search.
  6. Click any record in the list of returned records to view the details.

Note: A device is also referred to as an Asset or Configuration Item (CI).

Related topics

Complex query expressions
Stored queries
Record retrieval
Relational operators
Retrieving records using the Query window method
The Database Manager utility
Using functions in a query

Create a query using a simple query expression
Open the Query Window
Use like queries to search for a string of characters