Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Pull data from Service CMDB to compare with SolarWinds report

Hi,

I am planning to build Python script to get data from SolarWinds reports and compare the data from ServiceNow CMDB. This is to check all database nodes are being monitored in SolarWinds.

Is there a sample script for that?

Find more posts tagged with

Comments

jm_sysadmin

Start here: GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.
and since you want Python: GitHub - solarwinds/orionsdk-python: Python client for interacting with the SolarWinds Orion API
And look at the queries here to give you a start: (+) Custom Queries - The Orion Platform - THWACK (solarwinds.com)

Here are some that I added for Service Now import a while ago

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2986

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2987

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2986

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2985

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2984

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/2983

k_bolt

Hi - I'm about to try working on something similar but with ManageEngine's CMDB. Basically my though process is to pull all the relevant IP addresses from both APIs, populate two lists in Python and then do a comparison there. Utlimately, I'm hoping to get a diff of the two and then do the necessary logic to make sure both databases are syncronized.

I'm going with IP addresses since once those are in then each application can do their necessary scans to pull data.

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches