We deploy MX64s that have names that allow me to easily parse the location where it resides. Most of them use one of a handful of templates. The managed computers at a location have SCCM on them and I can see the LAN address that they are using, but I don't know where they are. What I am trying to achieve is to locate the computers based on the unique subnet issued by the MX64. Using the API I can easily pull all of the MXs on our network, and I can see their WAN addresses, but I don't see a way to tell what DHCP pool range the device is using when handing out addresses on the LAN side, or even it's LAN address even though there is a field for that, it does not have a value.
I have written a script that loops through all the devices and then all the clients but that is tedious and very time consuming. Is there a more efficient way to get this info? Is there a setting on the template that is stopping the "lanIp" field from being populated?