Collection filter results are incorrect
I'm having an issue with PDQ Inventory 17 Enterprise.
I'm using a basic filter to find any systems that have a certain domain user account in the local administrators group. Seems simple enough.
I have (edited to remove specific details): All - Local group - name - equals - Administrators Local group member - domain - equals - [domain] Local Group member - name - equals - [username]
However while I am getting filtered results, I'm getting results for systems that do not have the user listed in the Administrators group. I've rescanned to ensure it's up to date, I've edited the filter to have one condition at a time and also completely removed it and re-added it as a clean one but I can't understand why some systems are showing up with results for systems that shouldn't be there. Strangely I've got the same filter set up for another username and that shows results correctly. With these systems the username used to be listed but I removed the listing in the Administrators group but something in the Inventory still says it exists although looking at the workstation inventory details, there is no existence of it. I've also done a database optimise to see if that helps but nada.
Am I just using an incorrect query or has anyone else come across this issue?