Where are the devices

In Default | 0 comments

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:

1. 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%'

1. 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%'

0000