Log Analytics Query to Get Specific Disk Letter Space.

Question

Hi,

I am creating an alert rule to:

• Check if the disk space has only 5% or less
• Check if MSSQLSERVER and MSSQLSERVER AGENT is running

For the first one, I'm running this query but it does not show the drives (C:/ D:/ etc)

And for the second one is this. Even if I try to turn off the service it does not alert.