Creating an extended integration for ServiceNow assets

Let Oomnitza be your single source of truth!

Choose from three ServiceNow asset integrations in Oomnitza to gain complete visibility of your assets as data from ServiceNow is automatically transformed into consumable information and actionable insights.

ServiceNow CMDB CI API - Asset Load: Uses the Service Now CMDB instance API to call the CMDB Configuration Item (cmdb_ci) table in Service Now. The cmdb_ci table stores the basic attributes of all the Configuration Items. For further information, see ServiceNow Documentation: CMDB Instance API.

ServiceNow Asset Load: Uses the Service Now table API to call the Asset (alm_asset) table in Service Now. The alm_asset table contains general asset information relating to a company. For further information, see ServiceNow Documentation: Table API.

ServiceNow Asset Load Sync Last Number of Days: This is identical to the previous API except that it uses a filter to enable you to refine your results to the last number of days. 

Connect Oomnitza and ServiceNow in minutes

Get the information and insights that you need to reduce costs and the time that you spend on administration tasks such as:

• Configurable dashboards and list views of key asset and software information
• Configurable reports to share information about assets and software with your colleagues and management such as corporate-wide reports that detail the distribution and status of the assets and software in your environment

Navigation

Creating the integration

Creating custom mappings

Before you start

Best practice
For the integration with Oomnitza, create a dedicated user account.

Before you can create the integration with Oomnitza, you need to have added your ServiceNow OAuth credentials to Oomnitza and set your ServiceNow Subdomain as a global variable. For further information, refer to Adding your ServiceNow credentials to Oomnitza.

For the CMDB API Asset Load, you need to enter filters to query the cmdb_ci table response. 

• sys_class_name=cmdb_ci_computer^ORsys_class_name=cmdb_ci_database
• category=software^ORcategory=hardware
• categoryINsoftware,hardware
• subcategory=Computer
• subcategory=MacBook Air 13"

Creating the integration

To configure the integration for the ServiceNow Asset Load, complete the following steps:

1. In Oomnitza, click Configuration> Integrations> Overview.
2. Click Block view
3. Scroll down to the Extended section for asset integrations.
4. Click NEW INTEGRATION.
5. Select the integration in the sidebar.
6. Click ADD.

Integration details overview

More information is provided about the following fields to help you complete the integration:

Installation type

Select Cloud if you want to store credentials in the Oomnitza cloud.

Select Local if you want to store credentials locally. Local extended integrations do not support AWS and OAuth authentication. If you want to sync Oomnitza with vendor applications that require AWS or OAUTH authentication, select Cloud.

Integration preferences

By default, the option Create & Update option is selected. Select this option  when you want to edit records and add new records. If you want to edit records and not add new records, select Update Only. If you only want to add new records, select Create Only.

Integration details

To review or update the integrations details, click Edit .

1. Update the integration name if necessary. 
2. Select an installation type.
3. For integration preferences, select an option.
4. Enter the name of the integration user.

Credential details

If you selected Cloud as the installation type, choose one of the following options:

• Select the credentials that were created for the integration.
• Edit the credentials that were created for the integration.
• Create new credentials

Schedule

By default, data is streamed to Oomnitza once every day.

You can configure the schedule to meet your needs such as changing the interval or changing the time so that the data is streamed when your system isn't busy.

1. Click the Edit .
2. Configure your schedule.
3. Click Update.

Mappings

To map the fields to Oomnitza, click Edit .

You can define rules for your integration by selecting Edit integration on the mapping page. For example, you may only want to run the integration if a certain contact or region exists. See Filtering integration results.  
You can add new fields to your integration by selecting Add new field   on the mapping page. All you need to do is specify the property name. See Creating custom API fields. 

Creating custom mappings

Map ServiceNow fields to Oomnitza fields to get the asset information that you need.

ServiceNow CMDB CI Asset Load

For the ServiceNow CMDB CI Asset Load mapping, it is recommended to follow these steps:

