Help with Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1453671%22%20slang%3D%22en-US%22%3EHelp%20with%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453671%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20query%20to%20notify%20the%20low%20disk%20space%20on%20servers%20and%20it%20is%20working%20fine.%20But%20I%20want%20to%20exclude%20one%20of%20the%20drives%20i.e%20H%20from%20the%20notification.%20is%20there%20any%20way%20we%20can%20do%20it.%20I%20am%20using%20the%20below%20query.%20Any%20help%20in%20this%20will%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EPerf%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20ObjectName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22LogicalDisk%22%3C%2FSPAN%3E%20%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20CounterName%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22Free%20Megabytes%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20FreeSpace%20%3D%20avg(CounterValue%2F%3C%2FSPAN%3E%3CSPAN%3E1024%3C%2FSPAN%3E%3CSPAN%3E)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20Computer%2C%20InstanceName%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20FreeSpace%20%26lt%3B%20%3C%2FSPAN%3E%3CSPAN%3E120%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esort%3C%2FSPAN%3E%20%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20FreeSpace%20asc%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1453671%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454269%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695151%22%20target%3D%22_blank%22%3E%40Deepwater_83%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20to%20add%20something%20like%3A%3C%2FP%3E%0A%3CDIV%3E%0A%3CDIV%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20InstanceName%20!%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22H%3A%22%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3EMake%20sure%20that%20you%20filter%20the%20right%20records%20and%20that%20you%20don't%20filter%20a%20valid%20data%20point.%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3EMeir%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@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