locked
Usage Statistics report in WSS 3.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

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

    Senthilrajan Kaliyaperumal




    • Edited by Mike Walsh FIN Thursday, May 5, 2011 4:32 PM Do not use one thread to try to push another thread. Post only one question per thread. "Problem" removed from Title along with most of the text which was pushing an earlier post.
    Thursday, May 5, 2011 2:00 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    1. On the Central Administration home page, click Operations.

    2. On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

    3. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

    4. Type a log file location and number of log files to create.

    5. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

    6. 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
    • Proposed as answer by fraterminor Thursday, May 19, 2011 9:27 AM
    • Marked as answer by Peng Lei Monday, May 30, 2011 3:13 AM
    Tuesday, May 17, 2011 10:31 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

    Friday, May 6, 2011 7:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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



    Friday, May 6, 2011 8:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Sunday, May 15, 2011 10:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Monday, May 16, 2011 11:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Monday, May 16, 2011 11:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    • Edited by Mike Walsh FIN Monday, May 30, 2011 10:33 AM Do not waste screen space with use of full quote
    Monday, May 16, 2011 2:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Monday, May 16, 2011 3:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Monday, May 16, 2011 11:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    1. On the Central Administration home page, click Operations.

    2. On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

    3. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

    4. Type a log file location and number of log files to create.

    5. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

    6. 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
    • Proposed as answer by fraterminor Thursday, May 19, 2011 9:27 AM
    • Marked as answer by Peng Lei Monday, May 30, 2011 3:13 AM
    Tuesday, May 17, 2011 10:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Monday, May 30, 2011 10:13 AM