How do LabTech Searches, Groups and Computers tie together?

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.