Return all machines that contain one application, but not another
AnsweredI have been trying to create a report that returns all machines which contain a certain application name, but does not contain another application name. I can not get it to work, it just returns nothing, or return machines that the above is not true. I have even tried saying it contains this application name, but not this service name. Below are a couple of the screenshots of what I described above. Is this not possible without using a SQL report? Seem pretty basic to me.... Thx!
-
Aha! I was focusing on Collections, not Reports.
When you have multiple tables in a Basic Report (such as Computer and Application), the Filters apply to each row of the joined data (it runs an INNER JOIN behind the scenes) instead of the entire computer.
Just Computer: does this computer have an application named Chrome, and not any named Firefox?
Computer and Application: does this row's Application Name match Chrome, and not match Firefox?If you want to have both tables in your Report, create a Collection with the same Filters and point your Report at it with Select Collection Source.
Please sign in to leave a comment.
Comments
7 comments