Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 4 subscribers
  • Views 20464 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 computers in enterprise console

SteveG

Hi

I have noticed a strange behavior in enterprise console when searching for computers it sometimes creates a duplicate computer entry that already exists in the console when importing from AD.

Seems strange this is happening as I would think that the computer names should be unique since the console seems to use them to identify machines and duplicates should not be allowable.

is there a fix for this behaviour?

:7219


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

    Some of the entries do appear to have been ones that were deleted in the past

    Not going into details here - I'd remove the deleted computers from the database and try again to see whether it makes a difference.  

    sqlcmd -E -S .\SOPHOS -d SOPHOS45 -Q "DELETE FROM ComputersAndDeletedComputers WHERE deleted=1"

    (note: .\SOPHOS is the database instance).

    BTW: is this 4.5.0 or 4.5.1? 

    Christian

    :7237
  • 0 in reply to QC
    Does this command also work for the enterprise console 5.2.2? I know the database name is different. I also have duplicated names in the console.
  • 0 in reply to ICTPhotonis

    Hello ICTPhotonis,

    database name has changed, correct, design and logic are for all practical purposes the same. Did you read that manipulating the database directly is unsupported (though over the years I have not yet managed to kill mine this way).

    Christian

Reply
  • 0 in reply to ICTPhotonis

    Hello ICTPhotonis,

    database name has changed, correct, design and logic are for all practical purposes the same. Did you read that manipulating the database directly is unsupported (though over the years I have not yet managed to kill mine this way).

    Christian

Children
No Data
Unfiltered HTML