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
