Sample Integration Push Query

The following image displays a sample query “SNOW Windows Push 2.0” to be pushed to ServiceNow:

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

Windows Server CIT is marked as Root, so it is a starting point.

The following mapping file is created ServiceNowGenericAdapter/mappings/push/SNOW Windows Push 2.0.xml and this is how it looks like in the Graphic Mapping Tool:

Note how the structure of the mapping file follows the hierarchy in the TQL query.

There are some details that needs to be explained regarding the “For” loop:

When pushing data to ServiceNow, we need to use Inbound Services, in this case ucmdb_integ_ci_network_adapter for pushing CIs of Interface CI Type. In ServiceNow ucmdb_integ_ci_network_adapter there is a reference pointing to ServiceNow Server table and because of that, it needs to have value of Windows Server global_id. That way we keep that reference across solution. Observe similar thing for IP address (it points to the Interface).