Powershell - query for printer info

The goal is to run this script against "print servers" and have it populate and excel spreadsheet with all the info. Then make a second pass and if it can ping the IP associated with the printer, then get the MAC address and populate that in the excel spreadsheet. I've roughed some code together but it needs to be reorganized and cleaned up so it works. I would like all the variables in the code to be populated in the spreadsheet: Ping status, ServerName, MAC address, and the variables below. $pservername $psharename $pname $pportname $pdrivername $plocaion $pcomment $pIP ## Deliverables See attached current code