Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > Modeling > Introduction > Topology Query Language > Topology Query Language (TQL) Overview

Topology Query Language (TQL) Overview

Topology Query Language (TQL) is a language and tool for discovering, organizing, and managing IT infrastructure data. It enables you to create TQL queries that retrieve business service data from the CMDB. TQL queries also help you display the data in a visual representation that facilitates data monitoring and managing.

Topology Query Language

TQL extends the standard SQL language by adding two important capabilities:

TQL enables you to draw conceptual relationships between configuration items (CIs), which represent their actual interdependencies. Using predefined operators, the different types of interconnections (relationships) that exist between CIs can be established, and consequently the infrastructure design and performance are more accurately represented. This representation serves as a basis and a model for the discovery, arrangement, query, and management of complex infrastructures.
TQL includes a graphical aspect, consisting of visual symbols and syntax, that represents the resources and their interconnections. This visualization of an IT infrastructure simplifies the understanding, monitoring, and managing of the IT business operations.

The Roles of TQL

TQL plays several roles:

Builds a business service model that defines and delineates the interconnection between IT assets that function together as business services. The business service model guides the discovery and identification of these business services, from the ever-increasing number and complexity of infrastructure resources. After the resources that comprise the business services are discovered, the business service model structures the way they are organized and managed in the CMDB.
Constantly searches the CMDB for changes that occur in the state of managed resources. When such changes are detected, the relevant subsystems are informed and updated.
Creates queries that retrieve business service data from the CMDB, and displays the data in a visual representation that facilitates data monitoring and managing.

Related Information

Send Help Center feedback