Solved

What is the definition of 'hits' in Sharepoint 2007 site usage reports

Posted on 2011-02-17
4
2,549 Views
Last Modified: 2012-05-11
Sharepoint can display site usage reports with the pages listed and daily view.

On the left column it shows various files, e.g., .aspx, .html, gif, jpg., pdf, etc.
On the columns to the right shows each day of the month and a number.

Question #1: Are these numbers 'hits' or 'page views' for .aspx and .html files?   If you do not know how http requests work then, you may not know the real answer to this question.  

Question #2: Does the sharepoint server cache pages and not record a 'hit' if a user visits the same page within a short time and the page has not changed?

Question #3:  My research shows that there is a way of accessing site usage data beyond the 30 day limit.  See http://blogs.technet.com/b/praveenh/archive/2010/11/02/usage-reporting-in-sharepoint-wss-or-moss.aspx.  Do you know how to access this data using Sharepoint designer or a 3rd party tool?
0
Comment
Question by:scottlum
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34922249
regarding #3:
http://dkolitha.wordpress.com/2008/02/13/sharepoint-2007-usage-reports/

(p.s.  M$ recommends the Object Model method.  if you use SQL query, know that the database could change with a sharepoint update, and be careful you're not impacting SQL / Sharepoint performance).

for a 3rd party tool, you might look at CardioLog.

usage reports in sharepoint designer are not really custom per se.  they are selections you make in the menu.
http://office.microsoft.com/en-us/sharepoint-designer-help/use-reports-to-measure-site-performance-and-usage-HA010174136.aspx
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34923208
In SharePoint a HIT is every time a page is requested (cached or not)

Personally we found the usage reporting in SharePoint wasn't very good.  For example, notice in the hits that the crawler and admin accounts are included!

We actually setup an automated process to process the IIS logs using LogParser 2.2 (free from Microsoft) to push the data into a SQL database where we could trim the data the way we wanted and keep years worth of it.
0
 

Author Comment

by:scottlum
ID: 34923982
Traditionally, a HIT is the aggregate count of all the elements in the web page, including the HTML file, images, css, etc.  For example, if you have a page with 10 pictures, then a request to a server to view that page generates 11 hits (10 for the pictures, and one for the html file).

So, is a Sharepoint HIT really a page view or does a certain number of HITs of the page (depending on the number of elements), constitute a real single page view in Sharepoint?

0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 125 total points
ID: 34927470
Actually in my experience a Hit is counted as '1' for a GET/POST for the entire page.  Not the total of all the page elements.  That is what SharePoint uses.

All the dashboards I've used like on Wordpress counts one hit as one GET/POST for a entire page.  Some even collapse them into one distinct hit per session so refreshing the page in a session doesn't increase the total.

Sharepoint counts a page hit as '1' for the entire page however you can drill down somewhat (I can't remember how detailed because we gave up on the built in metrics quickly)

The problem with using the raw IIS logs is it does track the loading of every page element so we had to write some complex queries and code to collapse the data but at least we had control of the process.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question