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

Please Help in regards to EPSEC 4.0

Hi Team, I need on the below queries Maximum capacity of quarantine zone is 200 items can we increase it???? When event errors for any node reaches more than 1000 then it throws a specific transient error while trying to open the status window of that node from the console. For example :; If a desktop is badly infected with sality and we have installed Sophos AV it detects 1000+ virus but when we open it at the client end error like the no. of item on this page is maximum than the quarantine manager can display Quarantine manager has started discarding the older items. It opens but ask you to clean only the first 200 at a time and when we try to open the same machine on EPSEC 4 Console the machine almost die and process very slow. Also i want to know whether we can change the database as currently i am using the SQL express for EPSEC and want to shift it to SQL 2005 for more mangement Regards Baig Firoz
:1912


This thread was automatically locked due to age.
Parents
  • The command is missing an instance. It should have .\sophos rather than just a full stop so it would be:
    osql -E -S .\sophos -d SOPHOS4 -Q "DELETE FROM Threats WHERE FirstDetectedAt<'yyyy-mm-dd 00:00:00.00' and Outstanding=0 and ComputerID=(SELECT ID FROM ComputersAndDeletedComputers WHERE NAME='cccccccc')"

    Cheers
    Paul

Reply
  • The command is missing an instance. It should have .\sophos rather than just a full stop so it would be:
    osql -E -S .\sophos -d SOPHOS4 -Q "DELETE FROM Threats WHERE FirstDetectedAt<'yyyy-mm-dd 00:00:00.00' and Outstanding=0 and ComputerID=(SELECT ID FROM ComputersAndDeletedComputers WHERE NAME='cccccccc')"

    Cheers
    Paul

Children
No Data