Total Web Hits for Dec/05 through Feb/06 |
Query: |
|
select logname,count(*)
from NVOWeblog
where [date] between '2005-12-01' and '2006-02-28'
group by logname
order by logname
|
Notes:
HEASARC hits include multiple datascope hits
STScI is NVOTwiki hits
|
Total Hits
|
|
Daily Web Hits for Dec/05 through Feb/06 |
Query: |
|
select datepart(yy,[date]),'-',datepart(mm,[date]),'-',datepart(dd,[date]),
sum(case when logid=1 then 1 else 0 end) as HEASARC,
sum(case when logid=2 then 1 else 0 end) as SkyView,
sum(case when logid=3 then 1 else 0 end) as IRSA,
sum(case when logid=4 then 1 else 0 end) as NED,
sum(case when logid=5 then 1 else 0 end) as MAST,
sum(case when logid=6 then 1 else 0 end) as NVOTwiki
from NVOWeblogAll
group by datepart(yy,[date]),datepart(mm,[date]),datepart(dd,[date])
order by datepart(yy,[date]),datepart(mm,[date]),datepart(dd,[date])
|
Notes:
Current NED data is outside this date range (I only have Mar-Apr/06)
|
Daily Hits
|
|
Monthly Web Hits |
Query: |
|
select datepart(yy,[date]),'-',datepart(mm,[date]),
sum(case when logid=1 then 1 else 0 end) as HEASARC,
sum(case when logid=2 then 1 else 0 end) as SkyView,
sum(case when logid=3 then 1 else 0 end) as IRSA,
sum(case when logid=4 then 1 else 0 end) as NED,
sum(case when logid=5 then 1 else 0 end) as MAST,
sum(case when logid=6 then 1 else 0 end) as NVOTwiki
from NVOWeblogAll
group by datepart(yy,[date]),datepart(mm,[date])
order by datepart(yy,[date]),datepart(mm,[date])
|
Notes:
Log plot
Current NED data is only for Mar-Apr/06
|
Monthly Hits
|
|
Daily Bytes Out for Dec/05 through Feb/06 |
Query: |
|
select datepart(yy,[date]),'-',datepart(mm,[date]),'-',datepart(dd,[date]),
sum(case when logid=1 then bytesOut else 0 end) as HEASARC,
sum(case when logid=2 then bytesOut else 0 end) as SkyView,
sum(case when logid=5 then bytesOut else 0 end) as MAST,
sum(case when logid=6 then bytesOut else 0 end) as NVOTwiki
from NVOWeblogAll
where logid in (1,2,5,6)
group by datepart(yy,[date]),datepart(mm,[date]),datepart(dd,[date])
order by datepart(yy,[date]),datepart(mm,[date]),datepart(dd,[date])
|
Notes:
Log plot
No bytes out data for IRSA and NED at the moment
|
Daily Bytes Out
|