ServiceNow CMDB

ServiceNow Configuration Management Database (CMDB) is a centralized file that functions as a comprehensive data warehouse, organizing information about an IT environment. CMDB clarifies the relationships between hardware, software components, and networks for improved configuration management.

Integration

This integration has been tested against ServiceNow version Vancouver.

ServiceNow Configuration

Scopes allow controlled access to data. ServiceNow platform supports authentication scopes to allow admins to limit access of an OAuth client application to a specific REST API. The Scope needed for this integration is useraccount.

To create the OAuth API endpoint for external clients, an admin role is required.

• Navigate to System OAuth > Application Registry and then click New.

• On the interceptor page, click Create an OAuth API endpoint for external clients and then fill in the form.
  

For OAuth, the 'grant type' will be Password credentials, the 'scope' will be useraccount and the 'token URL' will be https://instance.service-now.com/oauth_token.do.

Create User

We will need to create a user for API access. The prerequisite Role required to create user is “user_admin”.

To create user

• Navigate to All > User Administration > Users.

• Select New

• Set the following fields:

• Time Zone set to “UTC”. This will provide a UTC date in API response

• Date format should be “System(yyyy-MM-dd)”.

• Active checkbox. Ensure this is selected.

• Locked out. Ensure checkbox this is NOT selected.

  • These settings are needed so that the access token for OAuth will be generated

• Web service access only. Ensure this checkbox is selected

• Navigate to the Roles tab below and click Edit to assign role to the user

  

• Search for the ITIL role and assign it to the user. This is needed to get the CMDB data

DataBee Configuration

1. Log into the DataBee console and navigate to the Data tab. Click Add New Data Source

   

2. Search and select ServiceNow CMDB

   

3. Click on API Ingest button

   

4. In the contact information, dialog boxes enter a name for the datasource and owner information

5. In the configuration dialog box, enter the following:

   • Authorization Method: OAuth2

   • Username / Password: Enter the API username/password created earlier.

   • Client Secret: Paste the Client Secret generated earlier

   • Client Key: Paste the Client ID generated earlier

   • Auth URL: https://<instance>.service-now.com/oauth_token.do

   • API URL:  

   • https://<instance>.service-now.com/api/now/table/cmdb_ci

   • https://<instance>.service-now.com/api/now/cmdb/instance/<sys_class_name>/<sys_id>

   • Replace <instance> with your actual instance ID.

   

6. Click Submit