Database model

In my copious spare time (COUGH!) I've been playing with the database modeler utility inside Microsoft SQL Studio, but I'm not having luck getting it to export in any meaningful way.

I opened a ticket a while ago about this and was told that the schema is considered part of SolarWinds intellectual property, and as such (like the specific oids they use) we are free to suss it out ourselves but they (official channels) will not be providing us with the information.

If anyone has anything already created - even the primary tables and their fields/relationships, that would be an awesome thing to post here.

For the SWIS schema (which is more or less a layer on top of the database schema) there are relationships defined between the entity types. You can see these in the API reference documentation (C:\Program Files (x86)\SolarWinds\Orion SDK\Documentation\Schema\3.0\index.html) and in the left pane of SWQL Studio when you expand each entity - these are the "chain link" icons.

For joining Orion.Nodes and Cirrus.Nodes, you can use a query like this:

SELECT o.Caption, c.NodeCaption

FROM Orion.Nodes o

LEFT JOIN Cirrus.Nodes c on o.NodeID=c.CoreNodeID

I'm sorry, if I'm a bit dense here, but I can't see where I would be able to confirm that Orion.Nodes.NodeID is related to Orion.Events.NetObjectID? I can't find it in the Schema or in the left pane of SWQL Studio...

Same goes for your example with Orion.Nodes.NodeID and Cirrus.Nodes.CoreNodeID

The relationships info is stored in SWIS schemas shipped with Orion, which is exposed by the entity Metadata.Relationship.

I'm sure query "SELECT Name, BaseType, SourceType, TargetType, SourcePrimaryKeyNames, SourceForeignKeyNames FROM Metadata.Relationship" will provide you all the info you need (relationship names, Type of relationship, Source and target entity and names of properties which are used to join on).

Honza

When I execute your query, I don't see anyhing in the result that provide the relationship info for the two specific examples I provided.

If you see something that clearly indicates the relationship, I would like to know how to interpret the result, so I can compare with my installation. Because then either our installation has a problem or I'm embarrasingly dense.

The problem is not with your installation or your understanding. The problem is that our schema does not have a relationship defined for these two combinations. Other than this forum thread, there is no documentation of these two connections.

Is this based on a decision not to publish a database model, or is it because not enough people have requested this as a feature?

If it is the latter, and I want to make a feature request, should I put a feature request under each individual product? I don't see a Feature Request forum for Orion SDK.

Your best bet is to go product by product - the development resources to actually address these issues are associated with the individual products, not with the SDK as such.

I have made the following two feature requests for NPM and NCM:

http://thwack.solarwinds.com/ideas/2360

http://thwack.solarwinds.com/ideas/2361

Please vote for both of them, if you ever feel lost when building a new query.