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 CMDB

Integrations > Third Party Integrations > ServiceNow Integration Using Enhanced Generic Adapter > Population from ServiceNow > How to Populate UCMDB with Data from ServiceNow

How to Populate UCMDB with Data from ServiceNow

To populate UCMDB with data from ServiceNow, do the following:

Configure queries

The population TQL query is created in UCMDB to indicate the data that needs to be populated from ServiceNow.

For the details of Population Queries, you can refer to Developer Reference > Creating Discovery and Integration Adapters > Developing Generic Adapters > Achieving Data Population using the Generic Adapter. The Generic Adapter works in instance mode (meaning it does not work with single CI types, but with collections of CIs grouped together by a main root CI).

The adapter comes with the following set of OOTB TQL queries that can be found under the Modeling Studio > Queries > Integrations > ServiceNow > Population folder.

ServiceNow enhanced generic adapter OOTB population TQL queries
Population TQL name	Description
SNOW AIX Population 1.0	Population of AIX servers
SNOW Apache Population 1.0	Population of Apache Web Servers
SNOW Business Application Population 1.0	Population of Business Applications
SNOW Biz Containment Biz 1.0	Population of Containment relationship between Business Service and Business Application
SNOW Biz Containment Computer 1.0	Population of Containment relationship between Business Service and Computer
SNOW Biz Containment Database 1.0	Population of Containment relationship between Business Service and Database
SNOW Biz Containment WebServer 1.0	Population of Containment relationship between Business Service and Web Server
SNOW Business Service Population 1.0	Population of Business Service
SNOW Computer Composition Database 1.0	Population of Composition relationship between Computer and Database
SNOW Computer Composition WebServer 1.0	Population of Composition relationship between Computer and Web Server
SNOW ESX Population 1.0	Population of ESX servers
SNOW HPUX Population 1.0	Population of HP-UX servers
SNOW Linux Population 1.0	Population of Linux servers
SNOW Windows Population 1.0	Population of Windows servers

For details on viewing queries in the Modeling Studio, see the HPE Universal CMDB Modeling Guide.

Create XML Mapping Files.

The XML mapping file describes the topology that should be pulled from the ServiceNow instance and how it should be mapped to the UCMDB class model. Mapping files for population are created in ServiceNowGenericAdapter/mappings/population/<name of the mapping file>.xml.
Define a synchronization schedule for the integration job, if desired.

Jobs can also be run manually, without a schedule.
Run full data synchronization.

Click to synchronize all data.