Exporting Rumble to ServiceNow CMDB
Rumble now has a JSON export API designed to support exporting Rumble data into ServiceNow’s Configuration Management Database (CMDB). Rumble asset data is exported in ServiceNow-ready formats, for import as CMDB Configuration Items (CIs).
A basic import can be performed using ServiceNow IntegrationHub ETL. ETL allows you to create transform maps via point-and-click operations without programming. It processes incoming data via the ServiceNow Robust Transform Engine (RTE), and ensures that the Identification and Reconciliation Engine (IRE) is used to integrate the data into your existing ServiceNow CMDB instance.
For more advanced imports, you can of course develop transform maps manually, and import the data that way.
This document will briefly cover the process of setting up ServiceNow IntegrationHub ETL to fetch data from Rumble via REST API.
Because ServiceNow is so customizable, it is impossible to make integration a “one click” process. At a minimum, you will need to spend time deciding which CI classes you want to use, and how you want to map data to their fields.
You will definitely want to test the import process in a development instance of ServiceNow. You can obtain one by signing up for ServiceNow’s developer program at developer.servicenow.com.
IntegrationHub ETL may need to be installed from the ServiceNow store.
ServiceNow ITOM is licensed based on the number of CIs in your CMDB, regardless of whether they were discovered by ServiceNow Discovery or by another tool such as Rumble. You will need a subscription to ITOM Visibility or ITOM Discovery, with enough Subscription Units to cover the number of CIs in your organization.
To set up an ETL import, you’ll need to:
- Install IntegrationHub ETL
- Set up Rumble as a discovery source
- Set up credentials
- Set up a connection and credential alias
- Set up a connection
- Set up a data source
- Create a new data flow action
- Set up an ETL import
For a development ServiceNow instance, you will need to install the IntegrationHub ETL application:
- Go to System Applications > All Available Applications > All.
- Search for IntegrationHub ETL by name, and wait until it appears.
- Click Install on the info page, then Install again on the confirmation.
ServiceNow will automatically install Integration Commons for CMDB and Integration Studio API as well. Once installation is complete, you will need to shift-reload the browser page before InstallationHub ETL shows up in the left navigator.
The first step is to set up a discovery source to let you flag CIs which were added from Rumble data.
Navigate to System Definition > Choice Lists in ServiceNow. Search for the table
cmdb_ci, and the element
discovery_source. Assuming there isn’t one for Rumble, click New to create a new choice.
In the Table search box, enter
[cmdb_ci] (including the square brackets), and click Configuration Item [cmdb_ci]. The remaining required values are:
Click Submit to create the new choice.
You will need a Rumble organization API key. These are set up via the Organizations page in Rumble. You can click on an organization, scroll down to the bottom of the page, and generate a new API key or copy an existing one. The API key looks like a string of hexadecimal digits.
Once you have your API key, navigate to Connections & Credentials > Credentials in ServiceNow, click New, and select API Key as the type of credential to create.
Give the new credential a sensible name like ‘Rumble export API key’, paste in the hex string as the API Key value, then click Submit.
Next, you will want to set up a connection and credential alias. To do this, go to Connections & Credentials > Connection & Credential Aliases and click on New. Provide the necessary information:
|Type||Connection & Credential|
The defaults should be OK for the other fields.
Now it’s time to set up the actual HTTP connection based on the credentials and alias you’ve created. Navigate to Connections & Credentials > Connections, click New, and choose to set up an HTTP(S) Connection.
Enter the required field values:
|Name||Rumble Export API|
|Credential (from the earlier step)||Rumble export API key|
|Connection alias (from the previous step)||
Note that the connection alias name will have had spaces and other punctuation replaced with underscores.
Now you should be ready to start setting up a data source for the Rumble data.
Go to System Import Sets > Administration > Data Sources and click New.
Some suitable field values are:
|Name||Rumble JSON export HTTPS|
|Import set table name||
|Path for each row||
Note that the import set table name is required to start with
There shouldn’t be any arrays in the exported data, but you can check the ‘Discard Arrays’ option to be safe.
With the basic info in place, check towards the top right of the form next to the Request action field. Clicking the button to the right of that field will launch the ServiceNow Flow Designer to create a new data flow action.
The flow designer will prompt you to name your new action, so give it a descriptive name like “Fetch Rumble assets”.
Once you confirm the action name and other basic info, you should find yourself looking at an action outline with three steps:
Click on REST step on the left to edit the REST action details.
|Connection||Use Connection Alias|
|Connection Alias||The connection you created earlier|
|Base URL||This will be read from the connection|
Under Headers, you need to click to add a new header. The header name is
Authorization, and for the value you should type in
Bearer followed by a space. You can then drag the lozenge labeled Credential Value from the right side of the screen into the Value box, and it should show up as per the screenshot below:
Note that you can build the resource path using a similar method and the Attachment Name lozenge, but in this case we suggest hard-coding it as it doesn’t need to change for different attachment names.
At this point it’s probably a good idea to use the Test button at the top of the screen to test the action. You can provide a fake value for the attachment name and click Run Test. ServiceNow should (eventually) say:
Your test has finished running. View the action execution details.
To do so, close the dialog and click the Executions button to open the Operation List tab. Click the link to open the most recent test operation into another tab. Under Output Data, make sure you got status_code 200 (HTTP OK) from Rumble. If you get an error in the 400 range, there’s probably an error with the
Authorization header or your API key.
You might optionally want to check the Response Payload Size by twisting the disclosure triangle next to Steps.
If the action is working, close both the Operation tabs to go back to the “Fetch Rumble asset data” action, and click the Publish button.
Now you can close the Flow Designer tab in your browser and go back to setting up the ServiceNow data source.
Back on the data source page, you should now be able to use the ‘Request action’ field to add the request action you just created, and save the data source.
Go to Configuration > IntegrationHub ETL and click New to create a new set of transform maps. The ETL tool leads you through the setup in numbered stages.
In section 1, click on Import Source Data and Provide Basic Details.
|CMDB Application||Rumble importer|
|Data Source||The data source you just defined|
Note that the name is used for transform map names.
Once you’ve filled out the basic information, clock Save, and also Mark as Complete so that ServiceNow will allow you to proceed to step 2.
In section 2, click Preview and Prepared Data. The IntegrationHub ETL tool should load in the first 10 rows of your Rumble data.
At this point, you can proceed with the normal process for importing data via IntegrationHub ETL. You can transform fields, decide which asset types become which classes of CI, and map fields in the normal way. A good introduction to the rest of the process is the ServiceNow Knowledge2020 course “Use IntegrationHub ETL to Import Data”.
ServiceNow supports modeling computers with multiple network cards via the Network Adapter CI class. Unfortunately, the Network Adapter CI requires a name for the network adapter. Rumble has no way to obtain that information, and it differs between OSs and OS versions.
One option is to set a standard name for all Network Adapter CIs. You can then use ETL’s lookup tools or Glide Lookups to search existing computer data by MAC address and avoid duplicates.
Here are some field-by-field notes on the data in Rumble’s ServiceNow export.
Note that some fields can contain multiple values, in which case they are separated with semicolons.
asset_id: This is a universally unique ID (UUID) for the Rumble asset. It will remain the same across Rumble scans, so it can be used as the source native key in ServiceNow.
type: This is the Rumble asset type.
sys_class_name: This is a suggested ServiceNow CI class that might be suitable for the asset. Not all assets will have a
sys_class_namevalue supplied, and you might disagree with some of the suggestions. We hope to improve the suggestions over time.
os_vendor: The vendor responsible for the OS running on the asset.
os: The specific OS product running.
os_version: The version of the OS product, if it could be determined.
manufacturer: The manufacturer or vendor of the primary hardware.
model: The specific product. You will most likely want to use a Glide Lookup or the ETL field mapping features to look up the manufacturer and model, and convert them to references to the manufacturer and product tables.
ip_address: The primary IP address the asset was detected at.
addresses_scope: A list of all of the IP addresses of the asset that were directly detected by scanning.
addresses_extra: Additional IP addresses that we infer the asset could have, but which haven’t been confirmed by direct scan.
mac_address: The primary MAC address for the asset.
mac_manufacturer: The manufacturer assigned to the MAC address, generally the manufacturer of the network hardware.
newest_mac_age: MAC address allocations have dates associated with them. This field has the approximate allocation date of the newest MAC address found associated with the asset. This can be used to provide an approximate age for the asset.
macs: A list of all MAC addresses found for the asset.
mac_vendors: A list of all the MAC vendors found for the asset.
name: For convenience we provide a single-value
namefield, as well as
nameslisting all of the identified names.
last_updated: This is when the asset record in Rumble was last updated. It can be used as an indication of data recency in ServiceNow.