Forum Discussion

Prince0103's avatar
Prince0103
Copper Contributor
Feb 10, 2020

KQL query to disk space utilization in GB and server uptime

I am looking for KQL query to check Disk space utilization in GB(14h)for every VM hosted on azure in and also looking for KQL query to check server up-time for past 14h.

 

Any help would be appreciated.

 

Thanks in advance !!

Azure Log Analytics
azure monitor

1 Reply

  • CliveWatson's avatar
    CliveWatson
    Former Employee
    Feb 10, 2020

    Prince0103 

     

    For uptime you have the built-in example - its called "Availability Rate" you see it when you open a new Query Tab.  This is for the Agent uptime 

     

    // Availability rate
// Calculate the availability rate of each connected computer
Heartbeat
// bin_at is used to set the time grain to 1 hour, starting exactly 24 hours ago
| summarize heartbeatPerHour = count() by bin_at(TimeGenerated, 1h, ago(24h)), Computer
| extend availablePerHour = iff(heartbeatPerHour > 0, true, false)
| summarize totalAvailableHours = countif(availablePerHour == true) by Computer 
| extend availabilityRate = totalAvailableHours*100.0/24

     

    System Uptime is also a Perf counter - like this (if yuou are collecting this counter)

     

    Perf
| where ObjectName == "System" and CounterName == "System Up Time"
| extend UpTime = CounterValue * 1s
| summarize arg_max(TimeGenerated, *) by Computer
| project Computer, UpTime, TimeGenerated
| sort by Computer asc
 | project Computer, UpTime, TimeGenerated
     

     

    For disk space please start here: https://techcommunity.microsoft.com/t5/azure-log-analytics/help-with-disk-query-in-log-analytics/m-p/160239#M440

     

     

     

Resources