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

NPM Schema

sobvlarwinds2020

I came to know that after tweaking certain SQL parameters we can fetch meaning reports. But the problem i faced was because I was not knowing exact variables schema I required to use trial and error to generate the SQL code.

Where I can get latest up-to date schema of solar-winds SQL table for the product version 2019.4 Also since report writer feature has been discontinued in 2019.4 where can I get library of reports and its equivalent SQL query template?

Find more posts tagged with

Accepted answers

All comments

sturdyerde

A great place to start would be in the Orion SDK board and the Orion SDK repository on GitHub. The GitHub repo includes schema documentation for each version of the Orion platform. See http://solarwinds.github.io/OrionSDK/.

sobvlarwinds2020

Thanks for your reply. I think I already visited the page

http://solarwinds.github.io/OrionSDK/2019.4/schema/Orion.NPM.Interfaces.html

checking schema parameters. But because I am new to working on SQL, I was not able to make full use of same.

whatever standard reports we see in Solar-winds Orion platform these seems to be actual SQL scripts working in back end.

How can I view equivalent SQL code behind these standard reports ? Report writer feature has been discontinued from 2019.4 onward.

dbriden

To see the sql behind a web based report have a look at https://thwack.solarwinds.com/t5/Report-Lab-Documents/Get-the-sql-query-of-web-based-report/tac-p/536660