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 DiscoveryContent Pack 27.00 (CP27)

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

How to Push Data from UCMDB to ServiceNow

To push data from UCMDB to ServiceNow, do the following:

Configure queries

The CIs and relationships to be pushed to ServiceNow have to be queried from UCMDB using TQL queries. Create integration type queries to query the CIs and relationships that have to be pushed to ServiceNow.

For the details of Push Query, you can refer to UCMDB Help > Developer Reference > Creating Discovery and Integration Adapters > Developing Generic Adapters > Achieving Data Push 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 set of OOTB TQL queries that can be found under Modeling Studio > Queries > Integrations > ServiceNow > Push folder.

ServiceNow enhanced generic adapter OOTB push TQL queries
Push TQL name	Description
SNOW AIX Push 2.0	Push of AIX servers and related file systems, network adapters and IP addresses
SNOW AIX Relations Push 1.0	Push of relationships between AIX servers and file systems, network adapters and IP addresses
SNOW Apache Push 1.0	Push of Apache Web Servers
SNOW Business Element Push 1.0	Push of Business Applications
SNOW Business Service Push 1.0	Push of Business Services
SNOW Business Service Relations Push 1.0	Push of relationships between Business Services and Business Applications
SNOW Cluster Push 1.0	Push of clusters and related servers
SNOW Computer Push 1.0	Push of Computers (excludes Windows, ESX, Linux, HP-UX and AIX servers)
SNOW DB2 Push 1.0	Push of DB2 database servers
SNOW ESX Push 1.0	Push of ESX servers and related file systems, network adapters and IP addresses
SNOW ESX Relations Push 1.0	Push of relationships between ESX servers and file systems, network adapters and IP addresses
SNOW HPUX Push 2.0	Push of HP-UX servers and related file systems, network adapters and IP addresses
SNOW HPUX Relations Push 1.0	Push of relationships between HP-UX servers and file systems, network adapters and IP addresses
SNOW LoadBalancer Push 1.0	Push of Load Balancers
SNOW Linux Push 2.0	Push of Linux servers and related file systems, network adapters and IP addresses
SNOW Linux Relations Push 1.0	Push of relationships between Linux servers and file systems, network adapters and IP addresses
SNOW Local Printer Push 1.0	Push of Local Printers
SNOW IIS Web Server Push 1.0	Push of IIS Web Servers
SNOW MSSQLDB Push 1.0	Push of MS SQL database Servers
SNOW MySQL Push 1.0	Push of MySQL database Servers
SNOW Net Printer Push 1.0	Push of Network Printers
SNOW Node Relations Push 1.0	Push of relationships between Nodes and file systems, network adapters and IP addresses
SNOW OracleDB Push 1.0	Push of Oracle database Servers
SNOW PostgreSQL Push 1.0	Push of PostgreSQL database Servers
SNOW Router Push 1.0	Push of Routers
SNOW Switch Push 1.0	Push of Switches
SNOW Unix Push 2.0	Push of UNIX servers and related file systems, network adapters and IP addresses
SNOW Windows Cluster Push 1.0	Push of Windows Clusters
SNOW Windows Push 2.0	Push of Windows servers and related file systems, network adapters and IP addresses
SNOW Windows Relations Push 1.0	Push of relationships between Windows servers and file systems, network adapters and IP addresses

For details on viewing queries in the Modeling Studio, see the Modeling section of the UCMDB Help.

Create XML mapping files

For every query created in the step above, create an XML mapping file with exactly the same name (case-sensitive) as the integration query with the following prefix:

ServiceNowGenericAdapter/mappings/push/<mapping file name>.xml

A set of mapping files for the TQL queries is provided out of the box with the package.

For more information about mapping files, see the Developer Reference section of the UCMDB Help.

Create the integration point

Define the integration point as follows:

In UCMDB, go to Data Flow Management > Integration Studio.
In the New Integration Point dialog box, enter a name and description for the integration point.

Ensure the Is Integration Activated option is enabled.
In the Adapter field click the Select Adapter button.
In the Select Adapter list, select ServiceNowEnhancedAdapter and click OK.

In the Adapter Properties section, enter the following required properties:

Field	Value
Protocol	HTTP or HTTPS. Default: https
Service-Now Domain	The ServiceNow domain. Default: service-now.com
Service-Now Instance	The ServiceNow instance being used.
Port	For HTTPS the default is: 443
Credentials ID	Define the ServiceNow instance user name and password in the Generic Protocol. For credential information, see Supported Protocols.
Proxy Host	The hostname, or address, of the proxy server.
Proxy Port	The port number of the proxy server.
Data Flow Probe	Select the name of the Data Flow Probe to run this integration.

Test the connection to the target ServiceNow server. If the connection fails, verify that the information provided is correct.
Click OK to save the integration point.
Add a new job definition to the integration point. Provide a name for the job definition and select the queries to use to synchronize data from UCMDB to ServiceNow. Define a synchronization schedule if required.

Note Jobs can also be run without a schedule.
Save the job definition, and then the integration point.
Click to run a full synchronization for each job at least once.

Send Help Center feedback