Duplicate assets are still showing on report even though the duplicates have been deleted
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' FROM ASSET_DATA_5 JOIN ASSET ON ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID group by ASSET_DATA_5.FIELD_22 having Count > 1