GetSiteLog8 [dnn:portalid],'','2005-1-1','2005-12-31'

select top 1 DateTime, cast(DateDiff(minute,DateTime,getDate())/60.00 as
decimal(9,2) ) AS [Hours Ago] 
from sitelog where portalid = [DNN:PortalId]
and useragent like '%googlebot%'
order by DateTime Desc

select  top 10
substring(substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)),1,
patindex('%/%',substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)))-1) Domain
,count(*) Referrals
from sitelog 
where referrer is not null
and referrer not like '%dnnstuff.com%'
and referrer like '%://%'
and portalid = [DNN:PortalId]
and datediff(minute,datetime,getdate()) <=360
group by substring(substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)),1,
patindex('%/%',substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)))-1)
order by count(*) desc

SELECT     TOP 10 dbo.Tabs.TabName Tab, 
{ fn MONTHNAME(dbo.SiteLog.DateTime) } AS [Month], COUNT(*) AS [# of Hits]
FROM         dbo.SiteLog INNER JOIN
dbo.Tabs ON dbo.SiteLog.TabId = dbo.Tabs.TabID INNER JOIN
dbo.Portals ON dbo.Tabs.PortalID = dbo.Portals.PortalID INNER JOIN
dbo.TabPermission ON dbo.TabPermission.TabId = dbo.Tabs.TabID
WHERE dbo.SiteLog.PortalId = [DNN:PortalId] AND dbo.TabPermission.RoleId = -1
GROUP BY dbo.Tabs.TabName, { fn MONTHNAME(dbo.SiteLog.DateTime) }