We have a well under-powered version of the database - but I am under the gun to write queries. Our Orion DB - I cannot open.
Start here: Home · solarwinds/OrionSDK Wiki · GitHub
Thank you - this was a good place to start. This is also a great resource!
My DB is stressed with too many demands on its resources. I am trying to write basic report queries but cannot open the database to id the fields. Hence the request for a data dictionary or maybe an ERD!
If your production database is too overloaded to support development, you might want to set up a copy for testing. You can use a trial license of NPM with SQL Express. Take a backup of your production database and restore it to SQL Express.
The problem is scope creep and luckily out of my hands. When the scope is corralled to limited number of users - the hardware brain trust will do what they will do.
Thanks for the input - any idea for the data dictionary?
A lot of it depends on what data you need to pull. A good starting point is the 'Nodes' table (or NodesData). That table has a lot of the basics in there that will get you started. Depending on what data you want to see, you may need to join some other tables with the Nodes table. Your 'NodeID' will typically be your primary key when searching and/or joining table.
bmallon - I have a few queries written off of NODES and NODES data but it would be much easier to have a data dictionary or an ERD diagram which display what other fields are on NODES, what are the foreign keys, indices, etc...
Thank you all for your help!
