Find all devices in each subnet

This query identifies all of the subnets listed in the database. For each subnet the query provides the netmask of that subnet and the list of IP addresses collected within that subnet. The IP address collected within a subnet might refer to main nodes or interfaces; typically, they refer to interfaces.

1]  SELECT     s.network Network,
2]             s.netmask Netmask,
3]             e.entityName Entity_Name
4]  FROM       subnet s
5]  INNER JOIN collects c ON c.collectingEntityId = s.entityId
6]  INNER JOIN entityData e ON e.entityId = c.collectedEntityId
7]  ORDER BY   s.network