You can use the SWQL Studio tool that comes with the sdk to browse the data model.
For current stats look at
For historical statistics look at
For C# development take a look at the VB.Net sample that is part of the SDK.
Thank you, the SWQL Studio is a little better for browsing than the documentation, but still is like learning a language by reading an encyclopedia. Is there anything anywhere that assigns a brief description to all of the tables? Like what precisely is in Orion.NodesWebCommunityStrings, for example?
Let's say I use Application Monitor to run custom SQL script that returns every minute the count of some business domain activity, such as "Documents Uploaded". Where would I find the aggregate values for this value for a day or for a month?
The examples you provide suggest that the historical statistics are only available for certain pre-defined measures.
I agree the documentation is scarce. We are working on improving the documentation of the data model.
As far as APM is concerned, you would find that data in the Orion.APM.PortEvidence entity.
The ID column will be the ID of the component. You can find the ID by looking at the Orion.APM.Component entity which contains the list of components that your application monitors are using.