Forum Discussion
Help me with these queries
Hi all.
I'm a complete newbie to OMS.
I've been handled the task to create a dashboard that gets the CPU and RAM usage, returns the average and marks the servers that are overpowered (less than 1...
For Computers you can create a group of the computer you need and make as function which can help you in any queries
For Eg:
To create a group for Computer
Heartbeat | distinct Computer | where Computer contains "domain.com"
Perf
| where Computer in (domaincomputers)
| where Computer in (domaincomputers)
| where CounterName contains "% Committed"
or CounterName contains "% Used Mem"
or CounterName contains "% Proc"
| summarize AggregatedValue = avg(CounterValue) by Computer, CounterName
or CounterName contains "% Used Mem"
or CounterName contains "% Proc"
| summarize AggregatedValue = avg(CounterValue) by Computer, CounterName
where "domaincomputers" is a function created for group of computer. So it will give performance details of only those computer which are in domaincomputers