"Opening Tickets in Help Desk"
"CPU Performance using SQL Query"
You have to use SQL query If you are trying to find the groups where the devices are located.
SELECT Device.nDeviceID, Device.sDisplayName, DeviceGroup.nDeviceGroupID, DeviceGroup.sGroupName
FROM Device
LEFT OUTER JOIN PivotDeviceToGroup ON Device.nDeviceID = PivotDeviceToGroup.nDeviceID
LEFT OUTER JOIN DeviceGroup ON PivotDeviceToGroup.nDeviceGroupID = DeviceGroup.nDeviceGroupID
Also, you can use WHERE condition to filter the result of above query, for example:
WHERE Device.nDeviceID = '15'
WHERE Device.sDisplayName LIKE '%Orchtech%'
WHERE DeviceGroup.nDeviceGroupID = '55'
WHERE DeviceGroup.sGroupName LIKE '%Windows%'