9 Replies Latest reply on Nov 8, 2013 9:53 AM by tom.rybka

    Need help with Querying Property Data for use in SOAP Method QueryXML

    Daniel Miller

      When I try to Query and Retrieve the Properties for a particular Node, I get an Error on EntityType

       

            <inf:query>SELECT Caption, NodeID, IP_Address, EngineID, EntityType FROM Orion.Nodes </inf:query>
            <inf:parameters />
          </inf:QueryXml>
        </soapenv:Body>
      </soapenv:Envelope>
      2013-11-04 11:58:43,873 [15] ERROR SolarWinds.InformationService.Core.InformationService - Exception caught in method RunQuery
      SolarWinds.Data.Query.ParserException: Cannot resolve property EntityType
         at SolarWinds.Data.Query.Processor.SemanticChecker.HandleNonQualifiedPropertyName(EntityExpression entityExpression)

       

       

      I noticed That When I create the Node and I Specify the Entity Type as Orion.Nodes in the Create method with the EntityType XML Element.  The Orion.Nodes Table still shows a Null value and not Orion.Nodes For the Column EntityType.

       

      Anyone know why I can't Query this Column?