I am trying to write the SWQL for several widgets but struggling with what fields store what values and what those values mean.
For example, I need a widget that shows the total number of CPUs we are forecasting capacity on.
I assume this is a component so I am including the component ID. For there I have included ComponentType where = 9. However, this is just a guess.
SELECT TOP 10 n.ComponentID,n.ComponentType FROM Orion.APM.Component n WHERE (ComponentType = 9)
The widget would then show the total using a KPI widget.
Where can I find a catalog of which fields hold what values and what those values mean?
This is just one of 44 widgets I need to create.