The below query will allow you to search by Mac address and return the device name and the asset tag of an asset stored within the Manage Engine Service Desk Plus product.
I wrote this query as I couldn’t find a way of searching for an asset by Mac address within the GUI or the report suite.
Just change the MACADDRESS in the where clause as required. Hope this helps.
SELECT Resources.RESOURCENAME, Resources.ASSETTAG, NetworkInfo.MACADDRESS FROM Resources LEFT JOIN NetworkInfo ON Resources.RESOURCEID = NetworkInfo.WORKSTATIONID WHERE MACADDRESS = 'F0:D3:BA:AE:5D:A9'