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/71To87_Policy_Upgrade_Script.sql

Text File | 2007-10-05 | 97KB | 3,031 lines

-------------------------------------------------------------------------------

------------  V S E  7 . 1  T O  8 . 7  P O L I C Y  U P G R A D E  -----------

-------------------------------------------------------------------------------

if exists (select * from tempdb..sysobjects where name like '#VirusScanPolicyIDs%')
drop table #VirusScanPolicyIDs
go

/* ----------------------------------------------------------------------------
Copy over 7.1.0 policies to 8.7.0 policies only if non global 8.0.0, 8.5.0 and
8.7.0 policies don't exist.
---------------------------------------------------------------------------- */
if not exists (select * from PolicySettings, Policy
    where PolicySettings.ParentID = Policy.AutoID
        and ProductCode = 'VIRUSCAN8000' and parentType != 7)
    and not exists (select * from PolicySettings, Policy
        where PolicySettings.ParentID = Policy.AutoID
            and ProductCode = 'VIRUSCAN8600' and parentType != 7)
    and not exists (select * from PolicySettings, Policy
        where PolicySettings.ParentID = Policy.AutoID
            and ProductCode = 'VIRUSCAN8700' and parentType != 7)
begin

/* ----------------------------------------------------------------------------
Copy all non global policy table 7.1.0 policies to 8.7.0 policies.
---------------------------------------------------------------------------- */
insert Policy
(ParentID, ParentType, ProductCode)
select ParentID, ParentType, 'VIRUSCAN8700'
from Policy
where
Policy.ProductCode = 'VIRUSCAN7100'
and Policy.ParentType in (6, 5, 4, 3, 1)

/* ----------------------------------------------------------------------------
Get policy.autoids of all 7.1.0 and 8.7.0 policies.
---------------------------------------------------------------------------- */
select a.AutoID as AutoID2, b.AutoID as AutoID3
into #VirusScanPolicyIDs
from Policy a, Policy b
where
a.ProductCode = 'VIRUSCAN7100'
and b.ProductCode = 'VIRUSCAN8700'
and a.ParentType = b.ParentType
and a.ParentID = b.ParentID
and a.ParentType in (6, 5, 4, 3, 1)

