Pulling services using rest api query

That is exactly what I was suggesting.

Hmm, this is still giving me everything and not filtering out the services I don’t want, no errors but not the correct results.

(name of it & " - " & concatenation “, " of (preceding texts of lasts " (” of it) of values of results from (bes property “Services - Windows”) of it) of bes computers whose (exists results from ((bes property “Services - Windows”) whose (name of it does not contain “Application Experience” as string)) of it)

I checked my ‘it’s’ in the fixlet debugger and it I thought I had the right ones in there. Not sure, at the end of this I’d like to put this in a separate question and just break down everything you did here.

This:

(name of it & " - " & concatenation ", " of (preceding texts of lasts " (" of it) of values whose(it does not contain "Application Experience") of results from (bes property "Services - Windows") of it) of bes computers whose (exists results from (bes property "Services - Windows") of it)

Hah, this is actually rolling along pretty good, thanks to you! Gradually compiling a list of services on our network, but I don’t want to see workstations that have been eliminated by the ‘and it does not contain’ statements, I’ve got a TON of blanks where the only services they have are the ones I’ve eliminated(benign).

What I’m looking for is where to put the ‘if exists’ statement. In other words, if all the services on the computer match the ones I have listed in my ‘and it does not contain’ then I don’t care about that workstation and don’t need to see it listed. Does that make sense?

(name of it & " - " & concatenation “, " of (preceding texts of lasts " (” of it) of values whose
(it does not contain "ASP.NET State Service"
and it does not contain "Active Directory Domain Services"
and it does not contain "Active Directory Web Services"
and it does not contain "ActivIdentity Shared Store Service"
and it does not contain “Workstation”)
of results from (bes property “Services - Windows”) of it)
of bes computers whose (exists results from (bes property “Services - Windows”) of it)

You could use another whose clause to filter out any machine that doesn’t list any services.