Forum Discussion
Search multiple perf counters
Hi Henrik,
To check if a string contain any of a given list of values, you'd need to a evaluation each value separately, like this:
Perf | where CounterName contains "% Committed"
or CounterName contains "% Used Mem"
or CounterName contains "% Proc" | summarize AggregatedValue = avg(CounterValue) by Computer, CounterName
The only string operator that accepts a list of values is "in". See the full list of string operators here.
Regards,
Noa
There is no Performance counter called % Used Memory in windows..I am also trying to find out how to get the Percentage of Memory used within 12 hours time...slice window of 1 hour .Please let me know if anyone has the query for this
Thanks
R
Noa Kuperberg wrote:Hi Henrik,
To check if a string contain any of a given list of values, you'd need to a evaluation each value separately, like this:
Perf | where CounterName contains "% Committed"
or CounterName contains "% Used Mem"
or CounterName contains "% Proc" | summarize AggregatedValue = avg(CounterValue) by Computer, CounterNameThe only string operator that accepts a list of values is "in". See the full list of string operators https://docs.loganalytics.io/docs/Language-Reference/Scalar-operators/String-operators.
Regards,
Noa
Noa Kuperberg wrote:Hi Henrik,
To check if a string contain any of a given list of values, you'd need to a evaluation each value separately, like this:
Perf | where CounterName contains "% Committed"
or CounterName contains "% Used Mem"
or CounterName contains "% Proc" | summarize AggregatedValue = avg(CounterValue) by Computer, CounterNameThe only string operator that accepts a list of values is "in". See the full list of string operators https://docs.loganalytics.io/docs/Language-Reference/Scalar-operators/String-operators.
Regards,
Noa