Does WSS has usage statistics feature(default usage reporting feature)? If Yes, Please provide the details and some references. Senthilrajan Kaliyaperumal

Hi Senthilrajan, Please refer to this article and you will get the way of how to configure usage reporting: http://technet.microsoft.com/en-us/library/cc262541(office.12).aspx. Thanks & Regards, Peng Lei

Thanks guys(I was expecting a comment from Mike on this thread), The default usage report problem has been solved but need to find the timer trigger. I have enabled the usage analysis logs and schedule for every 1 hour. Also the database statistics services also scheduled every one hour. I was waiting for the whole day(light hours) get the ULS logs in the specified location but did not(The day was unhappy). Then I have looked at the ULS logs in next day morning. I got the ULS logs(generate at 12am) for previous day(the default reports also works fine) and generated a empty folder for current day(Somethinkg misleading-folder without a file). Now the exact questions are, Where to schedule the job for creating usage logs in specified log location? Does WSS generate logs once on a day? Does WSS delete the usage data permanently from database if the record is more than 30 day old? Senthilrajan Kaliyaperumal

Thanks guys(I was expecting a comment from Mike on this thread), The default usage report problem has been solved but need to find the timer trigger. I have enabled the usage analysis logs and schedule for every 1 hour. Also the database statistics services also scheduled every one hour. I was waiting for the whole day(light hours) get the ULS logs in the specified location but did not(The day was unhappy). Then I have looked at the ULS logs in next day morning. I got the ULS logs(generate at 12am) for previous day(the default reports also works fine) and generated a empty folder for current day(Somethinkg misleading-folder without a file). Now the exact questions are, Where to schedule the job for creating usage logs in specified log location? Does WSS generate logs once on a day? Does WSS delete the usage data permanently from database if the record is more than 30 day old? Senthilrajan Kaliyaperumal

Thanks guys(I was expecting a comment from Mike on this thread), The default usage report problem has been solved but need to find the timer trigger. I have enabled the usage analysis logs and schedule for every 1 hour. Also the database statistics services also scheduled every one hour. I was waiting for the whole day(light hours) get the ULS logs in the specified location but did not(The day was unhappy). Then I have looked at the ULS logs in next day morning. I got the ULS logs(generate at 12am) for previous day(the default reports also works fine) and generated a empty folder for current day(Somethinkg misleading-folder without a file). Now the exact question are, Where to schedule the job for creating usage logs in specified log location? Does WSS generate logs once on a day? Senthilrajan Kaliyaperumal

Hello Peng Lei, I'm having some troubles configuring this, following the article, you proposed... The first part is crystal-clear, until it says, I have to configure some "Office Sharepoint Usage Report" - I just don't find this - neither on the WSS-page nor in central-administration... could you help me out? Thanks in advance Thomas

Hello Peng Lei, I'm having some troubles configuring this, following the article, you proposed... The first part is crystal-clear, until it says, I have to configure some "Office Sharepoint Usage Report" - I just don't find this - neither on the WSS-page nor in central-administration... could you help me out? Thanks in advance Thomas

Hi Senthilrajan, Check your version of your WSS/MOSS. As far as I can remember, a regression bug was introduced after Infrastructure Update which caused Usage Report to contains none or partial data. mm, I just found the exact KB. Have a look of this, see if helps. After you install the hotfix package that is described in Microsoft Knowledge Base article 952288, the Site Collection Usage Summary page is broken http://support.microsoft.com/kb/969231 Also by 'ULS' log, I assume what you really mean is the 'Usage' log. Usage log and ULS logs are two different things. On a high level, this is how the usage reports were generated. (based on my vanishing memory...) 1. IIS keeps all the SharePoint usage records in memory and will only dump it into physical file (the usage log) when memory is full or IISRESET 2. By default, MOSS has daily timer job to process these physical files into database's temp usage tables (can't remember the exact database and table names now, unless if I go setup a MOSS environment) 3. Be default, MOSS has another hourly or minutely timer job that process data in those temp/shadow tables into the real usage tables. Once this is completed, usage report would then be available for viewing. Cheers, Allen Wang | http://blogs.msdn.com/allenwang

Hi Fraterminor, There are three things you need to configure in order to 'enable' usage report. 1. Enable Windows SharePoint Services usage logging (this config is in Central Admin site) 2. Enable Usage Reporting (this config is in SSP admin site) 3. Activate Usage Reporting (this is site collection feature) Everything is in the link Peng Lei provided. Read again carefully, then you will see it. Cheers, Allen Wang | http://blogs.msdn.com/allenwang

Hi Fraterminor, There are three things you need to configure in order to 'enable' usage report. 1. Enable Windows SharePoint Services usage logging (this config is in Central Admin site) 2. Enable Usage Reporting (this config is in SSP admin site) 3. Activate Usage Reporting (this is site collection feature) Everything is in the link Peng Lei provided. Read again carefully, then you will see it. Cheers, Allen Wang | http://blogs.msdn.com/allenwang Thanks for the reply. But the query is for WSS 3.0 not for MOSS 2007Senthilrajan Kaliyaperumal

Hello Allan, I don't get it quite, yet - I am running a WSS3,0 on a small Business Server 2008 - having trouble finding the SSP-Page, I think it's just not there in SBS 2008...? Thanks for the help Thomas Grandegger

There are three things you need to configure in order to 'enable' usage report. Thanks for the reply. But the query is for WSS 3.0 not for MOSS 2007 Senthilrajan Kaliyaperumal

There are three things you need to configure in order to 'enable' usage report. Thanks for the reply. But the query is for WSS 3.0 not for MOSS 2007 Senthilrajan Kaliyaperumal

ah, sorry....the title clearly says WSS 3.0. Well, WSS 3.0 does not have SSP, so you won't be able to find it. In that case, I think you can skip step 2 (Enable Usage Reporting - this config is in SSP admin site ) However the hotfix and bug described in KB 969231 are for WSS 3.0, so the both WSS3.0 and MOSS are affected. (I really need to set up my WSS/MOSS envionment, before I can help you guys properly...I only have SPS2003 and SP2010 environments at the moment...)Allen Wang | http://blogs.msdn.com/allenwang

Below are the steps to enable the logs in WSS 3.0. Once the logs are enabled then check the logs next day at the log location. Enable usage logging for the farm On the Central Administration home page, click Operations. On the Operations page, in the Logging and Reporting section, click Usage analysis processing. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging. Type a log file location and number of log files to create. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing. Click OK. To view default report go to site settings and client on site usage link. or type: http://server/testsite/_layouts/usagedetails.aspx I have done WSS reporting for further 30 days using custom database. Senthilrajan Kaliyaperumal

Just wanted to check-in: The usage report is running now - thank you for the help. It started working app. 2 days after finishing the settings you provided. kind regards Thomas

Just wanted to check-in: The usage report is running now - thank you for the help. It started working app. 2 days after finishing the settings you provided. kind regards Thomas