Finding Systems with a missing local admin

[abustraan]

I'm trying to ensure that all systems have a dedicated local admin for Lansweeper. I found these 2 attached reports:

1. Report to determine local admins per system.
2. Report to determine software missing from system.

I'm trying to merge the two reports to generate a list of systems missing my Lansweeper local admin.

Thanks in advance.

[Mister_Nobody]

you can use function count() + group by to count membership

and having count() = 0 for filtering