1. Click Smart Mapping.
2. Create a custom mapping for the ServiceNow CMDB CI ID (also acts as the Sys ID). You will require this value when you create workflows. To create a custom mapping, do the following:
   1. Click the down arrow on the ServiceNow CMDB CI ID field that you want to map.
   2. Select Add new Oomnitza assets field.
   3. Change the name of the field to ServiceNow CMDB CI ID.
   4. Click CREATE. 
3. Map and assign a sync key to a unique field, such as the Serial Number.
4. Click UPDATE.

ServiceNow Asset Load

For the ServiceNow Asset Load mapping, it is recommended to follow these steps:

1. Click Smart Mapping.
2. Create a custom mapping for the Internal Sys ID. You will require this value when you create workflows. To create a custom mapping, do the following:
   1. Click the down arrow on the Internal Sys ID field that you want to map.
   2. Select Add new Oomnitza assets field.
   3. Change the name of the field to ServiceNow ALM Asset ID.
   4. Click CREATE. 
3. Create another mapping for the ServiceNow CMDB CI ID.
4. Map and assign a sync key to a unique field, such as the Serial Number.
5. Click UPDATE.

ServiceNow Asset Load Custom Mappings

Asset Tag
Assigned Date
Assigned To
CMDB CI ID
Comments
Company
Cost
Cost Center
Created
Delivery Date
Department
Depreciated Amount
Depreciation
Depreciation Date
Display Name
Disposal Reason
Install Status
Internal Sys ID
Invoice Number
Location
Managed By
Model
Model Category
Owned By
PO Number
Purchase Date
Resale Price
Residual
Residual Date
Serial Number
Stockroom
Substatus
Support Group
Supported By
Sys Class Name
Vendor
Warranty Expiration
Work Notes

ServiceNow CMDB Configuration Item (CI) Asset Load Custom Mappings

Asset
Asset Tag
Assigned
Assigned To
Assignment Group
Attestation Score
Attested
Attested By
Attested Date
Attributes
Business Unit
Can Print ?
Category
Change Control
Checked In
Checked Out
Class Name
Class Path
Comments
Company
Connect: Credentials
Connect: Filters
Connect: Subdomain
Connector Sync Time
Correlation ID
Cost
Cost CC
Cost Center
Created At
Created By
DNS Domain
Delivery Date
Department
Device Name
Discovery Source
Domain Path
Due
Due In
Duplicate Of
Environment
FQDN
Fault Count
First Discovered
GL Account
IP Address
Install Date
Install Status
Invoice Number
Justification
Last Discovered
Lease ID
Life Cycle Stage
Life Cycle Stage Status
Location
MAC Address
Maintenance Schedule
Managed By
Managed By Group
Manufacturer
Mod Count
Model ID
Model Number
Monitor
Operational Status
Order Date
Owned By
PO Number
Purchase Date
Schedule
Serial Number
ServiceNow CMDB CI ID (*and Sys ID)
Short Description
Skip Sync?
Start Date
Subcategory
Support Group
Supported By
Sys Domain
Tags
Unverified
Updated At
Updated By
Vendor
Warranty Expiration

Launching the integration

Your integration is in Draft mode until the required mandatory fields are added. When added, click Launch to activate your integration. 

If you selected Cloud as the installation type when creating the integration, see Running an extended integration

If you selected Local as the installation type when creating the integration, see Running an extended integration locally.

Viewing data ingested by Oomnitza

Viewing ingested asset data

For asset integrations, click Hardware. If the asset integration also ingests software data, click Software.

Viewing ingested user data

For user integrations, click People. If you chose the option to ingest User and SaaS user data, click Software > SaaS, click the SaaS app, and then click the Users tab. 

Related Links

• Running an extended integration
• Troubleshooting integrations
• Mapping extended integrations

Unleash the power of Oomnitza

To get valuable actionable insights that help you manage your assets, learn how to:

• Configure dashboards for your users and software
• Configure custom reports about your users and software
• Create workflows to automate tasks

See Getting started for more information.

Did you know
You can also create workflows for ServiceNow assets.
Creating workflows for ServiceNow assets