Pending unmanaged client deployments - Devices are deleted but come back when refreshing

Version 3

    Verified Product Versions

    Endpoint Manager 9.6Endpoint Manager 2016.x

    SYMPTOM



    After a migration or an error while deploying an agent to a device, this device might stay in the "Pending unmanaged client deployments" window.


     

    CAUSE

     

     

    This is sometimes due to the fact that the Core Server still has data in its database and it is unable to delete it itself.

     

     

    RESOLUTION

     

     

    In order to get rid of these devices, you will have to delete them from your database manually.

     

        This implies to modify your database, which means that you must have a functional recent backup available

     

    To create a backup of your database, please follow this article: Backup and Restore Database: How to move the LANDesk database to another server (SQL 2000 & 2005)

     

    Once you have your backup ready, do the following:

     

        I. Identify your device(s)

     

    Go to your Pending unmanaged client deployments, and write down the 'DeviceName' of your machines:

    1.png

     

    We will use the following as our 'DeviceName' data:

     

    • CLIENT-01

     

    Once you have the names, open your SQL Management Studio and use the following:

     

    SELECT [Computer_Idn] FROM [YOURDATABASENAME].[dbo].[Computer]
    WHERE [DeviceName] = 'YOURCLIENT'
      

     

    In our case, we will have this:

    2.png

     

    The important information here is the 'Computer_Idn', in our example: 4069

     

    Repeat the operation for all your devices that you cannot delete.

     

     

        II. Delete your device from the tables

     

    Once you have your list of 'Computer_Idn', create a new query with the following:

     

    DELETE FROM [YOURDATABASENAME].[dbo].[BoundAdapter]
      WHERE [Computer_Idn] = 'YourComputer_Idn'
    
    DELETE FROM [YOURDATABASENAME].[dbo].[TCP]
      WHERE [Computer_Idn] = 'YourComputer_Idn'
    
    DELETE FROM [YOURDATABASENAME].[dbo].[NetworkSoftware]
      WHERE [Computer_Idn] = 'YourComputer_Idn'
    
    DELETE FROM [YOURDATABASENAME].[dbo].[LanDesk]
      WHERE [Computer_Idn] = 'YourComputer_Idn'
    
    DELETE FROM [YOURDATABASENAME].[dbo].[Computer]
      WHERE [Computer_Idn] = 'YourComputer_Idn'
    

     

    Here is the result in our example:

    3.png4.png

     

    As you can see in our example, it looks like the record of our CLIENT-01 was not found in the table 'BoundAdapter'. This does not mean that there is a problem at all.

    When you go back to your console, check that the client has disappeared properly.

     

    So far, here are the tables that where we found information of the computers:

     

    • BoundAdapter
    • TCP
    • NetworkSoftware
    • LanDesk
    • Computer
    • ProductComputer
    • FileInfoInstance

     

    You might encounter a problem when trying to delete this record, and it will let you know that there is another place in the database where this computer is still in use.

    You will have to add this table to the deletion process.