SW Report Writer Help

I want to create a report of all nodes which have and IP address

on any of their interfaces which ends in 100.1. For columns I want the node

name, the IP address and a custom attribute of City Name. I've

spent a couple of hours trying to dial this up and keep getting

not enough results or none. Any assistance would be appreciated.

The devices are Cisco ISRs with a few switched virtual interfaces

or the addresses might be on sub-interfaces of a 802.1q trunked port facing

a switch.

Any help appreciated.