Relay Planning - Hosts Per Subnet with Relay Counts

I’m wondering if anyone has any suggesstions on creating a report that show all subnets, the number of hosts per subnet, and the number of relays deployed to the subnet? There is a similar fixlet for wake-on-lan devices but we need help in identifying subnets with large host counts and no existing relay.

I found an earlier post with the following code below which gives me the network and host counts, now all I need is the number of relays deployed, and possibly the average hop count per subnet.

<?relevance (html "" & html ( "") & it & html "
Known Subnets Host Count
") of concatenation of trs of (td of it & td of (multiplicity of it as string)) of unique values whose (multiplicity of it > 1) of ( if (it = "") then "Missing Subnet Address" else (it)) of values of results from (bes computers) of bes property whose (name of it = "Subnet Address") ?>
1 Like