Resource is not recognizing from resource graph explorer

Diptesh Kumar 101 Reputation points
2024-05-17T09:41:14.8666667+00:00

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.

Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
326 questions
{count} votes

1 answer

Sort by: Most helpful
  1. tbgangav-MSFT 10,421 Reputation points
    2024-05-17T16:28:27.03+00:00

    Hi @Diptesh Kumar ,

    It might just be an issue with case-sensitive "Resources" versus "resources". Try the lower-case "resources" table name.

    User's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.