SWQL for Multiple Component Statistic Values

How would you construct a SWQL to return the statistic value for two different SAM components?

SELECT E0.[Uri], E0.[DisplayName], E0.[Application].[Node].[SysName], E0.[ComponentAlert].[StatisticData],E0.[Application].[Node].[CPULoad] FROM Orion.APM.Component AS E0 WHERE ( E0.[ComponentAlert].[ComponentName] = 'Processor Queue Length' )

And

Find more posts tagged with

Accepted answers

All comments

shuth

Can you do something like:

WHERE E0.[ComponentAlert].[ComponentName] IN ( '% Processor Time' , 'Processor Queue Length' )

mapujece

To retrieve the statistic value for two different SAM components, use a single query with a WHERE IN clause instead of separate queries or a UNION. This method is more efficient and allows you to filter both components: Processor Queue Length and % Processor Time in one go. Just like how regular septic tank maintenance ensures everything runs smoothly and prevents issues down the line, using the right query structure keeps your monitoring accurate and efficient. If you need side-by-side comparison per node, a more advanced join or pivot approach may be necessary.