Solarwind Integration

[_bhishek]

Hello All,

I need to integrate with SolarWinds. I am not using Discovery module and There is no plan for now to use Discovery. As i can see for Service graph connector Plugin 'Discovery ' is prerequisite. I am currently using Flexera to import other devices. Now i need to import network devices information from SolarWinds. Could you please help me with the ways with which i can integrate with Solar winds. If you have any suggestions/documents to achieve this, that would be really helpful.

Thanks in Advance.

[Rahul Priyadars]

We have done this 4 years back when SW SG connector was not even in existence using JDBC Query from Service Now Data Source.

(1) Request SW Data base details from DBA Team

(2) Request SW Data base read Only User for reading tables

(3) Install Mid Server and Check Connectivity with SW Data base (Port 1433 for SQL Server and 1521 for Oracle)

(4) Create JDBC data source for your data of Interest with Query

(5) Pull SW CI data into Staging Table

(6) Write Transform MAP and Push Data into CMDB Table.

 For ur reference

Regards

RP

[Riya Verma]

Hi @_bhishek ,

Hope you are doing great.

To import network devices information from SolarWinds into ServiceNow, I would recommend the following steps:

1. SolarWinds provides a REST API that allows you to retrieve data from their system. You can leverage this API to fetch network devices information and import it into ServiceNow. 

2. ServiceNow allows you to perform scripted data imports using JavaScript. You can create a script that utilizes the SolarWinds REST API to fetch network devices information and map it to the appropriate ServiceNow tables and fields. By scheduling this script to run at regular intervals, you can keep the network device information in ServiceNow up to date

// Define the REST API endpoint for SolarWinds network devices
var solarWindsApiUrl = 'https://solarwinds-api-url/network-devices';

// Make a REST API call to retrieve network devices information
var response = gs.restGet(solarWindsApiUrl);
var responseBody = JSON.parse(response.body);

// Loop through the retrieved network devices and import them into ServiceNow
for (var i = 0; i < responseBody.length; i++) {
  var device = responseBody[i];

  // Create a new record in the ServiceNow table for network devices
  var networkDevice = new GlideRecord('network_device_table');
  networkDevice.initialize();
  
  // Map the fields from SolarWinds to ServiceNow
  networkDevice.name = device.name;
  networkDevice.ip_address = device.ip;
  networkDevice.status = device.status;
  // ... map other fields as per your requirements

  // Insert or update the network device record in ServiceNow
  networkDevice.insertOrUpdate();
}

[Eric Smith]

+thumb:up for  Riya and Rahul's answers. i'd add that there's also the possibility of using a 3rd party tool (like zigiops), too. not sure if you're planning on exploring that as a possible solution to your use case. 

[DanielCordick]

Hey _bhishek

To complete the you should request the necessary details to access the SolarWinds database. This includes information such as the server name, credentials, and any specific requirements for accessing the database.

1. It should be a read-only user account specifically for reading tables in the SolarWinds database. This user account should have appropriate permissions to fetch the required data without making any modifications.

2. Install a Mid Server, which acts as a bridge between ServiceNow and the SolarWinds database. Ensure that the Mid Server is properly configured and that it can establish a connection with the SolarWinds database. For SQL Server for example, use Port 1433, 

3. Create a JDBC data source in ServiceNow to establish a connection with the SolarWinds database. Set up the data source using the provided details, including the server name, credentials, and the appropriate port for the database type.

4. Define a query within the JDBC data source to specify the specific data of interest. This query should retrieve the necessary information from the SolarWinds database tables.

5. Pull the SolarWinds CI (Configuration Item) data into a staging table in ServiceNow using the configured JDBC data source and the defined query. This step involves executing the query and extracting the relevant data into a temporary table.

6. Write a Transform MAP to map the extracted data from the staging table to the appropriate fields in the CMDB (Configuration Management Database) table. This mapping ensures that the data is correctly transformed and aligned with the CMDB structure.

7. Push the transformed data from the staging table into the CMDB table. 
   
   The steps I listed above will point you in the correct direction for this integration

If my response helped in anyway, Please mark my answer helpful or correct