Share

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

 

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>

1 × one =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook. To submit this 'Page Public Content Access' feature for review please read our documentation on reviewable features: https://developers.facebook.com/docs/apps/review.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.