3 of 3 people found this helpful
What are you actually trying to achieve? I think you are after just results where you have one row per service that matches your condition, but only for the most recent discovery access for each Host:
with #Member:List:List:ServiceList.#DiscoveryResult:DiscoveryAccessResult:DiscoveryAccess:DiscoveryAccess.#Associate:Inference:InferredElement:Host as host
where name has subword "ccmexec" and #host
show #host.name as "Host Name", #host.os as "OS", name, state
Thanks thats exactly the list that I wanted to get.