JDBC connection with Solarwinds Database to populate ServiceNow CMDB
I am trying to set up a JDBC connection with Solarwinds DB and ServiceNow in order to do that i need two SQL queries to get the Data and most of the attributes like model, serial number, ip, mac address etc.
Can somebody please point me the tables or the SQL queries for each of the devices configured in solarwinds for motinoring:
3. SQL Database
I have successfully connected to solarwinds DB and I am able to fetch windows, linux and ESX servers. I am also getting cisco devices but very few attributes like caption and machinetype. By using machine type i am unable to determine whether it is a router or a switch.
Any help with the table names or the DB queries is much appreciated.
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.