web control block list

HI,

Not outside of SQL queries against the database to update the XML for the policy type.

Do you have SQL Management Studio installed?

Regards,

Jak

what is the table or the query that i can use to get the xml list updated through ssms? 

what is the table or the query that i can use to get the xml list updated through ssms? 

Hi,

I would suggest:

1. Create a new web control policy.  To make it simple, call it something distinctive across all policy types, e.g. webctemplate, add one of each type to the 2 sections, so you have 6 entries in total.

2. In SQL Management Studio, you can then execute the query:

select * from policies where name='webctemplate'

3. You are interested in the PolicyXML data from the result, so copy that out, it's not that long by default.

4. Edit the SQL in your text editor to paste into the relevant sections the IPs, Domains, IP/Subnets you want to either allow or exclude. I assume you have in a text file the values you wish to add to both.  You may need to use a tool such as Notepad++ or even excel to get the values wrapped in the XML format as exported.

Once you have the new XML you can then run an update command such as: http://pastebin.com/raw/SM70K3tk to over-write the SQL in this test web control policy.

5. Once updated, open the Policy in SEC to see the update has been successful.

6. You will need to re-edit it in SEC, maybe just add one entry to a list to generate a new GUID for the policy so the management service knows it has been updated.

You can then link/clone this policy for use.

Important disclaimer: All this is very unsupported and I would strongly advise you take a backup of the 'core' database (community.sophos.com/.../17323) before making updates to it.

Regards,

Jak

thanks that worked.