Disappointed with the built in reporting (specifically the inability to query installed applications against a single group), I thought the way around this would be some direct SQL queries joining the tables relating to computer group memberships, computers, and applications. However, there does not seem to be a primary key I can use to link the computers with the Applications.
Am I missing something?