cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Document the Database Model for the tables exposed through SWIS

Document the Database Model for the tables exposed through SWIS

It takes a lot of guess work to use the Orion SDK to extract, update, and delete information about the nodes in NPM du to the fact that nowhere near all the relationships are obvious.

As an example, when you want to query for Events you need to guess that Orion.Nodes.NodeID and Orion.Events.NetObjectID are related.

Documenting the Database Model and publishing it, for instance in the Orion SDK,  would take the guess work out for your customers, minimize the risk of updating the wrong objects or relying on wrong information, and open up for more integration with internally developed systems.

Also see my question, http://thwack.solarwinds.com/message/203467

2 Comments

SWIS schema is a bookmark of mine- it's included in the SDK- are you referring to a schema or mapping?

Level 11

I'm referring to the relationship between the tables, like mentioned above and in the linked question.

If you want to make a query involving two tables, the relationship is not documented

Sent from Mailbox for iPhone

On Wed, Dec 11, 2013 at 2:46 AM, bluefunelemental