web control block list

Question

hello 
 is there a way to bulk add a list of domains/websites/ip address to web control block list in sophos enterprise console ? 
 thank you

jak · Accepted Answer

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