Here is a query that lists all AD groups the computer is member of together with deployments assigned to the computer.
Software Update deployments are excluded.

SELECT     v_R_System.Name0, v_RA_System_System_Group_Name.System_Group_Name0, v_CIAssignment.AssignmentName, v_CIAssignment.Description
FROM         v_R_System INNER JOIN
                      v_RA_System_System_Group_Name ON v_R_System.ResourceID = v_RA_System_System_Group_Name.ResourceID RIGHT OUTER JOIN
                      v_CIAssignmentTargetedMachines ON v_R_System.ResourceID = v_CIAssignmentTargetedMachines.ResourceID RIGHT OUTER JOIN
                      v_CIAssignment ON v_CIAssignmentTargetedMachines.AssignmentID = v_CIAssignment.AssignmentID
WHERE     (v_R_System.Name0 LIKE 'PC001') and (AssignmentName not like '%Software Update%' and AssignmentName not like '%Endpoint Protection%')