/* ----------------------------------------------------------------------------
Copy all non global PolicySetting from 7.1.0 policy settings to 8.7.0 policy
settings.
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, SectionName, SettingName, Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2

/* ----------------------------------------------------------------------------
 Change the SectionName and/or the SettingName of the policies that have moved.
 A "-" sign indicates that the value is no longer used and is to be deleted only.

OLD VALUE:                                                        NEW VALUE:
[Trusted-Advanced]                                                [Trusted-Spyware]
DetectPrograms                                = 1                =>    DetectPotentiallyUnwantedApps=1
DetectJokes                                    = 1                =>    DetectJokes=1

[Untrusted-Advanced]                                            [Untrusted-Spyware]
DetectPrograms                                = 1                =>    DetectPotentiallyUnwantedApps=1
DetectJokes                                    = 1                =>    DetectJokes=1

[Default-Advanced]                                                [Default-Spyware]
DetectPrograms                                = 1                =>    DetectPotentiallyUnwantedApps=1
DetectJokes                                    = 1                =>    DetectJokes=1

[Trusted-Action]                                                [Trusted-Action]
uAction                                        = 1                =>  = 7 (Deny)
uAction                                        = 6                =>  = 1 (Continue)
uSecAction                                    = 1                =>  = 7 (Deny)
uSecAction                                    = 6                =>  = 1 (Continue)

[Untrusted-Action]                                                [Untrusted-Action]
uAction                                        = 1                =>  = 7 (Deny)
uAction                                        = 6                =>  = 1 (Continue)
uSecAction                                    = 1                =>  = 7 (Deny)
uSecAction                                    = 6                =>  = 1 (Continue)

[Default-Action]                                                [Default-Action]
uAction                                        = 1                =>  = 7 (Deny)
uAction                                        = 6                =>  = 1 (Continue)
uSecAction                                    = 1                =>  = 7 (Deny)
uSecAction                                    = 6                =>  = 1 (Continue)

TODO:
[Trusted-Advanced]
-bScanCompressed???                                                None

[Untrusted-Advanced]
-bScanCompressed???                                                None

[Default-Advanced]
-bScanCompressed???                                                None

[EmailDetection]                                                [EmailDetection]
ExtensionFilterOption (AllFiles)             = 0x00000001     =>     ExtensionMode=1
                      (Default)             = 0x00000002     =>    ExtensionMode=3
                      (Specified)            = 0x00000004     =>    ExtensionMode=4

dwDetect (Default + Macros)                    = 0x00001000     =>    ExtensionMode=2

[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

AdvancedFilterOption (ScanBody)                = 0x00000008    =>    ScanMessageBodies=1
AdvancedFilterOption (MultiExtensionScan)    = 0x00000010    =>    MultipleExtensionsHeuristic

[EmailAdvanced]                                                    [EmailSpyware]
dwDetectOptions    (DontDetectJokes)            = 0x00002000    =>    !DetectJokes=1
dwDetectOptions    (DetectPrograms)            = 0x00004000    =>    DetectPotentiallyUnwantedApps=1

[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,
                                            }                    }

dwPromptButton                                                =>    |= 0x00000020 (Delete Mail)

-szSecMoveFolder                                                None
-dwPromptButton2                                                None

[EmailReport]                                                    [EmailReport]
uMaxKilobytes                                                =>    dwMaxLogSizeMB

[UIOptions]
-dwConsoleRefreshRate                                            None

[Trusted-Action]                                                [Trusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)

[Trusted-Action]                                                [Trusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)

[Trusted-Action]                                                [Trusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)

[Untrusted-Action]                                                [Untrusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)

[Untrusted-Action]                                                [Untrusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)

[Untrusted-Action]                                                [Untrusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)

[Default-Action]                                                [Default-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)

[Default-Action]                                                [Default-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)

[Default-Action]                                                [Default-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)

[General]                                                        [QuarantinePolicy]
szMoveToFolder=\quarantine                                    =>    szQuarantineDirectory=<SYSTEM_DRIVE>\quarantine
 ~OR~
szMoveToFolder=C:\quarantine                                =>    szQuarantineDirectory=C:\quarantine

[Alerting]
-bMoveFiles

[Reporting]
-bLogUserName

[UIPOptions]
UseUTF8=0
----------------------------------------------------------------------------- */

