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)`

Universal CMDB11.0

Use > Data Flow Management > Integrations > Integration Studio > How to Work with Data Push Jobs > How to Perform Delta Synchronization based on TQL Query Layout

How to Enable Delta Synchronization Based on TQL Query Layout

Previously Delta Synchronization for data push works based on the last_modified_time attribute only, meaning if this attribute is changed compared to the last push, it is included in the data push result that will be sent to the target system.

Starting with this version, it is possible to decide whether you want to run Delta Synchronization to push CIs to target systems or not based on the attributes defined in a TQL query layout. This means that if the last_modified_time attribute is changed but no other attributes from the layout is changed, then the CI will not be sent to the target system. If you have an attribute changed from the TQL query layout, then the CI will be sent.

Example:

You have the TQL query Node with the layout name, description, and serial_number

If the attribute description is changed then the CI will be sent.
If the attribute Node is changed, then the CI will not be sent.

To enable delta data push based on TQL query layout, do the following

Create a TQL query with the layout of your choice.

For details, see How to Define a TQL Query in the Universal CMDB Modeling Guide.

Important The more attributes you add in the TQL query layout, the more processing time will be required for the delta data push jobs.
To enable Delta Synchronization for data push jobs based on TQL query layout,
1. Go to Data Flow Management > Adapter Management, from the Resources pane locate the adapter that you want to use for your data push jobs.
2. Right-click the adapter and select Edit Adapter Source from the context menu.
3. Locate the following setting:
```
<adapter-setting name="push.changes.based.on.attributes">false</adapter-setting>
```
4. Change the value from false to true.
  
  Note If the setting does not exist, add the above line with value setting to true.
Run Delta Synchronization for your data push jobs.

Note The laboratory performance testing of a TQL query Node --> Interface with 1.2 million CIs indicates a decrease of the performance with this feature enabled, due to the fact that the processing time is increased by 30%. Therefore, this feature should be used carefully based on how your data looks and how your data is modified by other jobs (discovery, enrichment, and so on).

Send Help Center feedback