Looks like this error can't be cleared - doesn't show in the Acknowledge alerts and errors. And no article for it is available.
Christian
This thread was automatically locked due to age.
Hi again,
"Hi (how should I address you)," I go by Ian.
Unfortunately, I feel your pain on the cryptic hex errors. My personal favorite are the event decode errors.
As for the cleanup, I came by a script to purge update errors, but it also purges SAV and SCF.
This script is for EC3.1 (db name Sophos3 etc...). Haven't had the need to use it on EC4.
Be sure to replace ####InstanceName### with the appropriate database instance name.
And of course, use at your own risk etc..., I wouldn't normally share a script that modifies a database, but I can see that you know what you are doing.
Begin script:
cls
@echo off
Echo.
echo This program will purge all false update alert data from the database.
echo Please wait for this script to complete before opening up the console.
echo.
pause
cls
REM clearing the main database
REM clear autoupdate, SAV, SCF errors
osql -E -S ##InstanceName### -d sophos3 -Q "delete from errors where source = 'ALC'"
REM Reseting console status
REM Clears SAV errors status from machine information
osql -S ##InstanceName### -E -d SOPHOS3 -Q "update ComputersAndDeletedComputers set LastAUErrorAlert = null"
:Enddatabasecorrection
cls
@echo off
echo The script has now completed clearing Sau alerts database
echo.
pause
goto exit
:exit
-ian
Hi again,
"Hi (how should I address you)," I go by Ian.
Unfortunately, I feel your pain on the cryptic hex errors. My personal favorite are the event decode errors.
As for the cleanup, I came by a script to purge update errors, but it also purges SAV and SCF.
This script is for EC3.1 (db name Sophos3 etc...). Haven't had the need to use it on EC4.
Be sure to replace ####InstanceName### with the appropriate database instance name.
And of course, use at your own risk etc..., I wouldn't normally share a script that modifies a database, but I can see that you know what you are doing.
Begin script:
cls
@echo off
Echo.
echo This program will purge all false update alert data from the database.
echo Please wait for this script to complete before opening up the console.
echo.
pause
cls
REM clearing the main database
REM clear autoupdate, SAV, SCF errors
osql -E -S ##InstanceName### -d sophos3 -Q "delete from errors where source = 'ALC'"
REM Reseting console status
REM Clears SAV errors status from machine information
osql -S ##InstanceName### -E -d SOPHOS3 -Q "update ComputersAndDeletedComputers set LastAUErrorAlert = null"
:Enddatabasecorrection
cls
@echo off
echo The script has now completed clearing Sau alerts database
echo.
pause
goto exit
:exit
-ian