I'm hoping someone would be able to assist with writing a report that would be able to show devices that are missing a piece of software. This is somewhat similiar to this post:
https://community.lansweeper.com/t5/reports-analytics/report-request-computers-missing-one-of-two-pi...
However, in our scenario I'd like to assume that 1 piece of software always installs properly and should be used as the prerequiste filter for determining if the second piece is missing or failed. So using the example linked above the "ESET admin agent %" would be software we want to use to compile our base list of devices and then have the report output which machines in that list are missing the 'ESET AV client %'
Seems like it might be complicated because it may require a query inside another query? Any help would be appreciated. Thanks!