/* ----------------------------------------------------------------------------
[Server_Trusted-Advanced]                            [Server_Trusted-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Trusted-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Trusted-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Trusted-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Advanced]                            [Wrkstn_Trusted-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Trusted-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Trusted-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Trusted-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Trusted-Advanced]                            [Server_Trusted-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Trusted-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Trusted-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Trusted-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Advanced]                            [Wrkstn_Trusted-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Trusted-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Trusted-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Trusted-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Untrusted-Advanced]                            [Server_Untrusted-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Untrusted-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Untrusted-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Untrusted-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Advanced]                            [Wrkstn_Untrusted-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Untrusted-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Untrusted-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Untrusted-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Untrusted-Advanced]                            [Server_Untrusted-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Untrusted-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Untrusted-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Untrusted-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Advanced]                            [Wrkstn_Untrusted-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Untrusted-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Untrusted-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Untrusted-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Default-Advanced]                            [Server_Default-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Default-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Default-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Default-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Advanced]                            [Wrkstn_Default-Spyware]
DetectPrograms                    = 1                =>    DetectPotentiallyUnwantedApps=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Default-Spyware', 'DetectPotentiallyUnwantedApps', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Default-Advanced'
and SettingName = 'DetectPrograms'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Default-Advanced'
and PolicySettings.SettingName = 'DetectPrograms'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Default-Advanced]                            [Server_Default-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_Default-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_Default-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_Default-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Advanced]                            [Wrkstn_Default-Spyware]
DetectJokes                        = 1                =>    DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_Default-Spyware', 'DetectJokes', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Wrkstn_Default-Advanced'
and SettingName = 'DetectJokes'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Default-Advanced'
and PolicySettings.SettingName = 'DetectJokes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Trusted-Action]                                    [Server_Trusted-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Action]                                    [Wrkstn_Trusted-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Server_Untrusted-Action]                                [Server_Untrusted-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Action]                                [Wrkstn_Untrusted-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Server_Default-Action]                                    [Server_Default-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Action]                                    [Wrkstn_Default-Action]
uAction                                = 1                =>  = 7 (Deny)
uAction                                = 6                =>  = 1 (Continue)
uSecAction                            = 1                =>  = 7 (Deny)
uSecAction                            = 6                =>  = 1 (Continue)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '6'
    )

update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '1'
    )

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uSecAction'
    and b.Value = '6'
    )

/* ----------------------------------------------------------------------------
[Server_EmailDetection]                                            [Server_EmailDetection]
ExtensionFilterOption (AllFiles)             = 0x00000001     =>     ExtensionMode=1
                      (Default)             = 0x00000002     =>    ExtensionMode=3
                      (Specified)            = 0x00000004     =>    ExtensionMode=4
dwDetect              (Default + Macros)    = 0x00001000     =>    ExtensionMode=2
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailDetection', 'ExtensionMode', '1'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailDetection'
and b.SettingName = 'ExtensionFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000001) > 0
    )

update PolicySettings
set Value = '3'
where
SectionName = 'Server_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000002) > 0
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Server_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000004) > 0
    )

update PolicySettings
set Value = '2'
where
SectionName = 'Server_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailDetection'
    and b.SettingName = 'dwDetect'
    and (convert(int,value) & 0x00001000) > 0
    -- Ignore this flag unless ExtensionFilterOption is set to use default files.
    -- The 7.1 NAP was not good about clearing it if it wasn't being used.
    and PolicySettings.parentid in
        (select a.parentid
        from #VirusScanPolicyIDs, PolicySettings a
        where
        a.ParentID = #VirusScanPolicyIDs.AutoID3
        and a.SectionName = 'Server_EmailDetection'
        and a.SettingName = 'ExtensionFilterOption'
        and (convert(int,value) & 0x00000002) > 0
        )
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailDetection'
and PolicySettings.SettingName = 'ExtensionFilterOption'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailDetection'
and PolicySettings.SettingName = 'dwDetect'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailDetection]                                            [Wrkstn_EmailDetection]
ExtensionFilterOption (AllFiles)             = 0x00000001     =>     ExtensionMode=1
                      (Default)             = 0x00000002     =>    ExtensionMode=3
                      (Specified)            = 0x00000004     =>    ExtensionMode=4
dwDetect              (Default + Macros)    = 0x00001000     =>    ExtensionMode=2
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailDetection', 'ExtensionMode', '1'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailDetection'
and b.SettingName = 'ExtensionFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000001) > 0
    )

update PolicySettings
set Value = '3'
where
SectionName = 'Wrkstn_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000002) > 0
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailDetection'
    and b.SettingName = 'ExtensionFilterOption'
    and (convert(int,value) & 0x00000004) > 0
    )

update PolicySettings
set Value = '2'
where
SectionName = 'Wrkstn_EmailDetection'
and SettingName = 'ExtensionMode'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailDetection'
    and b.SettingName = 'dwDetect'
    and (convert(int,value) & 0x00001000) > 0
    -- Ignore this flag unless ExtensionFilterOption is set to use default files.
    -- The 7.1 NAP was not good about clearing it if it wasn't being used.
    and PolicySettings.parentid in
        (select a.parentid
        from #VirusScanPolicyIDs, PolicySettings a
        where
        a.ParentID = #VirusScanPolicyIDs.AutoID3
        and a.SectionName = 'Wrkstn_EmailDetection'
        and a.SettingName = 'ExtensionFilterOption'
        and (convert(int,value) & 0x00000002) > 0
        )
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailDetection'
and PolicySettings.SettingName = 'ExtensionFilterOption'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailDetection'
and PolicySettings.SettingName = 'dwDetect'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAdvanced]                                            [Server_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
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'dwProgramHeuristicsLevel', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'dwProgramHeuristicsLevel'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000008) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'dwMacroHeuristicsLevel', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'dwMacroHeuristicsLevel'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000004) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'ScanArchives', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'ScanArchives'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000800) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'bScanCompressed', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'bScanCompressed'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000010) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'ScanMime', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'ScanMime'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00010000) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailDetection'
and PolicySettings.SettingName = 'dwDetectOptions'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAdvanced]                                            [Wrkstn_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
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'dwProgramHeuristicsLevel', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'dwProgramHeuristicsLevel'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000008) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'dwMacroHeuristicsLevel', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'dwMacroHeuristicsLevel'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000004) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'ScanArchives', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'ScanArchives'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000800) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'bScanCompressed', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'bScanCompressed'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00000010) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'ScanMime', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'ScanMime'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00010000) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailDetection'
and PolicySettings.SettingName = 'dwDetectOptions'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAdvanced]                                            [Server_EmailAdvanced]
AdvancedFilterOption (ScanBody)                = 0x00000008    =>    ScanMessageBodies=1
AdvancedFilterOption (MultiExtensionScan)    = 0x00000010    =>    MultipleExtensionsHeuristic=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'ScanMessageBodies', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'AdvancedFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'ScanMessageBodies'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'AdvancedFilterOption'
    and (convert(int,value) & 0x00000008) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAdvanced', 'MultipleExtensionsHeuristic', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'AdvancedFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAdvanced'
and SettingName = 'MultipleExtensionsHeuristic'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'AdvancedFilterOption'
    and (convert(int,value) & 0x00000010) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAdvanced'
and PolicySettings.SettingName = 'AdvancedFilterOption'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAdvanced]                                            [Wrkstn_EmailAdvanced]
AdvancedFilterOption (ScanBody)                = 0x00000008    =>    ScanMessageBodies=1
AdvancedFilterOption (MultiExtensionScan)    = 0x00000010    =>    MultipleExtensionsHeuristic=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'ScanMessageBodies', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'AdvancedFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'ScanMessageBodies'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'AdvancedFilterOption'
    and (convert(int,value) & 0x00000008) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAdvanced', 'MultipleExtensionsHeuristic', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'AdvancedFilterOption'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAdvanced'
and SettingName = 'MultipleExtensionsHeuristic'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'AdvancedFilterOption'
    and (convert(int,value) & 0x00000010) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAdvanced'
and PolicySettings.SettingName = 'AdvancedFilterOption'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAdvanced]                                            [Server_EmailSpyware]
dwDetectOptions    (DetectPrograms)            = 0x00004000    =>    DetectPotentiallyUnwantedApps=1
dwDetectOptions    (DontDetectJokes)            = 0x00002000    =>    !DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailSpyware', 'DetectPotentiallyUnwantedApps', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailSpyware'
and SettingName = 'DetectPotentiallyUnwantedApps'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00004000) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailSpyware', 'DetectJokes', '1'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '0'
where
SectionName = 'Server_EmailSpyware'
and SettingName = 'DetectJokes'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00002000) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAdvanced'
and PolicySettings.SettingName = 'dwDetectOptions'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAdvanced]                                            [Wrkstn_EmailSpyware]
dwDetectOptions    (DetectPrograms)            = 0x00004000    =>    DetectPotentiallyUnwantedApps=1
dwDetectOptions    (DontDetectJokes)            = 0x00002000    =>    !DetectJokes=1
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailSpyware', 'DetectPotentiallyUnwantedApps', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailSpyware'
and SettingName = 'DetectPotentiallyUnwantedApps'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00004000) > 0
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailSpyware', 'DetectJokes', '1'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAdvanced'
and b.SettingName = 'dwDetectOptions'

update PolicySettings
set Value = '0'
where
SectionName = 'Wrkstn_EmailSpyware'
and SettingName = 'DetectJokes'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAdvanced'
    and b.SettingName = 'dwDetectOptions'
    and (convert(int,value) & 0x00002000) > 0
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAdvanced'
and PolicySettings.SettingName = 'dwDetectOptions'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAction]                                    [Server_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,
                                }                    }
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAction', 'uAction', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAction'
and b.SettingName = 'uScanAction'

-- ACTION_PROMPT
update PolicySettings
set Value = '2'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '0'
    )

-- ACTION_MOVE
update PolicySettings
set Value = '3'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '1'
    )

-- ACTION_DELETE
update PolicySettings
set Value = '4'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '2'
    )

-- ACTION_CLEAN
update PolicySettings
set Value = '5'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '4'
    )

-- ACTION_CONTINUE
update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '3'
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailAction', 'uSecAction', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_EmailAction'
and b.SettingName = 'uSecScanAction'

-- ACTION_PROMPT
update PolicySettings
set Value = '2'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '0'
    )

-- ACTION_MOVE
update PolicySettings
set Value = '3'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '1'
    )

-- ACTION_DELETE
update PolicySettings
set Value = '4'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '2'
    )

-- ACTION_CLEAN
update PolicySettings
set Value = '5'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '4'
    )

-- ACTION_CONTINUE
update PolicySettings
set Value = '1'
where
SectionName = 'Server_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '3'
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAction'
and PolicySettings.SettingName = 'uScanAction'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAction'
and PolicySettings.SettingName = 'uSecScanAction'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAction]                                    [Wrkstn_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,
                                }                    }
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAction', 'uAction', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAction'
and b.SettingName = 'uScanAction'

-- ACTION_PROMPT
update PolicySettings
set Value = '2'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '0'
    )

-- ACTION_MOVE
update PolicySettings
set Value = '3'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '1'
    )

-- ACTION_DELETE
update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '2'
    )

-- ACTION_CLEAN
update PolicySettings
set Value = '5'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '4'
    )

-- ACTION_CONTINUE
update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uScanAction'
    and b.Value = '3'
    )

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_EmailAction', 'uSecAction', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_EmailAction'
and b.SettingName = 'uSecScanAction'

-- ACTION_PROMPT
update PolicySettings
set Value = '2'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '0'
    )

-- ACTION_MOVE
update PolicySettings
set Value = '3'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '1'
    )

-- ACTION_DELETE
update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '2'
    )

-- ACTION_CLEAN
update PolicySettings
set Value = '5'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '4'
    )

-- ACTION_CONTINUE
update PolicySettings
set Value = '1'
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'uSecScanAction'
    and b.Value = '3'
    )

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAction'
and PolicySettings.SettingName = 'uScanAction'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAction'
and PolicySettings.SettingName = 'uSecScanAction'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAction]                                    [Server_EmailAction]
dwPromptButton                                        =>    |= 0x00000020 (Delete Mail)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = convert(int,Value) | 0x00000020
where
SectionName = 'Server_EmailAction'
and SettingName = 'dwPromptButton'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_EmailAction'
    and b.SettingName = 'dwPromptButton'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAction]                                    [Wrkstn_EmailAction]
dwPromptButton                                        =>    |= 0x00000020 (Delete Mail)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = convert(int,Value) | 0x00000020
where
SectionName = 'Wrkstn_EmailAction'
and SettingName = 'dwPromptButton'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_EmailAction'
    and b.SettingName = 'dwPromptButton'
    )

/* ----------------------------------------------------------------------------
[Server_EmailAction]
-szSecMoveFolder
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAction'
and PolicySettings.SettingName = 'szSecMoveFolder'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAction]
-szSecMoveFolder
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAction'
and PolicySettings.SettingName = 'szSecMoveFolder'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailAction]
-dwPromptButton2
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailAction'
and PolicySettings.SettingName = 'dwPromptButton2'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_EmailAction]
-dwPromptButton2
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_EmailAction'
and PolicySettings.SettingName = 'dwPromptButton2'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_EmailReport]                                    [Server_EmailReport]
uMaxKilobytes                                         =>    dwMaxLogSizeMB
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_EmailReport', 'dwMaxLogSizeMB', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'Server_EmailReport'
and SettingName = 'uMaxKilobytes'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_EmailReport'
and PolicySettings.SettingName = 'uMaxKilobytes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[WrkStn_EmailReport]                                    [WrkStn_EmailReport]
uMaxKilobytes                                         =>    dwMaxLogSizeMB
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'WrkStn_EmailReport', 'dwMaxLogSizeMB', Value
from PolicySettings, #VirusScanPolicyIDs
where
PolicySettings.ParentID = #VirusScanPolicyIDs.AutoID2
and SectionName = 'WrkStn_EmailReport'
and SettingName = 'uMaxKilobytes'

delete PolicySettings
where
PolicySettings.SectionName = 'WrkStn_EmailReport'
and PolicySettings.SettingName = 'uMaxKilobytes'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_UIOptions]
-dwConsoleRefreshRate
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Server_UIOptions'
and PolicySettings.SettingName = 'dwConsoleRefreshRate'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[WrkStn_UIOptions]
-dwConsoleRefreshRate
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'WrkStn_UIOptions'
and PolicySettings.SettingName = 'dwConsoleRefreshRate'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Trusted-Action]                                            [Server_Trusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Action]                                            [Wrkstn_Trusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Trusted-Action]                                            [Server_Trusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Trusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Action]                                            [Wrkstn_Trusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Trusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Trusted-Action]                                            [Server_Trusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Trusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Trusted-Action]                                            [Wrkstn_Trusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Trusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Trusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Trusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Untrusted-Action]                                        [Server_Untrusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Action]                                        [Wrkstn_Untrusted-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Untrusted-Action]                                        [Server_Untrusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Untrusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Action]                                        [Wrkstn_Untrusted-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Untrusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Untrusted-Action]                                        [Server_Untrusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Untrusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Untrusted-Action]                                        [Wrkstn_Untrusted-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Untrusted-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Untrusted-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Untrusted-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Default-Action]                                            [Server_Default-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Action]                                            [Wrkstn_Default-Action]
uAction                                        = 3    (Move)        =>  = 4 (Delete)
uSecAction                                                    =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Default-Action]                                            [Server_Default-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Default-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Action]                                            [Wrkstn_Default-Action]
uAction                                        = 5    (Clean)
uSecAction                                    = 3    (Move)        =>  = 4 (Delete)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '4'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '5'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Default-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_Default-Action]                                            [Server_Default-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Server_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Server_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Server_Default-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Wrkstn_Default-Action]                                            [Wrkstn_Default-Action]
uAction                                        = 4    (Delete)
uSecAction                                    = 3    (Move)        =>  = 7 (Deny)
---------------------------------------------------------------------------- */
update PolicySettings
set Value = '7'
where
SectionName = 'Wrkstn_Default-Action'
and SettingName = 'uSecAction'
and PolicySettings.parentid in
    (select b.parentid
    from #VirusScanPolicyIDs, PolicySettings b, PolicySettings c
    where
    b.ParentID = #VirusScanPolicyIDs.AutoID3
    and b.SectionName = 'Wrkstn_Default-Action'
    and b.SettingName = 'uAction'
    and b.Value = '4'
    and b.ParentID = c.ParentID
    and c.SectionName = 'Wrkstn_Default-Action'
    and c.SettingName = 'uSecAction'
    and c.Value = '3'
    )

