Help with Query

Copper Contributor

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

@Deepwater_83,

 

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