Jan 18 2018
04:06 AM
- last edited on
Apr 07 2022
04:52 PM
by
TechCommunityAP
Jan 18 2018
04:06 AM
- last edited on
Apr 07 2022
04:52 PM
by
TechCommunityAP
Hello guys
I need your help. How can create a query to join a table "ConfigurationChange" and table "Perf" to know the % of CPU with a condition to have the same Publisher.
Thank you for your help
Jan 18 2018 11:32 PM
Jan 19 2018 01:27 AM
Hello.
Thank you for your reply
I want to filter one query that find publisher = "SAP" and see the Percentage of CPU and order by asc. I only can do with join the the table perf that information give the the % of CPU and the table ConfigurationChange that give the publisher "SAP".
One example:
2 - search * | where ObjectName == "Memory" and CounterName == "% Committed Bytes In Use" | summarize UsedMemory = avg(CounterValue) by Computer | sort by UsedMemory desc (this information in insert on the table ConfigurationData)
Jan 19 2018 01:30 AM
Jan 19 2018 12:29 PM
Sure you can join!
Join is a very important and useful and powerful part of the language. See all details here: https://docs.loganalytics.io/docs/Language-Reference/Tabular-operators/join-operator
Thanks,
Meir
Jan 19 2018 12:35 PM