Show PIM adjacencies for a device

Example

This example shows PIM adjacencies for the device 172.20.1.7.

1]  SELECT     eA.entityName A, eZ.entityName Z
2]  FROM       topologyLinks t
3]  INNER JOIN connects c ON t.connectionId=c.connectionId
4]  INNER JOIN entityData eA ON eA.entityId=c.aEndEntityId
5]  INNER JOIN entityData eZ ON eZ.entityId=c.zEndEntityId
6]  INNER JOIN entityData et ON et.entityId = t.entityId
7]  INNER JOIN entityData eAMain ON eAMain.entityId=eA.mainNodeEntityId
8]  INNER JOIN entityData eZMain ON eZMain.entityId=eZ.mainNodeEntityId
9]  WHERE et.entityName='PIMTopology'
10] and eAMain.entityName = '172.20.1.7' or eZMain.entityName = '172.20.1.7';