Just checked by site to see what type of Browser coverage I am getting -- used the following query:
select count(useragent) as [count],
Case
when charindex('MSIE 5', UserAgent) > 0 then 'IE5'
when charindex('MSIE 6', UserAgent) > 0 then 'IE6'
when charindex('MSIE 7', UserAgent) > 0 then 'IE7'
when charindex('MSIE 8', UserAgent) > 0 then 'IE8'
when charindex('Firefox', UserAgent) > 0 then 'FF'
when charindex('Opera', UserAgent) > 0 then 'Opera'
when charindex('Chrome', UserAgent) > 0 then 'Chrome'
when charindex('bot', UserAgent) > 0 then 'bot'
when charindex('slurp', UserAgent) > 0 then 'bot'
when charindex('crawler', UserAgent) > 0 then 'bot'
when charindex('spider', UserAgent) > 0 then 'bot'
when charindex('jeeves', UserAgent) > 0 then 'bot'
when charindex('google', UserAgent) > 0 then 'bot'
else 'Other'
end as Browser from dbo.SiteLog
group by Case
when charindex('MSIE 5', UserAgent) > 0 then 'IE5'
when charindex('MSIE 6', UserAgent) > 0 then 'IE6'
when charindex('MSIE 7', UserAgent) > 0 then 'IE7'
when charindex('MSIE 8', UserAgent) > 0 then 'IE8'
when charindex('Firefox', UserAgent) > 0 then 'FF'
when charindex('Opera', UserAgent) > 0 then 'Opera'
when charindex('Chrome', UserAgent) > 0 then 'Chrome'
when charindex('bot', UserAgent) > 0 then 'bot'
when charindex('slurp', UserAgent) > 0 then 'bot'
when charindex('crawler', UserAgent) > 0 then 'bot'
when charindex('spider', UserAgent) > 0 then 'bot'
when charindex('jeeves', UserAgent) > 0 then 'bot'
when charindex('google', UserAgent) > 0 then 'bot'
else 'Other'
end
Order by [Count] desc
(if you can improve the Query please suggest)
The result was
57130 bot
16699 IE6
16409 IE7
7609 FF
1847 Other
723 Chrome
628 Opera
565 IE5
354 IE8
So you can see that IE6 is the most used Browser on my Site.... Ugh! , but interesting!
Food for Thought!
Paul.