Find Duplicate Attributes in an ESRI Geodatabase

I snapped this idea from ideas.arcgis.com,

I have been looking for a GP tool that can be used to find and list duplicate attribute values in an attribute table since ArcGIS 9.3.  I was able to find a SQL script for this purpose in the GDB Management Island at the 2012 UC, but I would have to Remote Desktop into another machine to run this process.  
If the duplicate ID values can be found and listed using a GP tool, that would be helpful in my organization's workflow process. 

Until ESRI implements this, here is a quick script I wrote for you guys to do just that.

• Open ArcMap

• Go to customize

• Go to Commands 

• Scroll until UI Controls

• Click NeW UIControl and select button

• Drag the new button anywhere in the toolbars

• Right click on the new button and click view source (make sure you are still in customize mode)

• Paste the code and run,

• you must first select the layer you want to find the duplicates in and then click the button, there you will be prompted to type-in the field name..

Download Script