How to delete double entries from the query window?

Version 3

    Description

     

    When creating a new query, some or all of the components are double listed.

     

    Solution

     

    1. Make sure you have a current backup of your LANDesk database, or take a backup now, also stop any Inventory server services running against the database.
    2. Make sure to run DBRepair to clear out any corrupted data.
    3. Delete the following tables from the LANDesk database:
      HISTORY
      METAKEYS
      METAOBJATTRRELATIONS
      METAATRIBUTES
      METAOBJRELATIONS
      METAOBJECTS
    4. Run CoreDBUtil.exe from <drive_letter>:\Program Files\LANDesk\ManagementSuite\ folder on the Core server and choose "Build Components"