Hi Friends, I want to find out the top 10 sites for the last six months .I,e the most viewed sites in the Sharepoint portal for last 6 months statistics. we are using Sharepoint 2003 and SPS 2003,WSS 2.0 and enabled logging and processing too. Could you please let me know is there any way to check the above statistics of sites in the porta. Ravishankar Maduri MCTS,MCPD,MCP

Hi RavishankerMaduri, Probably the best option for you would be to use log parser or FrontPage to view monthly usage. (Log parser can also generate charts for you if you need them, by the way). I suggest log parser because the usage logging in WSS 2.0 came from IIS, and the options in the interface are limited when compared to the information you can pull out of IIS logs with your own queries. There's a great variety of information you can query, such as what are your most common error status codes, who are your top users, and how often are .ASMX pages hit/browsed versus .ASPX. So it's all sorts of powerful. This is the link to get Logparser 2.2: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en When it comes to log parser, there's a lot of helpful information out there, on and off Microsoft sites (http://www.iisworkstation.com/2009/03/how-to-iis-and-log-parser-22.html, for instance, is a quick 'How to' -- but there are plenty of others). According to what I'm hearing, your log parsing query would be something like: Logparser "SELECT TOP 20 cs-uri-stem, COUNT(*) AS UrlHits INTO Top.csv FROM <nameOfyourIISlog>.log GROUP BY cs-uri-stem ORDER BY UrlHits DESC" If you have 6 months of logs, you'll need to group them in one location where they can be referenced by path and aggregated. Instead of referring to one file, you would refer to a month's worth of them: 1 File = ... FROM c:\<yourLogFilePathHere>\ex100624.log... In the example above, the file name stands for 2010 (year), 06 (month), 24th (day). Meaning I could get all this month via ...\ex1006*.log, for instance. It does help to know about the syntax of the IIS Logs as well, for instance, you might want to know that cs-uri-stem is the URL involved, like /default.aspx. How do I know this? The IIS Logs have headers at the top listing the names of each row of data underneath, one header of which is the cs-uri-stem, and there's a handy URL that helps to explain what all the strange column titles mean: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/ffdd7079-47be-4277-921f-7a3a6e610dcb.mspx?mfr=true. This information will be very helpful if you decide to go the log parser route. And remember, you have your standard GUI and FrontPage viewing options: Usage in the GUI: -------------------- Summary and detailed usage reports supply information such as the following: • Number of page hits for each individual page • Number of unique users • Browser and operating system information • Referring domains and URLs What you see using FrontPage: ----------------------------------- Usage Summary - Displays overall statistics for your site collected since inception. The inception date is one of the reported statistics. Monthly and Daily Summaries - Displays total visits, total page hits, total hits of all kinds, and percentage of hits. Monthly and Daily Page Hits - Displays, by period, the number of times that Web visitors requested each page in your site. Visiting Users Displays - the identities of site visitors to your site. However, unless you require Web visitors to identify themselves by user name and password, this report will be blank. In intranet or extranet environments, this report provides valuable information. Operating Systems - Reports how many visits came from computers running Windows 95, Windows 98, Windows NT, Windows 2000, Windows 2003, Macintosh, various forms of UNIX, and so forth. Browsers - Reports how many visits came from various browsers, such as Microsoft Internet Explorer 5.0 and later, and various versions of Netscape. Referring Domains - Reports the names of all websites—anywhere—that contain hyperlinks that Web visitors followed to your site. Referring URLs - Reports the locations of all Web pages that contain hyperlinks that Web visitors followed to your site. Search Strings - Reports a history of keywords that Web visitors entered on Search forms on one of the large search engines such as Yahoo! or AltaVista. This tells you how people are finding your site and what topics interest them. In intranet or extranet environments, this report will probably remain empty. For more information on how to look at your usage in FrontPage, please see: Chapter 29: http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb400762.aspx I do hope this helps you! Thanks! Tracy

Hi again RavishankerMaduri, Just checking back on this thread. I hope all is well with you! Thanks, Tracy

Hi Tracy , Thank you for the information , sorry for the late reply .The above information is very help full , i have sorted it out with Log Parser . thanks and Regards Ravishanker Maduri Ravishankar Maduri MCTS,MCPD,MCP