/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 11 years ago
Red Belt
0

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