Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 35 replies
  • Subscribers 1 subscriber
  • Views 149050 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Duplicate PC names in enterprise console

CDC

I've noticed after upgrading the Enterprise Console to version 4.5 and AV to 9.5 that duplicate PC names have started appearing.  This normally happens after a PC's AV has either not upgraded properly or has stopped updating so i've uninstalled and it and then redeployed it down.  One of the PC names will say its connected & managed (although not properly as the 'up to date' colum is blank and you can't deploy any policies down)  whilst the other will be greyed out.

I've tried deleting both entries in the Enterprise Console in an attempt for the AD sync to sort it but they both re-appear again.  Is this a known issue with the 4.5 upgrade?

:4224


This thread was automatically locked due to age.
Parents
  • 0

    Hi

    Here we go – this script creates a temp table, copies the relevant duplicate pc ids into it, and then deletes them from the primary table (note you have to specify ID1 and ID2 so in other words you have to run the delete part of the script twice with the ID1 and ID2). THIS WORKED FOR ME BUT I TAKE NO RESPONSIBILTY FOR IT NOT WORKING FOR YOU. I've sent this to Sophos Support and am waiting for feedback  ..... you have to run parts of the script not the whole script at once. Run the pieces between the --

    --Drop temp_sav table and populate with duplicate names and relevant IDs

    drop table temp_sav

    select n1.id as id1 ,n2.id as id2, n1.name as name1

    into temp_sav

    from computersanddeletedcomputers n1,computersanddeletedcomputers n2

    where n1.id < n2.id

    and n1.name = n2.name

    order by n1.id

    --query to make sure that your temp data and live data is the same amount

    --NOTE !! You have to run it twice with ID1 and ID2

    select name from computersanddeletedcomputers

    where exists (select name1 from temp_sav where id=temp_sav.id1)

    --delete query: NOTE !! You have to run it twice with ID1 and ID2

    delete from computersanddeletedcomputers

    where exists (select name1 from temp_sav where id=temp_sav.id2)

    --the affected row count should match the query above the delete statement

    --drop temp_sav table from DB - ONLY RUN ONCE YOU ARE DONE !!!

    drop table temp_sav

    :4641
Reply
  • 0

    Hi

    Here we go – this script creates a temp table, copies the relevant duplicate pc ids into it, and then deletes them from the primary table (note you have to specify ID1 and ID2 so in other words you have to run the delete part of the script twice with the ID1 and ID2). THIS WORKED FOR ME BUT I TAKE NO RESPONSIBILTY FOR IT NOT WORKING FOR YOU. I've sent this to Sophos Support and am waiting for feedback  ..... you have to run parts of the script not the whole script at once. Run the pieces between the --

    --Drop temp_sav table and populate with duplicate names and relevant IDs

    drop table temp_sav

    select n1.id as id1 ,n2.id as id2, n1.name as name1

    into temp_sav

    from computersanddeletedcomputers n1,computersanddeletedcomputers n2

    where n1.id < n2.id

    and n1.name = n2.name

    order by n1.id

    --query to make sure that your temp data and live data is the same amount

    --NOTE !! You have to run it twice with ID1 and ID2

    select name from computersanddeletedcomputers

    where exists (select name1 from temp_sav where id=temp_sav.id1)

    --delete query: NOTE !! You have to run it twice with ID1 and ID2

    delete from computersanddeletedcomputers

    where exists (select name1 from temp_sav where id=temp_sav.id2)

    --the affected row count should match the query above the delete statement

    --drop temp_sav table from DB - ONLY RUN ONCE YOU ARE DONE !!!

    drop table temp_sav

    :4641
Children
No Data
Unfiltered HTML