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>

dix-neuf − dix-huit =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) This endpoint requires the 'manage_pages' permission or the 'Page Public Content Access' feature. Refer to https://developers.facebook.com/docs/apps/review/login-permissions#manage-pages and https://developers.facebook.com/docs/apps/review/feature#reference-PAGES_ACCESS for details.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.