Where can I find the definition for a table in NPM and what is it used for?

I want to know what a table in the NPM is used for. For example the Orion.ContainerStatus table's usage and what data it holds.

Find more posts tagged with

npm

Accepted answers

All comments

yaquaholic

Have a look at their SDK site

solarwinds.github.io/.../Orion.ContainerStatus.html

stuartd

I'm pretty sure there isn't one single file or web page out there that is:

Table Name Use

A.Table.Name Defines a table for x

However, I've found one of the easiest solutions is to fire up SWQL Studio, find the table you want and run a query (right click generate select statement) against it. So in your example:

Gives me:

Still not that helpful, so I start removing letters from my search, which expands out to:

And if I now run a query against just Orion.Container it gives me much more data to begin to understand. In this case, the ContainerID is the DB representation of a group name we have created in our deployment.

Coming full circle we then begin to understand that the table you are interested in is storing the status of a particular group.

The SDK site should have all of these, but the definitions/descriptions are mostly meaningless to me - this one being a point in case.

HTH?

yaquaholic

Or even https://solarwinds.github.io/OrionSDK/2020.2/schema/index.html