This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

What is the ComponentType value for CPU?

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.