Building queries in BMC Atrium Explorer
For better analysis of your BMC Atrium Configuration Management Database (BMC Atrium CMDB) data, the Query Builder helps you build topological queries with any pattern possible. In addition to building simple queries that walk a particular path, you can build pattern queries to create service models. You can then link logical configuration items (CIs), such as technical services) to corresponding applications or to servers that support the service. You can also specify count restrictions in the criteria for a relationship. This functionality allows you to create queries that return, for example, only servers with three or more hard drives.
- Creating a simple query in BMC Atrium Explorer
- Creating an advanced query in BMC Atrium Explorer
- Creating queries with folding rules in BMC Atrium Explorer
- Editing or copying a query in BMC Atrium Explorer
- Configuring query options in BMC Atrium Explorer
- Using BMC Remedy ITSM or BMC Remedy AR System class forms to find CIs
Using the results returned by an advanced query, for example, all the applications and services that comprise the BMC IT Service Management business service at Calbro Services — you can analyze your current service models and create new logical entities.
You use the Query Builder to create new categories and new queries for configuration item (CI) and relationship instances. It helps you determine which CIs to display (or expand) in BMC Atrium Explorer.
When you drag an item from the result list to the Query Builder canvas, the graph expands according to the items in the query.
- You can use the query-by-path capability to search for any simple or detailed pattern containing multiple relationships.
- You can use the lanes in the Query Builder to construct complex searches. The lanes determine what level each item is displayed in.
The top lane in the query contains one or more items that are required in the query — results are only returned from the query if it includes instances of that item. The other lanes are optional.
The lanes used in the Query Builder only affect how items are arranged in query views. In regular instance views, the items are arranged according to the selected layout setting. The Layered layout arranges the items by levels pre-defined for each type.
You can include multiple items in multiple lanes. Based on the relationships that you draw between the items, the items in the various lanes are relative to each other:
- Items in the second lane are relative to the items in the top lane
- Items in the third lane are relative to items in the second and top lanes, and so forth.
- Items in the same lane cannot be joined together with a relationship.
When specifying the relationships between various items, you can specify that items in lower lanes must be returned in the query results. If the lower item must be present in each result, you restrict the CIs displayed in the query results list.
- You can include optional items in the query that do not restrict the results, but add more query items within the visualization.
- You can specify count restrictions in the criteria for a relationship. This functionality restricts the CIs displayed in the query results list and allows you to create queries that return, for example, only servers with three or more hard drives.
- You can build a query that circles back in a loop to the top item. For example, you might want your query to return all software servers that listen on a certain IP address, and also return the computer system. Only required links are supported in a loop.
You cannot query currency, diary, and attachment attributes.
- You can build a query with folding rules that hide less important CIs. You can later unfold these CIs in BMC Atrium Explorer as needed.