Forum Discussion
Join two or more tables
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 ...
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:
1 - search * | where Publisher contains "SAP" (this information is insert on the table Perf)
Join
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)
What is the common field that these two tables should be joined on? Computer?