Feb 02 2018
11:29 AM
- last edited on
Apr 07 2022
04:53 PM
by
TechCommunityAP
Feb 02 2018
11:29 AM
- last edited on
Apr 07 2022
04:53 PM
by
TechCommunityAP
Hi, i'm trying to create a dashboard with a list that gets its data from a Join query, but I can't find any way to add a column to the List on the dashboard, since I need 3 columns; One for the computer name, one for CPU and one for RAM
is there any way?
Feb 05 2018 01:50 AM
Hi Dante,
Can you be more specific. The query language has functions like join and union. They can be used to merge the results of two queries.
Feb 07 2018 06:10 AM
Hi,
Thank you for your reply.
Yes, let me explain:
I'm using this query:
Perf
|
where CounterName == "% Committed Bytes In Use" and TimeGenerated > ago(30d)
|
summarize avgRAM = avg(CounterValue) by Computer
|
where avgRAM < 50 |
join (Perf
|
where CounterName == "% Processor Time" and TimeGenerated > ago(30d)
|
summarize avgCPU = avg(CounterValue) by Computer
|
where avgCPU < 50) on Computer
|
project-away Computer1
to create a dashboard. If I use the query myself without a dashboard, I can see both columns (first picture). However, when I create a dashboard and use the same query, I can only see the first column.... (second picture)
Feb 07 2018 06:15 AM
Hi
Yes now I understand. Unfortunately dashboards does not support displaying more than one summarized value. My advise would be to create two dashboards side by side - one displaying the first summarized value and another displaying the second summarized value.