- Print
- DarkLight
ServiceNow Configuration Management Database (CMDB) is a centralized repository that serves as a comprehensive data warehouse, organizing information about an IT environment. The CMDB clarifies the relationships between hardware, software components, and networks, enhancing configuration management. More information can be found at ServiceNow CMDB webpage.
Integration Method: API
Tables: Device Inventory Info (5001), Software Inventory Info (5020)
List of events supported by this integration.
Events | Description |
CMDB CIs | Retrieves data for all classes in the CMDB CI table. |
This integration supports the following versions
ServiceNow Version Tested | ServiceNow version Vancouver |
ServiceNow API version | v2.0 |
Prerequisites
Access to the ServiceNow CMDB Admin Role to create an OAuth API endpoint for external clients.
Access to the DataBee console.
Configuration Overview
Generate API credentials on the ServiceNow console with the required user roles.
Add the ServiceNow data feed integration in the DataBee console with the required API credentials.
DataBee Feed Parameter | ServiceNow Parameter |
Client Key | |
Client Secret | |
Username | |
Password | |
TOKEN URL :<instance> | |
API URL :<instance> |
ServiceNow Configuration
The scope is a mechanism to let an application request limited access to a user’s data. ServiceNow platform supports authentication scopes to allow admins to limit access of an OAuth client application to a specific REST API.
Create OAuth client application
Get the servicenow instance from the URL as highlighted below.
Navigate to All
In the search bar, enter System OAuth.
Navigate to System OAuth > Application Registry.
Click on the New button.
On the Interceptor page, click Create an OAuth API endpoint for external clients.
Fill in the required details in the form:
Name: Enter a unique name for OAuth client application.
Client ID: Automatically generated by the ServiceNow OAuth server.
Client Secret: Enter Client secret for the Oauth application or leave empty for auto generation
Copy the Client ID and Client Secret for later use.
Click on the Submit button.
Name | Unique Name that identifies the application |
Client ID | This will be auto generated by the instance: To be provided to DataBee. |
Client Secret | This will be auto generated by the instance Or Can Entered: To be provided to DataBee. |
Refresh Token Lifespan | 8,640,000 seconds (100 days) & can be increased |
Access Token Lifespan | 1800 seconds (30 Minutes) & can be increased |
Create User
Navigate to All,
In the search bar, enter User Administration.
Navigate to User Administration > Users.
Click on the New button. The Create User form window will appear.
Fill in the required fields to create a user:
User ID: Enter a unique username.
First Name: Enter the user's first name.
Last Name: Enter the user's last name.
Time Zone: Set to GMT/UTC to ensure the API response includes GMT/UTC dates.
Date Format: Set to System (yyyy-MM-dd).
Active: Ensure the checkbox is selected.
Locked Out: Ensure the checkbox is not selected.
The user must be active and not locked out to allow the instance to generate an access token for OAuth.
Copy the User ID and Password for later use.
Click the Submit button.
Search username for the “User ID” created in the previous step and click on it.
Click on the Set Password button.
Click on the Generate button and copy the password for later use.
Click on the Save Password button.
Assign roles to user
Go to Roles tab and click on Edit to assign roles to user.
In the search bar:
Enter "ITIL" and click Add.
Click the Save button.
DataBee Configuration
Use the saved client secret and key to configure DataBee. Detailed setup documentation can be found at https://docs.databee.buzz/docs/api-ingest
Login to the DataBee UI, navigate to Data > Data Feeds and click the Add New Data Feed button
Search for Servicenow CMDB and select it.
Click on the API Ingest button.
Enter basic contact information in the contact form and click on the Next button.
In the configuration page, enter the following:
API Base URL: Replace <instance> with your ServiceNow Instance.
Authorization Method: OAuth2
Username: Paste the User ID.
Password: Paste the Password .
Client Key: Paste the Client ID generated earlier in the ServiceNow Platform.
Client Secret: Paste the Client Secret generated earlier in the ServiceNow Platform.
Token URL: Replace <instance> with your ServiceNow Instance.
Select the CMDB tables or leave it blank to retrieve all available CMDB tables.
Click on the Submit button.
Troubleshooting Tips
Ensure the client key, client secret, instance, username and password are pasted correctly. Since you cannot view the client key and secret after the 1st time, re-create the creds, paste it on a text editor to ensure no spaces or unexpected characters are included and reconfigure the DataBee feed
Make sure the required user role is assigned.