(imported topic written by SystemAdmin)
below returns the name and (bes property) IP Interfaces of any server that has a OS of ESX
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose (operating system of it as lowercase contains “esx”)
How would I search a (BES Property)
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose
((value of results of bes property “Location”) as lowercase contains “milwaukee”)
this always returns 0 results
(imported comment written by BenKus)
See if this works:
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose ((value of results (it, bes property “Location”)) as lowercase contains “milwaukee”)
Alternately, just use the built-in filtering methods in web reports.
Ben
(imported comment written by SystemAdmin)
Thank You Ben… that worked perfectly again… 
I thought there was a difference between one of my properties like “Location” and one of your properties like “cpu”
although i did find 1 possible issue…
Works
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose ((value of results (it, bes property “cpu”)) as lowercase contains “pentium”)
Works
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose ((value of results (it, bes property “Location”)) as lowercase contains “milwaukee”)
Does not Work
0 results
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose ((value of results (it, bes property "
OS
")) as lowercase contains “win”)
Does not Work
0 results
(name of it , (if (exists results (it,bes property “IP Interfaces”) whose (exists value of it)) then values of results (it,bes property “IP Interfaces”) else “No Result”)) of bes computers whose ((value of results (it, bes property "
Operating System
")) as lowercase contains “win”)
(imported comment written by BenKus)
Yes… there are some differences between the reserved properties and other properties… Most notably, the reserved properties can be looked with special inspectors such as:
cpus of bes computers
However, in the OS example that you give, I bet that you have two OS properties. In this case, the ‘bes property “OS”’ inspector will randomly pick one of the OS properties. To fix this, you would need to specify more conditions about the property such as: ‘bes property whose (name of it = “OS” AND reserved flag of it = true)’
Ben