26JUL2015
Share

Read next article:

"Export all Passive Monitor"

Read previous article:

"Devices added on certain period of time"

All assigned Active Monitors

In Default | 0 comments

This query displays all assigned Active Monitors for all Devices

SELECT Device.nDeviceID,
       Device.sDisplayName,
       sMonitorTypeName,
       sMonitorTypeDescription

FROM Device
LEFT OUTER JOIN DeviceType ON
Device.nDeviceTypeID = DeviceType.nDeviceTypeID
LEFT OUTER JOIN PivotActiveMonitorTypeToDevice ON
Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID
LEFT OUTER JOIN ActiveMonitorType ON
PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID = ActiveMonitorType.nActiveMonitorTypeID

ORDER BY nDeviceID

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>

20 − seize =

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.
About Us :
Orchtech is a software development company working in multiple countries worldwide and our experience spans over multiple services/products such as Offshoring/Outsourcing software development, Mobile applications development services, Web development and HR mobile applications for internal employees management.
Liens:
À propos de Nous:

Orchtech est une société de développement de logiciels opérant à l'international. Nous avons un savoir faire qui recouvre notamment la sous-traitance de développement de logiciels, le développement d'applications mobiles, le développement Web et les applications mobiles RH pour la gestion interne des employés.

Copyright © Orchtech.com 2016.