Has anyone out there ever used SolarWinds data as an input to the servicenow CMDB?
We are considering utilizing SolarWinds as our initial primary source of data into the servicenow CMDB rather than servicenow Discovery.
We already have SolarWinds set up and polling our Data Centers.
Are there drawbacks to this approach? What are they? Was it a large manual operation to transform SolarWinds data into the CMDB?
For relationship within the servicenow CMDB, what was lost versus utilizing servicenow Discovery?
Thanks for any input.
We do a true up between Orion and SNow a few times a year.
SNow discovery pretty much is junk and most people administrating it don't understand discovery.
I've seen it crash a core switch.
If Orion was used for discovery, then items can be exported/imported into SNow.
Can you please share how do you it today with discovery part and export/import. we want to exercise similar efforts. Did you do any custom sql pull from orion database? Thank you in advance.
Primarily we export CI's from ServiceNow and monitored nodes/objects from Orion and compare the differences. This allows us to do a true up/audit. ServiceNow is the document of record and new CI's are supposed to be created for new items and then workflow pushes a ticket to us to create the item in ServiceNow. I know it is possible to import node data from Orion that was exported in a CSV. The challenge is to associate the relevant data for the CI owner and such....most of that is best handled by the initial CI creation workflow. Whatever discovery process is used, there has to be a way to tied the related information together.
Hi I am looking for a tool that allows Solarwinds data to be exported into ServiceNow does anyone have a script that will do this? or an application that can be used maybe via an ODBC connector? Or even a tool that allows us to pull data out of Solarwinds and auto imports into ServiceNow, say once a week?
If anyone has any ideas please let me know...?
ServiceNow has the ability to connect an external datasource via JDBC and run SQL queries to retrieve data.
Take a look at this:
You would define the Solarwind Orion server as a JDBC datasource, then create the Import Set and corresponding Transform Map. After that, you can schedule the import.
Hi - Yes this is possible.
You will need to create a jdbc data source in SN and use credentialed access to source data from SW. You can also use a mid server.
Next you will need to identify the database table to source the data from nodes, alerts, containers, etc. You can use multiple sources you will need to create a data source for each.
Then you will create a transform map to relate this SW data to SN you can input to the cmdb or staging table to coalesce multiple data points. This can be automated using a scheduled job to run daily, weekly, etc.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.