Using SNMP to get MAC address for PPPoE sessions

I need to create a report from 19 routers in 19 cities looking for any DSL modem logging in via PPPoE using the login “autoconfigure”. Our DSL modems, if configured incorrectly in the server will not login utilizing the clients PPP credentials and will be stuck in “autoconfigure”. As such I need to track them down and then flog the CS rep that misentered the information, but that’s beside the point.

I can get the client name easily, they show up in interfaces.ifTable.ifEntry.ifDescr:

RFC1213-MIB::ifDescr.7187 = STRING: “”
RFC1213-MIB::ifDescr.7188 = STRING: “”
RFC1213-MIB::ifDescr.7189 = STRING: “”
RFC1213-MIB::ifDescr.7190 = STRING: “”
RFC1213-MIB::ifDescr.7191 = STRING: “”

The next piece I need is the MAC address of the modem. You can see it easily from WinBox under Active Connections in the Caller ID column in the PPP window:

But after several SNMPwalks, I have been unable to find the MAC address of the pppoe connections available in the tree.

John Fulton
Anchorage, AK

I have RouterOS v5.23 and i can see that same info you provided in the ppp.interface menu as it follows:

And after diggin a lot in the documentation…
I cant manage to get the mac address of the connected PPPOE client with snmp!
I had also tried to use ARP (arping utility) with no success.

Have you made any progress @ this?
What other means than snmp or arp can be used to get this information? My project depends on this.