try grouping your gateways.
there's a set of stock reports that can help, but you can't get what you want from the query tool.
To clarify this then, are you saying that the query I'm running in the report won't work or that its just not possible?
I tried the grouping thing btw and that didn't seem to help. I guess I'll keep trtying for a bit longer...........
the query tool works with the defined schema, not the entire database. unmanaged nodes are not defined in the schema and are invisible to the query tool. the canned reports can see that table, but there's no column for gateway address in it.