Pulling Details of Node from SolarWinds to ServiceNow

Whilst it is easy to directly query the MS SQL database/s, it is advised to utilise the Orion API, which has an extensive entity and verb library.

Further details can be found in the following key locations:

SolarWinds Github - https://github.com/solarwinds

Orion SDK Forum - https://thwack.solarwinds.com/t5/Orion-SDK/ct-p/orion-sdk

SolarWinds Lab on subject - https://www.youtube.com/watch?v=F0R6vUNDQ8o

I video on the use of the API I did - https://www.youtube.com/watch?v=pEbFRBIcXx4&t=34s

Hope this helps.

Orion already has integration into ServiceNow for you want to skip the middle man.

https://support.solarwinds.com/SuccessCenter/s/article/How-to-Integrate-ServiceNow-with-the-Orion-Platform-Video

Thank you m_roberts, will go through the links and let you know the result.

Thank you Neomatrix,

But Im interested in getting Devices details into ServiceNow CMDB.

Thanks,

Rajesh

You said SolarWinds to ServiceNow but your subject says SolarWinds to Nagios. Which were you shooting for?

That;s my bad mrxinu. Updated

Which is the source of truth? SolarWinds or ServiceNow?

Source is SolarWInds

It sounds like you need to work with the ServiceNow API more than the SolarWinds API. On the SolarWinds side you just need to keep track of what nodes existed previously and what nodes exist on the next check. When there are more, you have to do the work in ServiceNow.

What kind of development are you prepared to do? What languages are you savvy with?

mrxinu  : Yep I do know that we have ServiceNow API which we can play around.

But i'm interestead to get the node properties with some SQL query ( which I can automate it to run every 12or 24hours to generate the csv and them Import it to ServiceNow CMDB. )

If I get query will be few more tuning to it by adding schemas and then my next steps I would like to do is:

1. Need to create a jdbc data source in ServiceNow and use credentialed access to source data from SolarWinds. 

2. Next I will need to identify the database table to source the data from nodes, alerts, containers, etc.

Then I will have create a transform map to relate this SolarWinds data to ServiceNow which can be input to the cmdb This can be automated using a scheduled job

Thanks,

Raj Esh