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:
- You can filter the result to display the groups for certain device. You should use one of the following condition.
WHERE Device.nDeviceID = '15'
WHERE Device.sDisplayName LIKE '%Orchtech%'
- You can filter the result to display the devices inside certain group. You should use one of the following conditions.
WHERE DeviceGroup.nDeviceGroupID = '55'
WHERE DeviceGroup.sGroupName LIKE '%Windows%'