Find PIM enabled routers

Edit online

This query returns a list of all routers that are enabled to use Protocol Independent Multicast (PIM).

Example

1]  SELECT     e.entityName,
2]             c.sysName,
3]             p.joinPruneInterval
4]  FROM       pimService p
5]  INNER JOIN hostedService h ON h.hostedEntityId=p.entityId
6]  INNER JOIN entityData e ON e.entityId=h.hostingEntityId
7]  INNER JOIN physicalChassis c ON c.entityId = e.mainNodeEntityId;