Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 2 subscribers
  • Views 3280 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

Doubling up on Devices

Weeboo

I decided to try deleting all of our devices from the enterprise console and set Sophos a task of re-finding everything again - hopefully reducing the number of redundant items

However, it is detecting everything twice - we have double the number of items that we had previously

Is this a known issue ?



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

    Hi Weeboo,

    Please check the PurgeDB tool to remove the duplicate entries- Using PurgeDB with Enterprise Console.

    purgedb.exe -category=computers -action=delete -HistoryLengthInDays=30

    To find the list of duplicates in database:-

    sqlcmd -E -S .\sophos -d SOPHOS5** -Q "SELECT name, COUNT(name) as Count FROM ComputersAndDeletedComputers where deleted = 0 GROUP BY name HAVING ( COUNT(name) > 1 )"

    If there is still duplicates for machines then we can follow last option as manual cleanup of computers one by one.

    sqlcmd -E -S .\SOPHOS -d SOPHOS5** -Q "delete from computersanddeletedcomputers where name = 'COMPUTERNAME'"

     

    If you need additional assistance with it, please reach out to our support.

    Regards,

    Gowtham Mani
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.

Reply
  • 0

    Hi Weeboo,

    Please check the PurgeDB tool to remove the duplicate entries- Using PurgeDB with Enterprise Console.

    purgedb.exe -category=computers -action=delete -HistoryLengthInDays=30

    To find the list of duplicates in database:-

    sqlcmd -E -S .\sophos -d SOPHOS5** -Q "SELECT name, COUNT(name) as Count FROM ComputersAndDeletedComputers where deleted = 0 GROUP BY name HAVING ( COUNT(name) > 1 )"

    If there is still duplicates for machines then we can follow last option as manual cleanup of computers one by one.

    sqlcmd -E -S .\SOPHOS -d SOPHOS5** -Q "delete from computersanddeletedcomputers where name = 'COMPUTERNAME'"

     

    If you need additional assistance with it, please reach out to our support.

    Regards,

    Gowtham Mani
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.

Children
No Data
Unfiltered HTML