I am using an SQL report that I found here on IT Ninja to find duplicate computers in Assets and Inventory.  On the report for the Assets it is still showing I have duplicate service tags even after I have removed the duplicates.  It's like it's not seeing the machines I have deleted from Assets and are still counting them.  My thinking is possibly those database records were just "hidden" in the database rather than deleted and it is still counting the service tags?  Does anybody have an idea how to fix this?  I am still running the latest version of 5.3.  We will be upgrading to 5.4 SP1 in the near future.

Here is the SQL I'm using:

 SELECT COUNT(ASSET_DATA_5.FIELD_22) as Count, ASSET.NAME as 'System Name', ASSET_DATA_5.FIELD_22 as 'Service Tag'
group by ASSET_DATA_5.FIELD_22 
having Count > 1
0 Comments   [ + ] Show Comments


Please log in to comment



Can you see the machines in the Assets module if you search for them? 

Answered 03/26/2013 by: chucksteel
Red Belt

  • When I search the assets module for a serial number that the report claims I have 5 duplicates of, it only returns 1 result now. Initially, the report was accurate but we have since cleaned the duplicates but the report is still claiming the same number of duplicates as it did originally even when there are none now.
    • Do you have MySQL Workbench or a similar tool setup? I can't replicate your query because we use the serial number as the Asset name and not system name. I would recommend looking at the ASSET_DATA_5 table in MySQL Workbench to get an idea of what is going on.
Please log in to comment
Answer this question or Comment on this question for clarity