Select Page

Kusto queries that work for me

Azure Resource Graph explorer is awesome.

Here’s my running list of useful queries.

Resources, by name, subscription name, resource group and location. Switch out the “where” for the resource type. e.g. microsoft.compute/virtualmachines

Resources

| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘Microsoft.network/loadbalancers’

| project name, SubName, resourceGroup, location


Linux machines, including appliance MarketPlace identifiers (i.e. CentOS, SLES, RHEL)

Resources

| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘Microsoft.compute/virtualmachines’

| where properties.storageProfile.osDisk.osType =~ ‘Linux’

| project name, SubName, resourceGroup, location, properties.storageProfile.imageReference.offer

COVID week 36 of lockdown – Nov 16 – Nov 22

Weekend – 200k cases per day; holiday travel is surging.

Weekly data from The Seattle Times. That positive test rate at >10% – ouch.

Friday – COVID tests spiking at 20% positive in King County. Trump Jr has COVID. Testing before Thanksgiving leads to huge lines.

UK cases may have plateaued; here come the hospitalisations and then the deaths. Compare with Monday.

image

Thursday – positive tests stop Brexit negotiations. “Don’t travel for Thanksgiving” – which is being widely ignored.

Wednesday – 250k deaths in the US. That’s 4 Vietnam wars.

Tuesday – “Trump administration has checked out”, US COVID cases continue to accelerate.

Monday – talking with friends about the last 36 weeks about “lockdown”: no school (all from home), no work (all from home), seen friends twice (socially distanced, wearing masks, outside), been outside the town a handful of times (to collect flour and visit Orcas Island for some isolated time away). This has not been normal, it’s not been with people. Our bubble of four has has had near zero contact with anyone else.

Today the talk has been around vaccines. A second encouraging report. UK numbers look dreadful.

image

The Guardian The Seattle Times
16 Nov here here
17 Nov here here
18 Nov here here
19 Nov here here
20 Nov here here
21 Nov here here
22 Nov here here

https://www.theguardian.com/world/series/coronavirus-live

COVID week 35 of lockdown – Nov 9 – Nov 15

Weekend – 2142 cases in WA yesterday; way about the March/July peaks. Positive test rate is heading to 5.7% and above. 184k new cases in the US on Friday. Europe-wide lockdowns are returning. Trump says “vaccine ready, except for New York”. Five more months of “severe” restrictions. WA heading back to tighter lockdown.

The Seattle Times has the weekly graph of State-wide data. It’s not looking good. 2000+ cases and more seem to be on the cards. This is heading into Thanksgiving.

Friday – Gov Inslee urges WA residents to not travel for Thanksgiving. This is likely to be the next super-spreader holiday weekend. This is a cool visualisation from GA Tech.  I worry it’s got “yellow, so it’s safe”.. 150k cases in the US yesterday. That’s a run rate of 1M per week.

image

Thursday – those UK curves. Ouch. Graphs from The Guardian. Cases peaked, hospitals filling, deaths following along behind.

image

Wednesday – 1 million cases in Texas, 1 million new US cases in the last nine days. On track for 1M+ cases per week – with the associated hospitalisation and deaths. Locally in Washington State the positive case numbers are up dramatically but hospitals and deaths are still lagging (i.e. flat). Graphs from The Seattle Times.

imageimage

Tuesday – the deaths lag the hospital intake, which lags the positive cases. England & Wales death tolls jumps 41%

Monday – Biden transition announces COVID-19 Task Force. Positive news on vaccines. “Back to normal by Spring 2021”

The Guardian The Seattle Times
9 Nov here here
10 Nov here here
11 Nov here here
12 Nov here here

13 Nov

here here
14 Nov here here
15 Nov here

here

https://www.theguardian.com/world/series/coronavirus-live

COVID week 34 of lockdown – Nov 2 – Nov 8

Weekend – US setting the pace for a million new cases per week. Shocking, sad, not unexpected. Washington State – big spike in numbers. The White House continues to spread coronavirus. Melbourne relaxes the lockdown (which seems to have worked).

From The Seattle Times – the regular weekly status. That spike is going to be brutal. Hospital capacity is still good – but the spike in testing is the early indicator.

Friday – while most of the news continues to focus on election counts, the infections keep coming. US setting records for daily new cases. I would not be surprised to see some huge spikes in 5-14 days from long lines waiting to vote.

Thursday – the steadily increasing number of global cases, followed by the lagging hospitalisation, followed by the deaths. Europe, USA, Brazil.

Wednesday – post election. Record breaking local Washington State coronavirus cases. England lockdown starts tomorrow, panic buying and last minute socialising.

Tuesday – election day in the US. COVID related news intertwined with election news. Mask wearing while voting is now a partisan issue :\

Monday – Argentina importing 10M Russian vaccines.

The Guardian The Seattle Times
Nov 2 here here
Nov 3 here here
Nov 4 here here
Nov 5 here here
Nov 6 here here
Nov 7 here here
Nov 8 here here

https://www.theguardian.com/world/series/coronavirus-live

COVID week 33 of lockdown – Oct 26 – Nov 1

Weekend – Numbers and reports from around the US and Europe continue to show a massive rise in positive tests, associated hospitalisation and the final lagging indicator, death.

Washington State numbers from The Seattle Times. Daily cases up, 800+ per day – that’s approaching the July peak. Hospitalisation and death are still relatively stable.

Friday – 91k US cases in the last 24 hours. 24k UK cases. This is the “new normal” as we head deeper into this phase of infection. “Save Christmas” lockdown.

Chart shows cases are continuing to rise steeply

Thursday – EU moving patients across borders to keep hospitals going.

Wednesday – France, Germany, Greece.

Tuesday – Talk of a new England-wide lockdown.

Monday – There is a risk this becomes a list of countries with record breaking infection. Portugal, Czechia, Belgium, Italy, UK, most of the US.

The Guardian The Seattle Times
Oct 26 here here
Oct 27 here here
Oct 28 here here
Oct 29 here here
Oct 30 here here
Oct 31 here here
Nov 1 here here

https://www.theguardian.com/world/series/coronavirus-live