Tip: KQL Query for Azure VMs with Periodic Assessment Enabled

Azure, Azure Resource Graph, Update Management, Update Manager 1 Minute

Unfortunately due to personal reasons I haven’t been able to blog for a while. I am hoping I can change that and this will be one of those small blog posts. Recently on Microsoft Q&A there was question if you can get all Azure VMs with Period Assessment (Azure Update Manager feature) enabled.

This can be achieved easily by using Azure Resource Graph and Kusto Query Language (KQL) query.

resources
| where type =~ "microsoft.compute/virtualmachines" 
| where properties.storageProfile.osDisk.osType in~ ('Linux','Windows')
| extend patchSettingsObject = iff(properties.storageProfile.osDisk.osType =~ "windows", properties.osProfile.windowsConfiguration.patchSettings, properties.osProfile.linuxConfiguration.patchSettings)
| extend assessMode = tostring(patchSettingsObject.assessmentMode)
| extend periodicAssessment = iff(isnotnull(assessMode) and assessMode =~ "AutomaticByPlatform", "Yes", "No")

The result with Yes or No you can see in periodicAssessment column. I hope you will find this useful.

Published by Stanislav Zhelyazkov

Stanislav Zhelyazkov has been working in IT since 2007. Stanislav has started his IT career as a Help Desk Specialist in 2007 while studying Informatics in the University of Ruse. He also worked in HP Enterprise Services (now known as DXC), maintaining large corporate IT infrastructures for clients in Holland, Switzerland and Germany and was involved in a Private Cloud project based on MS Hyper-V and System Center. He was also in the role of Principal Consultant in Lumagate developing and consulting companies on Azure, OMS, management and Private clouds. Currently he is Cloud Infrastructure Engineer at Sentia Denmark. Stanislav is active community member at MSDN forums providing answers on Azure. His blogposts can be found at www.cloudadministrator.net or www.systemcentercentral.com.

Published

One thought on “Tip: KQL Query for Azure VMs with Periodic Assessment Enabled”

  1. Pingback: Microsoft Roadmap, messagecenter en blogs updates van 17-02-2024 - KbWorks

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.