/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Duplicate assets are still showing on report even though the duplicates have been deleted

03/26/2013 3784 views

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

Comments


All Answers

0

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.
 
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