Manage Engine Service Desk Plus – An SQL query to search for an asset by MAC Address

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'