I need to create a web report query that finds all computers whose 2 properties match (because those should not exist) and have checked in within the past 12 hours.
name1, site1, value1
name2, site2, value1 <- not a hit
name3, site3, value1 <- hit
name4, site3, value1 <- hit
If I understood the request, this can be done with a custom Web Report and session relevance like the following:
((
name of item 0 of it | “missing name”
, (concatenation “;” of values of results (item 0 of it, elements of item 1 of it))
, (concatenation “;” of values of results (item 0 of it, elements of item 2 of it))
) of (
elements of item 0 of it
,item 1 of it
,item 2 of it
) of (
set of BES computers whose (last report time of it > (now - 12 * hour))
, set of bes properties whose (name of it as lowercase = (“Property1”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Property2”) as lowercase)
))
whose (item 1 of it = item 2 of it)