Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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

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?

Find more posts tagged with

Accepted answers

All comments

RichardLetts

I don't think EntityType is an attribute of Node -- it's used in the Create to determine what type of object is to be created;

if you'[re querying the Orion.Nodes table every entry will be of type Orion.Nodes

/RjL

Daniel_Miller

Yes, but the EntityType value after the Create node SOAP operation runs is NULL and it should be Orion.Nodes which is passed during the create operation.

tdanner

Richard is right. Orion.Nodes does not have an EntityType property. There is an InstanceType property shared by all SWIS entities that you can query if you want.

Daniel_Miller

How do I make sure the Column EntityType is Updated with the correct Value Instead Of NULL?

tom.rybka

It is true that Orion.Nodes doesn't contain any EntityType property you could query (there is InstanceType instead you can use).

On the other hand, the EntityType column in the Nodes table in the database really exists and should be initialized to make the system process the record in an expected way. Although there is no property EntityType in the Orion.Nodes, you should be able to initialize the column exactly the same way as it was an entity property (of string type). From your description I can see that you are providing the value "Orion.Nodes" for the "EntityType" in the Create operation and that should work. I have verified it locally with a PowerShell script and cmdlets. You should be able to reset it also using the Update operation later. Can you please send also a fragment of the Create SOAP request you use?

Daniel_Miller

Thank you. I appreciate your time in assisting me with this. Here is the SOAP Create Statement and The Result.

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAPParameter::GetElement() --> Build SOAP Element Complete

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAPMethod::GetElement() --> Putting Together Element For Create

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> Method: Create

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> POST To URL: https://dtsfkoriont2.edu.ds.ky.gov:17778/SolarWinds/InformationService/v3/OrionBasic

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> Content-Type: text/xml

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> Host: DTSFKORIONT2.edu.ds.ky.gov

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> Connection: Keep-Alive

11/7/2013 9:23:35 AM --> DEBUG -- (3) - CSOAP::Send() --> Accept-Encoding: gzip,deflate

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> SOAP Action: http://schemas.solarwinds.com/2007/08/informationservice/InformationService/Create

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> Content-Length: 670

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> Sending XML:

<?xml version="1.0"?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:inf="http://schemas.solarwinds.com/2007/08/informationservice" xmlns:prop="http://schemas.solarwinds.com/2007/08/informationservice/propertybag">

<soapenv:Header/>

<soapenv:Body>

<inf:Create>

<inf:entityType>Orion.Nodes</inf:entityType>

<inf:properties>

<prop:item>

<prop:key>Caption</prop:key>

<prop:type>System.String</prop:type>

<prop:value>DTSFK216768</prop:value>

</prop:item>

<prop:item>

<prop:key>IP_Address</prop:key>

<prop:type>System.String</prop:type>

<prop:value>1.1.1.8</prop:value>

</prop:item>

</inf:properties>

</inf:Create>

</soapenv:Body>

</soapenv:Envelope>

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> Status: 200

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> Status Txt: OK

11/7/2013 9:23:36 AM --> DEBUG -- (3) - CSOAP::Send() --> Receiving XML:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Header>

</s:Header>

<s:Body>

<CreateResult>swis://DTSFKORIONT2.edu.ds.ky.gov/Orion/Orion.Nodes/NodeID=3601</CreateResult>

</CreateResponse>

</s:Body>

</s:Envelope>

Thanks again for you help.

tom.rybka

Thanks for the snippet, I can see the problem now. The <inf:entityType> element contains a name of an entity type to create a new instance of. However, this is a general parameter for the Create operation, the actual initial property values are listed in the <inf:properties> element, where you have to add a new <inf:item> element for the string EntityType value again - this one gets saved in the database in the Nodes table's column.

Looking at the request, there are more other properties you need to initialize, in order to make Orion recognize the new node and start to monitor. Please, take a look at the Technical Reference document in the Orion SDK, there is a list of properties required and their expected values.

Daniel_Miller

Adding the EntityType as a Property as well worked for the Create Process. Thank You.

All the other properties I was updating during the Update process.

I am basically creating a server GPO that does the following.

Any new Servers being joined to the domain will run this script.

The script queries to see if it exists in Orion.

If Not, it will create a new node with its name and IP address.

whether the node existed or was just created, it queries some os/server info and adds those properties (i.e SNMP or ICMP)
updates Orion with the Information.

Thank you for your help. It is much appreciated.

tom.rybka

You are welcome. Adding new nodes in Orion and having them monitored however means also associating new pollers to collect actual data. Please see the Technical Reference for more details about the process of adding nodes in general.