How to get Group Series MAC address from RPRM Inventory using the MAC OID and Group Series serial number

Using the list of Group Series Serial Number from RPRM Endpoint Inventory report you should be able to create list of MAC address. All Group Series Endpoints use the Via Video OID 00:e0:db and the second part of the mac address is contained in the serial number. Customer needed to generate a report with all Poly mac addresses and did not want to web into each device to get the mac addresses.