home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
gimli.bioss.sari.ac.uk
/
gimli.bioss.sari.ac.uk.zip
/
gimli.bioss.sari.ac.uk
/
pub
/
misc
/
McAfee8.7.Zip
/
ePOPolicyMigration.exe
/
CABFILE
/
1
/
Policy_Upgrade_Script_For_ePO3.6.sql
< prev
next >
Wrap
Text File
|
2009-09-30
|
91KB
|
2,309 lines
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade71To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade71To87]
GO
CREATE PROCEDURE dbo.VSE_Upgrade71To87
(
@PolicySettingsID INT,
@szPlatform NVARCHAR(50)
)
AS
BEGIN
DECLARE @SectionName NVARCHAR(100)
DECLARE @Value NVARCHAR(1024)
/* ----------------------------------------------------------------------------
[General]
ScanProcessesOnEnable = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanProcessesOnEnable', @Value
END
/* ----------------------------------------------------------------------------
[General]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[Trusted-Advanced] [Trusted-Spyware]
DetectPrograms = 1 => DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectPrograms', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPrograms'
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPotentiallyUnwantedApps', @Value
END
/* ----------------------------------------------------------------------------
[Trusted-Advanced] [Trusted-Spyware]
DetectJokes = 1 => DetectJokes=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectJokes', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes'
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes', @Value
END
/* ----------------------------------------------------------------------------
[Untrusted-Advanced] [Untrusted-Spyware]
DetectPrograms = 1 => DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectPrograms', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPrograms'
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPotentiallyUnwantedApps', @Value
END
/* ----------------------------------------------------------------------------
[Untrusted-Advanced] [Untrusted-Spyware]
DetectJokes = 1 => DetectJokes=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectJokes', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes'
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes', @Value
END
/* ----------------------------------------------------------------------------
[Default-Advanced] [Default-Spyware]
DetectPrograms = 1 => DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectPrograms', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPrograms'
SELECT @SectionName = @szPlatform + 'Default-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPotentiallyUnwantedApps', @Value
END
/* ----------------------------------------------------------------------------
[Default-Advanced] [Default-Spyware]
DetectJokes = 1 => DetectJokes=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Advanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'DetectJokes', @Value OUTPUT
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes'
SELECT @SectionName = @szPlatform + 'Default-Spyware'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes', @Value
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[EmailDetection] [EmailDetection]
ExtensionFilterOption (AllFiles) = 0x00000001 => ExtensionMode=1
(Default) = 0x00000002 => ExtensionMode=3
(Specified) = 0x00000004 => ExtensionMode=4
dwDetect (Default + Macros) = 0x00001000 => ExtensionMode=2
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailDetection'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'ExtensionFilterOption', @Value OUTPUT
IF ((convert(int,@Value) & 0x00000001) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionMode', '1'
END
ELSE IF ((convert(int,@Value) & 0x00000002) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionMode', '3'
END
ELSE IF ((convert(int,@Value) & 0x00000004) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionMode', '4'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionMode', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'dwDetect', @Value OUTPUT
IF ((convert(int,@Value) & 0x00001000) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionMode', '2'
END
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'ExtensionFilterOption'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwDetect'
END
/* ----------------------------------------------------------------------------
[EmailAdvanced] [EmailAdvanced]
dwDetectOptions (ProgramHeuristics)= 0x00000008 => dwProgramHeuristicsLevel=1
dwDetectOptions (MacroHeuristics) = 0x00000004 => dwMacroHeuristicsLevel=1
dwDetectOptions (ScanArchive) = 0x00000800 => ScanArchives=1
dwDetectOptions (ScanCompressedEXE)= 0x00000010 => bScanCompressed=1
dwDetectOptions (ScanMIME) = 0x00010000 => ScanMime=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAdvanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'dwDetectOptions', @Value OUTPUT
IF ((convert(int,@Value) & 0x00000008) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwProgramHeuristicsLevel', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwProgramHeuristicsLevel', '0'
END
IF ((convert(int,@Value) & 0x00000004) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwMacroHeuristicsLevel', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwMacroHeuristicsLevel', '0'
END
IF ((convert(int,@Value) & 0x00000800) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanArchives', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanArchives', '0'
END
IF ((convert(int,@Value) & 0x00000010) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bScanCompressed', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bScanCompressed', '0'
END
IF ((convert(int,@Value) & 0x00010000) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanMime', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanMime', '0'
END
-- Don't delete yet, its still needed to convert other settings
--EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwDetectOptions'
END
/* ----------------------------------------------------------------------------
[EmailAdvanced] [Server_EmailAdvanced]
AdvancedFilterOption (ScanBody) = 0x00000008 => ScanMessageBodies=1
AdvancedFilterOption (MultiExtensionScan) = 0x00000010 => MultipleExtensionsHeuristic=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAdvanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'AdvancedFilterOption', @Value OUTPUT
IF ((convert(int,@Value) & 0x00000008) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanMessageBodies', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanMessageBodies', '0'
END
IF ((convert(int,@Value) & 0x00000010) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'MultiExtensionScan', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'MultiExtensionScan', '0'
END
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'AdvancedFilterOption'
END
/* ----------------------------------------------------------------------------
[EmailAdvanced] [EmailSpyware]
dwDetectOptions (DetectPrograms) = 0x00004000 => DetectPotentiallyUnwantedApps=1
dwDetectOptions (DontDetectJokes)= 0x00002000 => !DetectJokes=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAdvanced'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'dwDetectOptions', @Value OUTPUT
SELECT @SectionName = @szPlatform + 'EmailSpyware'
IF ((convert(int,@Value) & 0x00004000) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPotentiallyUnwantedApps', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectPotentiallyUnwantedApps', '0'
END
IF ((convert(int,@Value) & 0x00002000) > 0)
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes', '0'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'DetectJokes', '1'
END
SELECT @SectionName = @szPlatform + 'EmailAdvanced'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwDetectOptions'
END
/* ----------------------------------------------------------------------------
[EmailAction] [EmailAction]
uScanAction => uAction
uSecScanAction => uSecAction
// old actions => // new actions
{ {
ACTION_PROMPT=0, ACTION_CONTINUE=1,
ACTION_MOVE, ACTION_PROMPT,
ACTION_DELETE, ACTION_MOVE,
ACTION_CONTINUE, ACTION_DELETE,
ACTION_CLEAN ACTION_CLEAN,
} }
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAction'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uScanAction', @Value OUTPUT
-- ACTION_PROMPT
IF @Value = 0
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '2'
END
-- ACTION_MOVE
ELSE IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '3'
END
-- ACTION_DELETE
ELSE IF @Value = 2
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
END
-- ACTION_CLEAN
ELSE IF @Value = 4
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '5'
END
-- ACTION_CONTINUE
ELSE IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '0'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecScanAction', @Value OUTPUT
-- ACTION_PROMPT
IF @Value = 0
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '2'
END
-- ACTION_MOVE
ELSE IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '3'
END
-- ACTION_DELETE
ELSE IF @Value = 2
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
-- ACTION_CLEAN
ELSE IF @Value = 4
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '5'
END
-- ACTION_CONTINUE
ELSE IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
ELSE
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '0'
END
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'uScanAction'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecScanAction'
END
/* ----------------------------------------------------------------------------
[EmailAction] [EmailAction]
dwPromptButton => |= 0x00000020 (Delete Mail)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAction'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'dwPromptButton', @Value OUTPUT
SET @Value = CONVERT(INT,@Value) | 0x00000020
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwPromptButton', @Value
END
/* ----------------------------------------------------------------------------
[EmailAction]
-szSecMoveFolder
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAction'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'szSecMoveFolder'
/* ----------------------------------------------------------------------------
[EmailAction]
-dwPromptButton2
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAction'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwPromptButton2'
/* ----------------------------------------------------------------------------
[EmailReport] [EmailReport]
uMaxKilobytes => dwMaxLogSizeMB
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailReport'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uMaxKilobytes', @Value OUTPUT
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwMaxLogSizeMB', @Value
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'uMaxKilobytes'
END
/* ----------------------------------------------------------------------------
[UIOptions]
-dwConsoleRefreshRate
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'UIOptions'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwConsoleRefreshRate'
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[General] [QuarantinePolicy]
szMoveToFolder=\quarantine => szQuarantineDirectory=<SYSTEM_DRIVE>\quarantine
~OR~
szMoveToFolder=C:\quarantine => szQuarantineDirectory=C:\quarantine
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'szMoveToFolder', @Value OUTPUT
SELECT @SectionName = @szPlatform + 'QuarantinePolicy'
IF @Value LIKE '\%'
BEGIN
SELECT @Value = '<SYSTEM_DRIVE>' + @Value
END
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'szQuarantineDirectory', @Value
SELECT @SectionName = @szPlatform + 'General'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'szMoveToFolder'
END
/* ----------------------------------------------------------------------------
[Alerting]
-bMoveFiles
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Alerting'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'bMoveFiles'
END
/* ----------------------------------------------------------------------------
[Reporting]
-bLogUserName
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Reporting'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'bLogUserName'
END
/* ----------------------------------------------------------------------------
[UIPOptions]
UseUTF8=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'UIPOptions'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '1'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'UseUTF8', @Value
END
/* ----------------------------------------------------------------------------
[EmailDetection]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailDetection'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[Alert]
bSendToAlertManagerNetApp = 0
bSendToAlertManagerICAP = 0
bSendToAlertManagerVMODS = 0
bSendToAlertManagerSAP = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Alert'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerNetApp', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerICAP', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerVMODS', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerSAP', @Value
END
END
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade80To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade80To87]
GO
CREATE PROCEDURE dbo.VSE_Upgrade80To87
(
@PolicySettingsID INT,
@szPlatform NVARCHAR(50)
)
AS
BEGIN
DECLARE @SectionName NVARCHAR(100)
DECLARE @Value NVARCHAR(1024)
/* ----------------------------------------------------------------------------
[General]
ScanProcessesOnEnable = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanProcessesOnEnable', @Value
END
/* ----------------------------------------------------------------------------
[General]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[Trusted-Spyware] [Trusted-Spyware]
uAction_Program = 1 => = 7 (Deny)
uAction_Program = 6 => = 1 (Continue)
uSecAction_Program = 1 => = 7 (Deny)
uSecAction_Program = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '1'
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Spyware] [Untrusted-Spyware]
uAction_Program = 1 => = 7 (Deny)
uAction_Program = 6 => = 1 (Continue)
uSecAction_Program = 1 => = 7 (Deny)
uSecAction_Program = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '1'
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 1 => = 7 (Deny)
uAction = 6 => = 1 (Continue)
uSecAction = 1 => = 7 (Deny)
uSecAction = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '1'
END
END
/* ----------------------------------------------------------------------------
[Default-Spyware] [Default-Spyware]
uAction_Program = 1 => = 7 (Deny)
uAction_Program = 6 => = 1 (Continue)
uSecAction_Program = 1 => = 7 (Deny)
uSecAction_Program = 6 => = 1 (Continue)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '1'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 1
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 6
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '1'
END
END
/* ----------------------------------------------------------------------------
[EmailAction] [EmailAction]
dwPromptButton => |= 0x00000020 (Delete Mail)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailAction'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'dwPromptButton', @Value OUTPUT
SET @Value = CONVERT(INT,@Value) | 0x00000020
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwPromptButton', @Value
END
/* ----------------------------------------------------------------------------
[EmailNotes]
+NOTES_OAScanServerDataBases = 0
+NOTES_OAScanServerMail = 1
+NOTES_ServerMailFolder = !!mail\
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailDetection'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @SectionName = @szPlatform + 'EmailNotes'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'NOTES_OAScanServerDataBases', '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'NOTES_OAScanServerMail', '1'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'NOTES_ServerMailFolder', '!!mail\'
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Trusted-Action] [Trusted-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Trusted-Spyware] [Trusted-Spyware]
uAction_Program = 3 (Move) => = 4 (Delete)
uSecAction_Program = 4 (Delete) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '4'
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Trusted-Spyware] [Trusted-Spyware]
uAction_Program = 5 (Clean)
uSecAction_Program = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Trusted-Spyware] [Trusted-Spyware]
uAction_Program = 4 (Delete)
uSecAction_Program = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Trusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Action] [Untrusted-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Spyware] [Untrusted-Spyware]
uAction_Program = 3 (Move) => = 4 (Delete)
uSecAction_Program = 4 (Delete) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '4'
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Spyware] [Untrusted-Spyware]
uAction_Program = 5 (Clean)
uSecAction_Program = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Untrusted-Spyware] [Untrusted-Spyware]
uAction_Program = 4 (Delete)
uSecAction_Program = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Untrusted-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 3 (Move) => = 4 (Delete)
uSecAction => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction', '4'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 5 (Clean)
uSecAction = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Action] [Default-Action]
uAction = 4 (Delete)
uSecAction = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Action'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Spyware] [Default-Spyware]
uAction_Program = 3 (Move) => = 4 (Delete)
uSecAction_Program = 4 (Delete) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uAction_Program', '4'
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Spyware] [Default-Spyware]
uAction_Program = 5 (Clean)
uSecAction_Program = 3 (Move) => = 4 (Delete)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 5
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '4'
END
END
END
/* ----------------------------------------------------------------------------
[Default-Spyware] [Default-Spyware]
uAction_Program = 4 (Delete)
uSecAction_Program = 3 (Move) => = 7 (Deny)
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Default-Spyware'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uAction_Program', @Value OUTPUT
IF @Value = 4
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'uSecAction_Program', @Value OUTPUT
IF @Value = 3
BEGIN
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'uSecAction_Program', '7'
END
END
END
/* ----------------------------------------------------------------------------
[General] [QuarantinePolicy]
szMoveToFolder=\quarantine => szQuarantineDirectory=<SYSTEM_DRIVE>\quarantine
~OR~
szMoveToFolder=C:\quarantine => szQuarantineDirectory=C:\quarantine
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @SectionName, 'szMoveToFolder', @Value OUTPUT
SELECT @SectionName = @szPlatform + 'QuarantinePolicy'
IF @Value LIKE '\%'
BEGIN
SELECT @Value = '<SYSTEM_DRIVE>' + @Value
END
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'szQuarantineDirectory', @Value
SELECT @SectionName = @szPlatform + 'General'
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'szMoveToFolder'
END
/* ----------------------------------------------------------------------------
[Alerting]
-bMoveFiles
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Alerting'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'bMoveFiles'
END
/* ----------------------------------------------------------------------------
[Reporting]
-bLogUserName
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Reporting'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
EXEC EPOPolicy_DeletePolicySettingValue 0, @PolicySettingsID, @SectionName, 'bLogUserName'
END
/* ----------------------------------------------------------------------------
[UIPOptions]
UseUTF8=1
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'UIPOptions'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '1'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'UseUTF8', @Value
END
/* ----------------------------------------------------------------------------
[EntExclItems]
EnterceptExclusionModule_
EnterceptExclusionAPI_ => EnterceptExclusionModule_.EnterceptExclusionAPI_
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EntExclItems'
DECLARE @BOPExclusionCursor CURSOR;
SET @BOPExclusionCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT SectionName, SettingName
FROM EPOPolicySettingValues
WHERE PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName
AND SettingName LIKE 'EnterceptExclusionProcess_%'
OPEN @BOPExclusionCursor;
DECLARE @PolicySectionName NVARCHAR(256)
DECLARE @PolicySettingName NVARCHAR(256)
DECLARE @PolicySettingValue NVARCHAR(1024)
DECLARE @PolicySettingValueCount NVARCHAR(10)
FETCH NEXT FROM @BOPExclusionCursor INTO @PolicySectionName, @PolicySettingName;
WHILE (@@FETCH_STATUS = 0)
BEGIN
SELECT @PolicySettingValue = ''
SELECT @Value = ''
SELECT @PolicySettingValueCount = RIGHT (@PolicySettingName, LEN(@PolicySettingName) - CHARINDEX('_',@PolicySettingName))
SELECT @PolicySettingName = 'EnterceptExclusionModule_' + @PolicySettingValueCount
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @PolicySectionName, @PolicySettingName, @PolicySettingValue OUTPUT
SELECT @PolicySettingName = 'EnterceptExclusionAPI_' + @PolicySettingValueCount
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @PolicySectionName, @PolicySettingName, @Value OUTPUT
IF @PolicySettingValue = ''
OR @PolicySettingValue IS NULL
BEGIN
SELECT @PolicySettingValue = '*'
END
IF @Value = ''
OR @Value IS NULL
BEGIN
SELECT @Value = '*'
END
SELECT @PolicySettingValue = @PolicySettingValue + '.' + @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, @PolicySettingName, @PolicySettingValue
FETCH NEXT FROM @BOPExclusionCursor INTO @PolicySectionName, @PolicySettingName;
END
CLOSE @BOPExclusionCursor;
DEALLOCATE @BOPExclusionCursor;
/* ----------------------------------------------------------------------------
[EntExclItems]
-EnterceptExclusionModule_
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EntExclItems'
DELETE FROM EPOPolicySettingValues
WHERE PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName
AND SettingName LIKE 'EnterceptExclusionModule_%'
/* ----------------------------------------------------------------------------
[EmailDetection]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailDetection'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[Alert]
bSendToAlertManagerNetApp = 0
bSendToAlertManagerICAP = 0
bSendToAlertManagerVMODS = 0
bSendToAlertManagerSAP = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Alert'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerNetApp', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerICAP', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerVMODS', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerSAP', @Value
END
END
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade85To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade85To87]
GO
CREATE PROCEDURE dbo.VSE_Upgrade85To87
(
@PolicySettingsID INT,
@szPlatform NVARCHAR(50)
)
AS
BEGIN
DECLARE @SectionName NVARCHAR(100)
DECLARE @Value NVARCHAR(1024)
/* ----------------------------------------------------------------------------
[General]
ScanProcessesOnEnable = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'ScanProcessesOnEnable', @Value
END
/* ----------------------------------------------------------------------------
[General]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'General'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[EntExclItems]
EnterceptExclusionModule_
EnterceptExclusionAPI_ => EnterceptExclusionModule_.EnterceptExclusionAPI_
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EntExclItems'
DECLARE @BOPExclusionCursor CURSOR;
SET @BOPExclusionCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT SectionName, SettingName
FROM EPOPolicySettingValues
WHERE PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName
AND SettingName LIKE 'EnterceptExclusionProcess_%'
OPEN @BOPExclusionCursor;
DECLARE @PolicySectionName NVARCHAR(256)
DECLARE @PolicySettingName NVARCHAR(256)
DECLARE @PolicySettingValue NVARCHAR(1024)
DECLARE @PolicySettingValueCount NVARCHAR(10)
FETCH NEXT FROM @BOPExclusionCursor INTO @PolicySectionName, @PolicySettingName;
WHILE (@@FETCH_STATUS = 0)
BEGIN
SELECT @PolicySettingValue = ''
SELECT @Value = ''
SELECT @PolicySettingValueCount = RIGHT (@PolicySettingName, LEN(@PolicySettingName) - CHARINDEX('_',@PolicySettingName))
SELECT @PolicySettingName = 'EnterceptExclusionModule_' + @PolicySettingValueCount
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @PolicySectionName, @PolicySettingName, @PolicySettingValue OUTPUT
SELECT @PolicySettingName = 'EnterceptExclusionAPI_' + @PolicySettingValueCount
EXEC EPOPolicy_GetPolicySettingValue @PolicySettingsID, @PolicySectionName, @PolicySettingName, @Value OUTPUT
IF @PolicySettingValue = ''
OR @PolicySettingValue IS NULL
BEGIN
SELECT @PolicySettingValue = '*'
END
IF @Value = ''
OR @Value IS NULL
BEGIN
SELECT @Value = '*'
END
SELECT @PolicySettingValue = @PolicySettingValue + '.' + @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, @PolicySettingName, @PolicySettingValue
FETCH NEXT FROM @BOPExclusionCursor INTO @PolicySectionName, @PolicySettingName;
END
CLOSE @BOPExclusionCursor;
DEALLOCATE @BOPExclusionCursor;
/* ----------------------------------------------------------------------------
[EmailDetection]
dwHeuristicNetCheckSensitivity = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'EmailDetection'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'dwHeuristicNetCheckSensitivity', @Value
END
/* ----------------------------------------------------------------------------
[Alert]
bSendToAlertManagerNetApp = 0
bSendToAlertManagerICAP = 0
bSendToAlertManagerVMODS = 0
bSendToAlertManagerSAP = 0
---------------------------------------------------------------------------- */
SELECT @SectionName = @szPlatform + 'Alert'
IF EXISTS(SELECT *
FROM EPOPolicySettingValues
WHERE EPOPolicySettingValues.PolicySettingsID = @PolicySettingsID
AND SectionName = @SectionName)
BEGIN
SELECT @Value = '0'
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerNetApp', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerICAP', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerVMODS', @Value
EXEC EPOPolicy_SetPolicySettingValue 0, @PolicySettingsID, @SectionName, 'bSendToAlertManagerSAP', @Value
END
END
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_UpgradeEnforce]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_UpgradeEnforce]
GO
CREATE PROCEDURE dbo.VSE_UpgradeEnforce
(
@PolicySettingsID INT,
@PolicySettingsTypeID NVARCHAR(256),
@NewFeatureTextID NVARCHAR(50)
)
AS
BEGIN
DECLARE @PolicyObjectID INT
SELECT @PolicyObjectID = EPOPolicyObjectToSettings.PolicyObjectID
FROM EPOPolicyObjectToSettings
WHERE EPOPolicyObjectToSettings.PolicySettingsID = @PolicySettingsID
DECLARE @TypeTextID NVARCHAR(256)
SELECT @TypeTextID = EPOPolicyTypes.TypeTextID
FROM EPOPolicyTypes
WHERE EPOPolicyTypes.TypeID = @PolicySettingsTypeID
DECLARE @NewTypeID INT
SELECT @NewTypeID = EPOPolicyTypes.TypeID
FROM EPOPolicyTypes
WHERE EPOPolicyTypes.TypeTextID = @TypeTextID
AND EPOPolicyTypes.FeatureTextID = @NewFeatureTextID
DECLARE @PolicyObjectName NVARCHAR(256)
SELECT @PolicyObjectName = EPOPolicyObjects.Name
FROM EPOPolicyObjects
WHERE EPOPolicyObjects.PolicyObjectID = @PolicyObjectID
DECLARE @NewPolicyObjectID INT
SELECT @NewPolicyObjectID = EPOPolicyObjects.PolicyObjectID
FROM EPOPolicyObjects
WHERE EPOPolicyObjects.TypeID = @NewTypeID
AND EPOPolicyObjects.Name = @PolicyObjectName
DECLARE @SlotID INT
SELECT @SlotID = 0
SELECT @SlotID = EPOPolicyAssignment.SlotID
FROM EPOPolicyTypes, EPOPolicyObjects, EPOPolicyAssignment
WHERE EPOPolicyTypes.TypeID = @NewTypeID
AND EPOPolicyObjects.TypeID = EPOPolicyTypes.TypeID
AND EPOPolicyAssignment.PolicyObjectID = EPOPolicyObjects.PolicyObjectID
IF (@SlotID > 0)
BEGIN
DECLARE @AssignmentCursor CURSOR;
SET @AssignmentCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT EPOPolicyAssignment.NodeID, EPOPolicyAssignment.NodeType, EPOPolicyAssignment.ForceInheritance, EPOPolicyAssignment.Hidden, EPOPolicyAssignment.TheTimestamp, EPOPolicyAssignment.TheHiddenTimestamp
FROM EPOPolicyAssignment
WHERE EPOPolicyAssignment.PolicyObjectID = @PolicyObjectID;
OPEN @AssignmentCursor;
DECLARE @NodeID INT
DECLARE @NodeType INT
DECLARE @ForceInheritance INT
DECLARE @Hidden INT
DECLARE @TheTimestamp INT
DECLARE @TheHiddenTimestamp INT
DECLARE @NewAssignmentID INT
FETCH NEXT FROM @AssignmentCursor INTO @NodeID, @NodeType, @ForceInheritance, @Hidden, @TheTimestamp, @TheHiddenTimestamp;
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXECUTE EPOPolicy_AssignPolicyToNode 0, @NewPolicyObjectID, @NodeID, @NodeType, @SlotID, @ForceInheritance, @Hidden, @NewAssignmentID
FETCH NEXT FROM @AssignmentCursor INTO @NodeID, @NodeType, @ForceInheritance, @Hidden, @TheTimestamp, @TheHiddenTimestamp;
END
END
CLOSE @AssignmentCursor;
DEALLOCATE @AssignmentCursor;
END
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_UpgradePolicy]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_UpgradePolicy]
GO
CREATE PROCEDURE dbo.VSE_UpgradePolicy
(
@PolicySettingsID INT,
@PolicySettingsName NVARCHAR(256),
@PolicySettingsTypeID NVARCHAR(256),
@ProductCode NVARCHAR(50),
@NewFeatureTextID NVARCHAR(50)
)
AS
BEGIN
DECLARE @TypeTextID NVARCHAR(256)
SELECT @TypeTextID = EPOPolicyTypes.TypeTextID
FROM EPOPolicyTypes
WHERE EPOPolicyTypes.TypeID = @PolicySettingsTypeID;
IF NOT EXISTS (SELECT EPOPolicyObjects.Name
FROM EPOPolicyObjects, EPOPolicyTypes
WHERE EPOPolicyObjects.Name = @PolicySettingsName
AND EPOPolicyObjects.TypeID = EPOPolicyTypes.TypeID
AND EPOPolicyTypes.FeatureTextID = @NewFeatureTextID
AND EPOPolicyTypes.TypeTextID = @TypeTextID)
BEGIN
DECLARE @PolicyObjectID INT
SELECT @PolicyObjectID = EPOPolicyObjectToSettings.PolicyObjectID
FROM EPOPolicyObjectToSettings
WHERE EPOPolicyObjectToSettings.PolicySettingsID = @PolicySettingsID
DECLARE @UserID INT
SELECT @UserID = 0
SELECT @UserID = UserID
FROM EPOPolicyObjectUserRoles
WHERE EPOPolicyObjectUserRoles.PolicyObjectID = @PolicyObjectID
AND EPOPolicyObjectUserRoles.ACFlags = 1
DECLARE @NewTypeID INT
SELECT @NewTypeID = 0
SELECT @NewTypeID = EPOPolicyTypes.TypeID
FROM EPOPolicyTypes
WHERE EPOPolicyTypes.TypeTextID = @TypeTextID
AND EPOPolicyTypes.FeatureTextID = @NewFeatureTextID
IF (@NewTypeID > 0)
BEGIN
DECLARE @NewPolicyObjectID INT
DECLARE @NewPolicySettingsName NVARCHAR(256)
SELECT @NewPolicySettingsName = @PolicySettingsName + '(vse8.7)'
EXECUTE EPOPolicy_CopyPolicyObject 0, @PolicyObjectID, @NewPolicySettingsName, @UserID, 1, @NewPolicyObjectID OUTPUT
UPDATE EPOPolicyObjects
SET TypeID = @NewTypeID
WHERE PolicyObjectID = @NewPolicyObjectID
UPDATE EPOPolicyObjects
SET Name = @PolicySettingsName
WHERE PolicyObjectID = @NewPolicyObjectID
DECLARE @NewPolicySettingsID INT
SELECT @NewPolicySettingsID = EPOPolicyObjectToSettings.PolicySettingsID
FROM EPOPolicyObjectToSettings
WHERE EPOPolicyObjectToSettings.PolicyObjectID = @NewPolicyObjectID
UPDATE EPOPolicySettings
SET TypeID = @NewTypeID
WHERE PolicySettingsID = @NewPolicySettingsID
IF @ProductCode = 'VIRUSCAN8600'
BEGIN
EXECUTE VSE_Upgrade85To87 @NewPolicySettingsID, 'Server_'
EXECUTE VSE_Upgrade85To87 @NewPolicySettingsID, 'Wrkstn_'
END
ELSE IF @ProductCode = 'VIRUSCAN8000'
BEGIN
EXECUTE VSE_Upgrade80To87 @NewPolicySettingsID, 'Server_'
EXECUTE VSE_Upgrade80To87 @NewPolicySettingsID, 'Wrkstn_'
END
ELSE IF @ProductCode = 'VIRUSCAN7100'
BEGIN
EXECUTE VSE_Upgrade71To87 @NewPolicySettingsID, 'Server_'
EXECUTE VSE_Upgrade71To87 @NewPolicySettingsID, 'Wrkstn_'
END
DECLARE @SlotID INT
SELECT @SlotID = 0
SELECT @SlotID = EPOPolicyAssignment.SlotID
FROM EPOPolicyTypes, EPOPolicyObjects, EPOPolicyAssignment
WHERE EPOPolicyTypes.TypeID = @NewTypeID
AND EPOPolicyObjects.TypeID = EPOPolicyTypes.TypeID
AND EPOPolicyAssignment.PolicyObjectID = EPOPolicyObjects.PolicyObjectID
IF (@SlotID > 0)
BEGIN
DECLARE @AssignmentCursor CURSOR;
SET @AssignmentCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT EPOPolicyAssignment.NodeID, EPOPolicyAssignment.NodeType, EPOPolicyAssignment.ForceInheritance, EPOPolicyAssignment.Hidden, EPOPolicyAssignment.TheTimestamp, EPOPolicyAssignment.TheHiddenTimestamp
FROM EPOPolicyAssignment
WHERE EPOPolicyAssignment.PolicyObjectID = @PolicyObjectID;
OPEN @AssignmentCursor;
DECLARE @NodeID INT
DECLARE @NodeType INT
DECLARE @ForceInheritance INT
DECLARE @Hidden INT
DECLARE @TheTimestamp INT
DECLARE @TheHiddenTimestamp INT
DECLARE @NewAssignmentID INT
FETCH NEXT FROM @AssignmentCursor INTO @NodeID, @NodeType, @ForceInheritance, @Hidden, @TheTimestamp, @TheHiddenTimestamp;
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXECUTE EPOPolicy_AssignPolicyToNode 0, @NewPolicyObjectID, @NodeID, @NodeType, @SlotID, @ForceInheritance, @Hidden, @NewAssignmentID
FETCH NEXT FROM @AssignmentCursor INTO @NodeID, @NodeType, @ForceInheritance, @Hidden, @TheTimestamp, @TheHiddenTimestamp;
END
CLOSE @AssignmentCursor;
DEALLOCATE @AssignmentCursor;
END
END
END
END
GO
IF EXISTS (SELECT ePOVersion FROM ServerInfo WHERE ePOVersion > '3.5.0')
BEGIN
DECLARE @ProductCode NVARCHAR(30)
DECLARE @DoNotForce80 NVARCHAR(30)
DECLARE @DoNotForce71 NVARCHAR(30)
DECLARE @DoNotForce NVARCHAR(30)
SELECT @ProductCode = ''
SELECT @DoNotForce80 = 'DO_NOT_FORCE_80'
SELECT @DoNotForce71 = 'DO_NOT_FORCE_71'
SELECT @DoNotForce = 'DO_NOT_FORCE_%'
IF @DoNotForce80 LIKE @DoNotForce
BEGIN
IF @DoNotForce71 LIKE @DoNotForce
BEGIN
IF EXISTS (SELECT * FROM EPOPolicyTypes
WHERE FeatureTextID = 'VIRUSCAN8600')
BEGIN
SELECT @ProductCode = 'VIRUSCAN8600'
END
ELSE IF EXISTS (SELECT * FROM EPOPolicyTypes
WHERE FeatureTextID = 'VIRUSCAN8000')
BEGIN
SELECT @ProductCode = 'VIRUSCAN8000'
END
ELSE IF EXISTS (SELECT * FROM EPOPolicyTypes
WHERE FeatureTextID = 'VIRUSCAN7100')
BEGIN
SELECT @ProductCode = 'VIRUSCAN7100'
END
END
ELSE
BEGIN
IF EXISTS (SELECT * FROM EPOPolicyTypes
WHERE FeatureTextID = 'VIRUSCAN7100')
BEGIN
SELECT @ProductCode = 'VIRUSCAN7100'
END
END
END
ELSE
BEGIN
IF EXISTS (SELECT * FROM EPOPolicyTypes
WHERE FeatureTextID = 'VIRUSCAN8000')
BEGIN
SELECT @ProductCode = 'VIRUSCAN8000'
END
END
IF @ProductCode <> ''
BEGIN
DECLARE @PolicyCursor CURSOR;
SET @PolicyCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT EPOPolicySettings.PolicySettingsID, EPOPolicyObjects.Name, EPOPolicySettings.TypeID
FROM EPOPolicyProductToTypes, EPOPolicySettings, EPOPolicyObjects, EPOPolicyObjectToSettings
WHERE EPOPolicyProductToTypes.TypeID = EPOPolicySettings.TypeID
AND EPOPolicyProductToTypes.TypeID = EPOPolicyObjects.TypeID
AND EPOPolicyObjectToSettings.PolicySettingsID = EPOPolicySettings.PolicySettingsID
AND EPOPolicyObjectToSettings.PolicyObjectID = EPOPolicyObjects.PolicyObjectID
AND EPOPolicyProductToTypes.ProductCode = @ProductCode
AND EPOPolicyProductToTypes.EditURL != 'dummy.htm'
AND EPOPolicyObjects.Name != 'McAfee Default';
OPEN @PolicyCursor;
DECLARE @PolicySettingsID INT
DECLARE @PolicySettingsName NVARCHAR(256)
DECLARE @PolicySettingsTypeID NVARCHAR(256)
FETCH NEXT FROM @PolicyCursor INTO @PolicySettingsID, @PolicySettingsName, @PolicySettingsTypeID;
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXECUTE VSE_UpgradePolicy @PolicySettingsID, @PolicySettingsName, @PolicySettingsTypeID, @ProductCode, 'VIRUSCAN8700'
FETCH NEXT FROM @PolicyCursor INTO @PolicySettingsID, @PolicySettingsName, @PolicySettingsTypeID;
END
CLOSE @PolicyCursor;
DEALLOCATE @PolicyCursor;
DECLARE @EnforceCursor CURSOR;
SET @EnforceCursor = CURSOR FORWARD_ONLY READ_ONLY FOR
SELECT EPOPolicySettings.PolicySettingsID, EPOPolicySettings.TypeID
FROM EPOPolicyProductToTypes, EPOPolicySettings, EPOPolicyObjects, EPOPolicyObjectToSettings
WHERE EPOPolicyProductToTypes.TypeID = EPOPolicySettings.TypeID
AND EPOPolicyProductToTypes.TypeID = EPOPolicyObjects.TypeID
AND EPOPolicyObjectToSettings.PolicySettingsID = EPOPolicySettings.PolicySettingsID
AND EPOPolicyObjectToSettings.PolicyObjectID = EPOPolicyObjects.PolicyObjectID
AND EPOPolicyProductToTypes.ProductCode = @ProductCode
AND EPOPolicyProductToTypes.EditURL = 'dummy.htm'
AND EPOPolicyObjects.Name != 'McAfee Default';
OPEN @EnforceCursor;
FETCH NEXT FROM @EnforceCursor INTO @PolicySettingsID, @PolicySettingsTypeID;
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXECUTE VSE_UpgradeEnforce @PolicySettingsID, @PolicySettingsTypeID, 'VIRUSCAN8700'
FETCH NEXT FROM @EnforceCursor INTO @PolicySettingsID, @PolicySettingsTypeID;
END
CLOSE @EnforceCursor;
DEALLOCATE @EnforceCursor;
END
END
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_UpgradePolicy]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_UpgradePolicy]
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_UpgradeEnforce]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_UpgradeEnforce]
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade85To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade85To87]
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade80To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade80To87]
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[VSE_Upgrade71To87]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[VSE_Upgrade71To87]
GO