Create a report: Duplicate MAC

[WING987]

Due to a problem with someone cloning our virtual systems and not adjusting the MAC address I need to build a report for what is supposedly impossible...to find duplicate MAC's. I attempted to modify the duplicate serial number report to work as intended without any luck (I keep getting "the multiport identifier XXXX.XXXX cannot be bound" errors. I am not very well versed in SQL, and have only been able to get the duplicate MAC's to show up with a count of the number of entries, but not with the asset name that they belong to. Do you hae a report that can accomplish this?

[StillGoing]

I'm going to resurrect this post to try and engage the community regarding transitioning from Lansweeper on-prem to Lansweeper sites. This seemed like a good place, as we use this specific report all the time; in fact, we have an alert setup to watch for and report any time we get duplicate mac addresses, so we can review and mitigate them.

My question; is it possible to re-create this functionality in Lansweeper sites? 

I have deep concerns about the reporting functionality in Lansweeper sites. I had high hopes for the new "BI integrated reporting" that was introduced this month; while it introduces some needed functionality, it falls short in delivering on reporting parity with the on-prem version. We have numerous, complicated reports we have created on-prem, and I haven't figure out any way to get nearly the depth of functionality out of what's available in Sites.

Am I wrong? Is there a way to unlock functionality beyond what is readily available via the UI? I haven't found it, but I'd love to find out I've just missed something.

Thoughts?

[WING987]

that worked perfectly! Thank you RC62N

[RCorbeil · Accepted solution]

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Mac
FROM
  tblAssets
WHERE
  tblAssets.Mac <> ''
  AND (SELECT Count(*) FROM tblAssets AS a WHERE a.Mac = tblAssets.Mac) > 1
ORDER BY
  tblAssets.Mac

should limit your output to records where there are multiple instances of the MAC.