Assistance with report to identify multiple MAC addresses on nodeaccesspoint, portname

thegreengirl

I'm trying to identify rogue switches on my network.

I don't have UDT but I was trying to write a SQL query to identify nodeaccesspoints with multiple associated MAC addresses.

Here's what I had so far:

SELECT TOP 1000

nodeaccesspoint, portname, macaddress

FROM [dbo].[UDT_MACCurrentInformation]

GROUP BY  nodeaccesspoint,portname,macaddress

--HAVING COUNT(macaddress) > 1

ORDER BY portname DESC;

I appear to have gotten it working using the query above + Excel 'cheating' but I'm sure there's a more efficient way to do this.