Creating an extended integration for ServiceNow assets

Let Oomnitza be your single source of truth!

You'll get complete visibility of your assets as data from ServiceNow is automatically transformed into consumable information and actionable insights.

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
• Configurable workflows that you can easily create to automate tasks such as:
  • Getting, creating, and updating assets in ServiceNow.
  • Getting SaaS user roles and last login date.
  • Deactivating users in ServiceNow.

Navigation

Setting your ServiceNow subdomain as a global variable

Adding the credentials

Creating the integration

Creating custom mappings

Creating workflows

Creating asset workflows with the API block

CMDB computer
Custom hardware attributes
Delete user
Search asset by serial number
Table API - POST
Table API - PATCH

Creating Saas user workflows

User role

Before you start

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

ServiceNow uses OAuth2.0 authentication. A client id and a secret are required to access the service. You must follow the steps to create an endpoint and OAuth client application that generates a client id and secret, as documented in the ServiceNow API documentation.

Setting your ServiceNow subdomain as a global variable

To save time when you create workflows, set your subdomain as a global variable:

1. From the menu, click Settings.
2. Click Global Settings.
3. Click Add new variable (+).
4. Add the ServiceNow.Subdomain variable and its value. The value is the name of your ServiceNow subdomain. If your ServiceNow URL is https://mycompany.service-now.comyour subdomain would be: mycompany.
5. Save your changes.

Adding the credentials

To stream ServiceNow user data into Oomnitza, complete the following steps:

1. Click Settings > Credentials, and then click Add new credential (+).
2. Add the information details.
3. Click the AUTHORIZATION tab.
4. Select OAuth 2.0 as the authorization type.
5. From the SaaS list, select ServiceNow.ServiceNow OAuth 2.0.
6. Enter your ServiceNow Subdomain. If your ServiceNow URL is https://mycompany.service-now.comyour subdomain would be: mycompany.
7. Enter your Client ID and Client Secret. 
8. Authenticate the connection.
9. Click CREATE. 

Next

You use the credentials that you added to create and customize your ServiceNow integrations with Oomnitza.

Creating the integration

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

1. In Oomnitza, click Settings > Integrations.
2. Click Integrations List View .
3. On the Integrations page, scroll down to the Extended section for Assets.
4. Click NEW INTEGRATION.
5. In the New Asset Integration sidebar, click ServiceNow.
6. To integrate Oomnitza with the ServiceNow Asset Load, click APPLY and then click NEXT twice.

On the connect page, complete the following steps to connect the integration:

1. Enter a descriptive name for the integration such as ServiceNow Assets. This name will be displayed on the Integrations page once the setup is complete.
2. Select Cloud as the installation type.
3. From the Credentials list, select the credentials that you added in Adding the credentials.
4. From the Integration Preferences list, select Create & Update. 
5. Enter the name of the user of the integration.
6. Enter your Subdomain. If your ServiceNow URL is https://mycompany.service-now.comyour subdomain would be: mycompany.
7. Click Next.

Creating custom mappings

Map ServiceNow fields to Oomnitza fields to get the asset information that you need. For the field mapping, it is recommended to follow these steps:

1. Click Smart Mapping.
2. You have the option to create custom mappings to map any other field that you want to add to Oomnitza. To create an optional custom mapping, do the following:
   1. Click the down arrow on the field that you want to map.
   2. Select Add new Oomnitza assets field.
   3. Change the name of the field.
   4. Click CREATE. 
3. Map and assign a sync key to a unique field, such as the Serial Number.
4. Click NEXT.

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

 Learn more about mapping

When you've completed mapping ServiceNow fields to Oomnitza fields, click NEXT.   

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. Configure your schedule.
2. Click FINISH.

Result

A new tile is created for the integration on the Integrations page. 

What to do next

If you want to see what information is collected now, click the tile on the Integrations page and click RUN NOW.

If you want to change the integration settings, you can click a navigation link on the page, such as 4 Mappings, and edit the settings.

 

Tip
To view the information that is collected about your mobile assets, click Assets. 

Creating workflows

Creating asset workflows with the API block

To reduce your workload and automate complex and repetitive tasks, you can create workflows with the API block by following the steps in Creating asset workflows with the API block. To locate the available presets, enter ServiceNow in the Select Preset search field. Select your preset of choice and for every preset enter the following information in the Configure section:

1. Your ServiceNow Credentials that you created in Adding the credentials.
2. Your Subdomain should be derived from the variable created in Setting your ServiceNow Subdomain as a global variable or entered manually. 

For information on the specific requirements for each preset, click one of the links below:

CMDB computer
Custom hardware attributes
Delete user
Search asset by serial number
Table API - POST
Table API - PATCH

Using the ServiceNow CMDB computer preset

