How to find all instances of a NetworkID within SQL after error when updating or adding NetworkID to a User.

Version 4

    Verified Product Versions

    LANDESK Service Desk 7.7.x

    Error Displayed:

    NetworkLoginError.PNG


    Problem:

    Currently when you attempt to add a NetworkID for use with a user that has been previously input into the system you will get an object reference error stating an Item with the same key cannot be added.

     

    Solution:

    Find within the database all instances of the NetworkID that are in use with a record or user and modify them to be different than the NetworkID you are attempting to input.

    EXAMPLE: NetworkID testuser would be modified to testuser_deleted so that the new testuser can be added.

     

    The following script can be modified by changing the '%testuser' at the end to to replace the testuser with the desired NetworkID

     

    --This script is to show all instances of a NetworkID associated with a User.

    --This will also list multiple domains using the same NetworkID as well.

    --This will list the user and the associated NetworkID's

     

    select tps_name, tps_network_login

    from tps_user

    join tps_user_network_login on tps_user.tps_guid = tps_user_network_login.tps_user_guid

    where tps_network_login like'%testuser'

     

     

    --Replace testuser with NetworkID that failed.

     

    Additional Information:

    The NetworkID can be set by using the stored procedure from document - How to set Network Logins for your Users automatically which would run on a schedule and could be adding or modifying the Network login details for users nightly.