Forum Discussion
Help with Query
I have created a query to notify the low disk space on servers and it is working fine. But I want to exclude one of the drives i.e H from the notification. is there any way we can do it. I am using the below query. Any help in this will be appreciated.
Perf
| where ObjectName == "LogicalDisk" and CounterName == "Free Megabytes"
| summarize FreeSpace = avg(CounterValue/1024) by Computer, InstanceName
| where FreeSpace < 120
| sort by FreeSpace asc
1 Reply
- Meir_Mendelovich
Microsoft
Try to add something like:
| where InstanceName != "H:"Make sure that you filter the right records and that you don't filter a valid data point.Thanks,Meir