/* ----------------------------------------------------------------------------
[Server_General]                                                [Server_QuarantinePolicy]
szMoveToFolder=\quarantine                                    =>    szQuarantineDirectory=<SYSTEM_DRIVE>\quarantine
 ~OR~
szMoveToFolder=C:\quarantine                                =>    szQuarantineDirectory=C:\quarantine
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_QuarantinePolicy', 'szQuarantineDirectory', '<SYSTEM_DRIVE>' + b.Value
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_General'
and b.SettingName = 'szMoveToFolder'
and b.Value like '\%'

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_QuarantinePolicy', 'szQuarantineDirectory', b.Value
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_General'
and b.SettingName = 'szMoveToFolder'
and b.Value not like '\%'

delete PolicySettings
where
PolicySettings.SectionName = 'Server_General'
and PolicySettings.SettingName = 'szMoveToFolder'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_General]                                                [Wrkstn_QuarantinePolicy]
szMoveToFolder=\quarantine                                    =>    szQuarantineDirectory=<SYSTEM_DRIVE>\quarantine
 ~OR~
szMoveToFolder=C:\quarantine                                =>    szQuarantineDirectory=C:\quarantine
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_QuarantinePolicy', 'szQuarantineDirectory', '<SYSTEM_DRIVE>' + b.Value
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_General'
and b.SettingName = 'szMoveToFolder'
and b.Value like '\%'

insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_QuarantinePolicy', 'szQuarantineDirectory', b.Value
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_General'
and b.SettingName = 'szMoveToFolder'
and b.Value not like '\%'

delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_General'
and PolicySettings.SettingName = 'szMoveToFolder'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Alerting]
-bMoveFiles
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Server_Alerting'
and PolicySettings.SettingName = 'bMoveFiles'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Alerting]
-bMoveFiles
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Alerting'
and PolicySettings.SettingName = 'bMoveFiles'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Server_Reporting]
-bLogUserName
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Server_Reporting'
and PolicySettings.SettingName = 'bLogUserName'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)

/* ----------------------------------------------------------------------------
[Wrkstn_Reporting]
-bLogUserName
---------------------------------------------------------------------------- */
delete PolicySettings
where
PolicySettings.SectionName = 'Wrkstn_Reporting'
and PolicySettings.SettingName = 'bLogUserName'
and PolicySettings.ParentID in
(select
AutoID
from Policy, PolicySettings
where
Policy.autoid = PolicySettings.parentid
and Policy.ProductCode = 'VIRUSCAN8700'
and Policy.ParentType in (6, 5, 4, 3, 1)
)
end
go

/* ----------------------------------------------------------------------------
[Server_UIPOptions]
UseUTF8=0
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Server_UIPOptions', 'UseUTF8', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Server_UIPOptions'

/* ----------------------------------------------------------------------------
[Wrkstn_UIPOptions]
UseUTF8=0
---------------------------------------------------------------------------- */
insert PolicySettings
(ParentID, SectionName, SettingName, Value)
select #VirusScanPolicyIDs.AutoID3, 'Wrkstn_UIPOptions', 'UseUTF8', '0'
from PolicySettings b, #VirusScanPolicyIDs
where
b.ParentID = #VirusScanPolicyIDs.AutoID2
and b.SectionName = 'Wrkstn_UIPOptions'

/* ----------------------------------------------------------------------------
Done...
---------------------------------------------------------------------------- */

if exists (select * from tempdb..sysobjects where name like '#VirusScanPolicyIDs%')
drop table #VirusScanPolicyIDs
go