Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
326 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have exected following query but it is not recognizing, i executed in the resource graph explorer
Resources
| where type contains "softwarepatches"
| where properties !has "version"
| extend machineName = tostring(split(id, "/", 8))
| extend resourceType = tostring(split(type, "/", 1))
| extend rgName = tostring(split(id, "/", 4))
| extend RunID = tostring(split(id, "/", 10))
| extend prop = parse_json(properties)
| extend lTime = todatetime(prop.lastModifiedDateTime)
| extend patchName = tostring(prop.patchName)
| extend kbId = tostring(prop.kbId)
| extend installationState = tostring(prop.installationState)
| extend classifications = tostring(prop.classifications)
| where lTime > ago(30d)
| project lTime, RunID, machineName, rgName, resourceType, patchName, kbId, classifications, installationState
| order by RunID
ERROR:
| where type contains "softwarepatches"
'Resources' is not recognized as an internal or external command,
operable program or batch file.
| was unexpected at this time.
Hi @Diptesh Kumar ,
It might just be an issue with case-sensitive "Resources" versus "resources". Try the lower-case "resources" table name.