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

SQL script to purge disconnected computers

Smile

Hello,

Does someone have a short  SQL script to purge disconnected computers from the Sophos Enterprise database.

Since we upgraded tot SEC51 and placed the database on an external SQL server, the purgedb tool  is useless. We used the parameters : PurgeDB.exe -action=delete -category=computers -HistoryLengthInDays=60

Regards

:47589


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

    Hello Jak,

    Thank you for your help and information. Mine was somewhat limited. I realise that.

    The registry string is the right one. Today I adjusted  the user rights which I use for the purge.

    (I use an AD service account)

    At this moment, If I run the purgedb_sophos.cmd file manually the computers are deleted.

    If I use the Windows scheduled task to run the cmd file, it is not deleting any computers.

    I will troubleshoot this further.

    The SQL query ‘‘‘‘s you provided are always handy and nice to have.

    Regards

    Smile.

    :47689
Reply
  • 0

    Hello Jak,

    Thank you for your help and information. Mine was somewhat limited. I realise that.

    The registry string is the right one. Today I adjusted  the user rights which I use for the purge.

    (I use an AD service account)

    At this moment, If I run the purgedb_sophos.cmd file manually the computers are deleted.

    If I use the Windows scheduled task to run the cmd file, it is not deleting any computers.

    I will troubleshoot this further.

    The SQL query ‘‘‘‘s you provided are always handy and nice to have.

    Regards

    Smile.

    :47689
Children
No Data