The Orion SWIS Schema documentation has been updated for the Orion 2019.2 release. The documentation has a new look and feel, and it captures some additional details. Check it out here:
SolarWinds Information Service schema | Orion SDK Schemas
dan jagnow - it's looking a lot better than before but got a couple of questions/issues:
1) Any schema/documentation versioning for previous versions of Orion? Not everyone can upgrade to the latest version straight away and I would like to see what is specific to my version instead of the latest & greatest. A dropdown picker or something along the lines to select which version I want to look at would be great.
2) The schema is missing the pre-built relationships to other tables. Maybe this is no longer the case in 2019.2, but in previous SDK versions there were links and references to other tables with already existing relationships. (SELECT n.Caption, n.CustomProperties.City from Orion.Nodes n for example). It is now definitely a lot harder to understand the relationships between the tables without having to pull up SSMS to view foreign keys between tables and translate them over to SWQL. (Granted SWQL Studio still has the relationships but I don't often have access to a windows machine.)
getting 404 errors for some items, maybe 30% return 404
http://solarwinds.github.io/OrionSDK/schema/Orion.Netflow.AutonomousSystems.html
http://solarwinds.github.io/OrionSDK/schema/Orion.Netflow.CBQoSTop.html
There is a casing problem with some of the files. If you capitalize the 'f' in "Netflow", you can see the updated documentation:
http://solarwinds.github.io/OrionSDK/schema/Orion.NetFlow.cbQoSConfigurationDetails.html
I'll see if I can get a fix in place for that.
I will see if I can arrange to have multiple versions of the schema documentation available, and I will investigate what happened with the entity relationships.
This looks amazing!
There is now an index page that allows you to select between the most recent two versions of the schema:
SolarWinds Information Service v3.0 Schema Documentation Index
Entity relationship information is also available again now.
dan jagnow Thanks - looks great!
I believe all the URL-casing problems have been resolved now. Let me know if you find any remaining problems.