Skip to main content

 

Devices with unknown state on enable monitors

3 months ago
OfflineHélio Fitas
Hélio Fitas
Description:  Devices with unknown state on enable monitors
Language: SQL
Code:
 

SELECT DISTINCT
Device.nDeviceID

FROM Device

JOIN
PivotActiveMonitorTypeToDevice

ON Device.nDeviceID =
PivotActiveMonitorTypeToDevice.nDeviceID

WHERE
PivotActiveMonitorTypeToDevice.bDisabled = 'False'

AND

PivotActiveMonitorTypeToDevice.nMonitorStateID
= 0

-----
You liked this too2 people like this discussion.
 
Concluded

0 Conclusions:

0 Replies

Would you like to comment?

You must be a member. Sign In if you are already a member.

  • 222 views
  • $obj.VersionIndex versions
  • 0 replies
  • 0 followers
     
Post Date:
January 24, 2012
Posted By:
Hélio Fitas

About this forum

  • 15,220 views
  • 40 topics
  • 4 followers
     

Viewed 222 times