Resource is not recognizing from resource graph explorer

Question

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.

Answer 1

Hi @Diptesh Kumar ,

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