Read next article:

"Opening Tickets in Help Desk"

Read previous article:

"CPU Performance using SQL Query"

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


Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

2 × trois =


Unable to display Facebook posts.
Show error

Error: Error validating application. Application has been deleted.
Type: OAuthException
Code: 190
Please refer to our Error Message Reference.