-------------------start
--converts to localtime from Bluecoat's UTC time.
SELECT	TO_LOCALTIME(TO_TIMESTAMP(date, time)) AS date,
		time-taken,
		c-ip,
		cs-username,
		cs-auth-group,
		x-exception-id,
		sc-filter-result,
		cs-categories,
		cs(Referer) AS Referer,
		sc-status AS scStatus,
		s-action,
		cs-method,
		rs(Content-Type) AS ContentType,
		cs-uri-scheme,
		cs-host,
		cs-uri-port,
		cs-uri-path,
		cs-uri-query,
		cs-uri-extension,
		cs(User-Agent) AS UserAgent,
		s-ip,
		sc-bytes,
		cs-bytes,
		x-virus-id

INTO   BlueCoat
FROM   c:\myCleanBlueCoatlog.log
------------------end
--command line below:
--logparser file:c:\scripts\log\bluecoat.sql -i:W3C -o:SQL -server:sqlservername -database:BLUECOAT -createtable:ON -dQuotes:ON