Skip to main content

Idea 

Devices dependent on a specified device

3 months ago
OfflineLeonardo Schieder
Leonardo Schieder
Description:  Lists devices dependent on the specified device (-> change DEVICENAME in the script), regardless of Up or Down dependency.
Language: SQL
Code:
 SELECT DISTINCT Device2.nDeviceID
 FROM Device AS Device1
 INNER JOIN PivotDependencyToDevice
 ON Device1.nDeviceID = PivotDependencyToDevice.nDependencyDeviceID
 INNER JOIN Device AS Device2
 ON PivotDependencyToDevice.nDeviceID = Device2.nDeviceID
 WHERE Device1.sDisplayName LIKE '%DEVICENAME%'
-----
You liked this idea too2 people like this idea.
 
1 subscriber is following updates on this item.
Resolved

0 Resolutions:

0 Replies

Would you like to comment?

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

  • 200 views
  • $obj.VersionIndex versions
  • 0 replies
  • 1 follower
     
    1 subscriber is following updates on this item.
Labels:

Dynamic Group, SQL Query, WhatsUp Gold

Post Date:
January 25, 2012
Posted By:
Leonardo Schieder

About this forum

  • 15,220 views
  • 40 topics
  • 4 followers
     
    4 members are following updates on this item.
Viewed 200 times