Governance

What is the uptime for my AOS servers:

// Replace start_time and end_time with appropriate values 
let start_time=startofmonth(now());
let end_time= now();//endofmonth(now());
let instance = 'https://[instancenamehere].operations.dynamics.com/';
AppPerformanceCounters
| where TimeGenerated > start_time and TimeGenerated < end_time
| where AppRoleName == instance
| summarize heartbeat_per_minute=count() by bin_at(TimeGenerated, 1m, start_time), AppRoleInstance
| extend available_per_minute=iff(heartbeat_per_minute>0, true, false)
| summarize Available_Minutes=countif(available_per_minute==true) by AppRoleInstance
| extend Total_Minutes=round((end_time-start_time)/1m)
| extend Availability=Available_Minutes*100/Total_Minutes
| order by Availability