SELECT searches.*,, AS Test FROM searches LEFT JOIN computers ON computers.computerid = searches.computerid INNER JOIN sensorchecks ON searches.searchid = sensorchecks.sensid WHERE IS NOT NULL ORDER BY NAME ASC

That’s how!

This SQL query will bring you back a list containing all the groups a computer is a member of, including the SearchID that is joining them to said group.