Hello Experts,
We are looking to pull the details of nodes using JDBC or Rest API's and send it to ServiceNow. Do we have any solution available to get this done?
Thanks,
Rajesh
SolarWinds doesn't publish an ERD (database documentation) because they don't support direct access of the database. So your only alternative is to get into the database and start poking around. I would start with the views because they a) give you immediate access to useful information, and b) offer some insight into where tables are and how they're related.
For the items you mentioned, here are some things to get you started:
If you get into it and have some specific questions about where things are you could post in the report lab and I could help you write some queries to get you going.
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.
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
Raj Esh
