Report request

Possible to get a report listing all duplicate asset names? It would also be nice to have additional info list serial number, asset tag, state, etc.

MSSQL build 9220

Thanks