"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%'