Hi,
I want to get two bes property results but dont know how to write in relevance lag, please suggest.
“relevance=(id of computer of it, Names of Computer of it, concatenation “”|”" of values of it) of results whose (exists values of it) of bes property ““Location””"
Currently above relevance is provided data for one property but now I want data from another property too with the current one so how to add that, please help.
Second property will be “Location Subnet”
There are a few different ways to go about this, but here’s one potential approach (I’ve somewhat simplified this to show the general syntax, but this could use better handling):
((values of results (item 0 of it , item 1 of it)), (values of results (item 0 of it , item 2 of it)), (values of results (item 0 of it , item 3 of it)) , (values of results (item 0 of it , item 4 of it))) of (bes computers , bes property "ID" , bes property "Computer Name" , bes property "Location" , bes property "Location Subnet")
To help generate various forms of session relevance, I’d suggest having a look at the Excel Connector, and it’s Query Wizard. It provides a nice graphical interface with which to build a query, then you can also click ‘Show Relevance Code’ to expose the relevance it leverages for a given query:
Thanks its worked but its creating multiple entries for one server if property having multiple results.
If possible can this will be generated in this below format, I have used it before for generating data in xml.
Blockquote
India
X.x.x.x|X.x.x.x|x.x.x.x|x.x.x.x|….
Blockquote
How about something like:
((values of results (item 0 of it , item 1 of it)), (values of results (item 0 of it , item 2 of it)), concatenation "|" of (values of results (item 0 of it , item 3 of it)) , concatenation "|" of (values of results (item 0 of it , item 4 of it))) of (bes computers , bes property "ID" , bes property "Computer Name" , bes property "Location" , bes property "Location Subnet")Thank you ! thats exactly what I was looking.