This ServiceNow CMDB computer preset allows you to get asset information from the CMDB (Configuration Management Database) CI (Configuration Item) table in ServiceNow. This API requires the user have the ITIL role. When constructing a workflow that uses this preset, the following steps are required:

1. In the API block window, enter the CMDB CI ID of the asset you want to retrieve.
2. Click the Advanced Mode button located in the upper right of the window.
3. Select the Response tab.
4. Enter the response values you wish to store back into Oomnitza in the Response field. The below captures the Operating System from the asset details.

   {% set rr = response['result'] %}{% if rr %}{% set cc = rr[0] %}{% if cc.get('os') %}{% if cc['os'] is mapping %}{{ cc['os'].get('display_value') }}{% else %}{{ cc['os'] }}{% endif %}{% else %}{{ '' }}{% endif %}{% else %}{{ '' }}{% endif %} 

   For information on creating your own Jinja statement, see Importing and Using Libraries with Jinja2.
5. Map the Response field to an Oomnitza field, such as Operating System.

For additional information about the ServiceNow API see ServiceNow - CMDB Instance API or ServiceNow - Table API.

Using the ServiceNow custom hardware attributes preset

This ServiceNow custom hardware attributes preset allows you to get asset information relating to the hardware table in ServiceNow. When constructing a workflow that uses this preset, the CMDB CI ID is required. You can customize the API response by following the steps in Using the ServiceNow CMDB computer preset.

For additional information about the ServiceNow API see ServiceNow - Table API or ServiceNow - Asset Management Table List.

Using the ServiceNow delete user preset

This ServiceNow delete user preset allows you to delete a user from ServiceNow. When constructing a workflow that uses this preset, the user external id is required. To update the user id, complete the following steps:

1. Click the Advanced Mode button located in the upper right of the window.
2. In the Information tab, replace the variable {{user_external_id} in the URL field with the user id. 

For additional information about the ServiceNow API see ServiceNow - Delete table API.

Tip: You can use this preset in conjunction with the ServiceNow User Role preset. You can use the ServiceNow delete user preset to delete the accounts that were found inactive after running the ServiceNow User Role preset.

Using the ServiceNow search asset by serial number preset

This ServiceNow search asset by serial number preset allows you to retrieve information from the asset table in ServiceNow. When constructing a workflow that uses this preset, the Serial Number is required.

For additional information about the ServiceNow API see ServiceNow - Table API or ServiceNow - Asset Management Table List.

Using the ServiceNow table API - post preset

This ServiceNow table API - post preset allows you to insert a record in an asset table in ServiceNow. When constructing a workflow that uses this preset, the following steps are required:

1. In the API block window, enter the TableName of the record to update.
2. Click the Advanced Mode button located in the upper right of the window.
3. Select the Body tab. Enter the fields that you wish to update in proper JSON format, for example:
   

   {
        "asset_tag": "{{barcode}}",
       "po_number": "{{po_number}}",
       "owned_by": "{{assigned_to}}",
       "cost_center": "{{department}}",
       "serial_number": "{{serial_number}}",
       "purchase_date": "{{purchase_date}}",
       "comments": "{{notes}}",
       "cost": {{purchase_price}}
   }    

4. Select the curly brackets to the right of the window to update or add additional fields.
5. Select the Response tab.
6. Map the response values you wish to store back into Oomnitza in the Response field. The below captures the display value from the newly created asset. 

   {{response["result"]["sys_id"]["display_value"]}}

   For information on creating your own Jinja statement, see Importing and Using Libraries with Jinja2.
7. Map the Response field to an Oomnitza field, such as Service Now Device Name.

Using the ServiceNow table API - patch preset

This ServiceNow table API - patch preset allows you to update a record in an asset table in ServiceNow. When constructing a workflow that uses this preset, the TableName and SysId of the record to update is required. You can customize the API response by following the steps in Using the ServiceNow table API - post preset.

For additional information about the ServiceNow API see ServiceNow - Patch table or ServiceNow - Asset Management Table List.

Creating Saas user workflows

You can create the SaaS User workflow by following the steps in Creating Saas user workflows. To locate the available presets, enter ServiceNow in the Select Preset search field. The ServiceNow SaaS User workflow block comes with one available preset, the ServiceNow User Role preset.

ServiceNow User Role preset

The ServiceNow User Role preset enables you to read a SaaS user’s role and last login time. When you select this preset, enter the following details in the Configure section:

• Your ServiceNow Credentials that you created in Adding the credentials.
• Your Subdomain should be derived from the variable created in Setting your ServiceNow Subdomain as a global variable or entered manually. 
  

For additional information about the ServiceNow API see ServiceNow - Users API.

For further information on workflows see:
 Understanding workflows
 Workflow block overview

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.