Forum Discussion

Brass Contributor

Jan 15, 2018

Solved

Search multiple perf counters

Hi all, I'm trying to learn the language and I want to search multiple perf counters on all connected computers, but I don't understand how. for example: Perf | where (CounterName == "% Com...

azure monitor

Query Language

Noa Kuperberg
Jan 15, 2018
Hey Dante,

Try this query, it shows a number of perf counters, and the average calculated per computer and counter name. The results show the counter name in a separate column.

Is this what you were looking for?

Noa Kuperberg

Microsoft

Jan 15, 2018

Hey Dante,

Try this query, it shows a number of perf counters, and the average calculated per computer and counter name. The results show the counter name in a separate column.

Is this what you were looking for?

Dante Nahuel Ciai

Brass Contributor

Jan 15, 2018

I did a bit of research and I found I can do that with a Join, am I correct? although Im not sure how it works (language side)

Noa Kuperberg
Microsoft
Jan 16, 2018
Yes, you can do it this way.

Note that I used join kind "fullouter" to includes all records, while the default join behavior is to show only records that match and exists on both left and right tables.
- Dante Nahuel Ciai
  Brass Contributor
  Jan 16, 2018
  Thank you for all your help.
  
  What is the project-away cmlet?
  
  Thank you!
  - Noa Kuperberg
    Microsoft
    Jan 17, 2018
    project-away actually excludes field from the results. After join, fields that have the same name in both table (such as the field you join on) are shown as "Fieldname" and "Fieldname1". If you want remove one of them from the result set, project-away is the easiest way.