Duplicate assets are still showing on report even though the duplicates have been deleted
Hello,
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
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
11 years ago
Can you see the machines in the Assets module if you search for them?
Comments:
-
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. - Sean85 11 years ago
-
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. - chucksteel 11 years ago
