Monday, April 13, 2009

Usage Analysis Processing

One of the fairly overlooked items in WSS 3.0 and MOSS is the ability to access reports on site usage and other useful items such as broken links, slow pages, etc. By default this capability is not turned on in WSS or MOSS. If your organization wants to be able to quickly see statistics for SharePoint site usage, then Usage Analysis Processing is a good place to start. Another option available is Google Analytics, which works well also.



To set up UAP, log into the Central Administration page and under Logging and Reporting click on Usage analysis processing. On this page there are two sections, one for logging settings and one for processing settings. Under loggin settings, check the checkbox to enable logging and you can change the location of the log file (which by default is the LOGS folder in the 12 hive.) You can also set the number of log files to create as long as it is between 1 and 30.



Under processing settings, check the checkbox for enable usage analysis processing and then set the time range that you want the server to do processing. This should be a time frame when the server is less busy as the processing will slow down the web server. Click the Ok button and that is all there is to it. You will probably need to wait a day or two before you will start getting usage reports.



To access the reports, you can use SharePoint Designer by opening the site you want the stats for and clicking on Site and then Reports. You can get reports for Files, Problems, Usage, and more.



For more information about UAP and where the files reside check out this article.

7 comments:

  1. Great Post, I must give you that.

    Being direct and "not spamming" - I just wanted to say we have created a SharePoint Usage report - it's called "CardioLog" by intlock.com.

    The product comes in 3 editions, "lite" edition is Free.


    I didn't want to insert a link, but you can look it up, and if you will be kind enough to add a link to our web site - we'll appreciate it very much.

    Many thanks,
    Uri - Intlock.com

    ReplyDelete
  2. Hi Michael,

    I went through many of your postings and found loads of extremely useful information which i was looking for so looong.

    I couldnt control myself but to seek your guidance on one peculiar requiremnt.

    requirement is something like this.
    "System should be able to programmatically read the Word 2007 document from the Document Library, modify some content and save-as PDF" system does require to do many additional steps but i am comfortable about rest except 'How to programmatically read/modify the document stored in sharepoint document library'

    Let me know if you could redirect me to some online resource(s) where i can get meaningful help to implement my requirement.

    Regards
    -V

    ReplyDelete
  3. V,

    You will want to include the Office assemblies to open and modify a word document. You should be able to access the actual file by using the SPFolder object to get to the document library and then use the SPFile object and cast it as a word document. Of course this can take different routes if the version of office is 2007 because you can open the word document as an XML file and modify it that way. I don't know if you saw my posts about programmatically building a 2007 Word document, but that might give you something to start with.

    Michael

    ReplyDelete
  4. Thanx a lot Michel..!

    I did a POC on similar lines and it worked as expected. Yes i had read that post of yours regarding the "programmatically building a 2007 Word document".

    Michel I am still having one trouble while converting the document into PDF. I could convert it PDF using ExportAsFixedFormat() method of Microsoft.Office.Interop.Word.Document but it requires to give the 'filename' as a local filesystem path where in i want to save this PDF directly into another document library without being require to save it locally, not even temporarily.

    I thought of using the approch suggested by u i.e. using WordprocessingDocument obejct of Microsoft.Office.DocumentFormat.OpenXml.Packaging class, but i could not figure out how to convert the document in PDF in this case. One more thing i noticed that, WordprocessingDocument object provides ChangeDocumentType() method but the MSDN documentation is just useless in this case.

    Let me know if you have some alternative to achieve this (converting docx in PDF without saving locally)

    Regards
    -V

    ReplyDelete
  5. V,

    I am not sure how you can achieve this. Does it have to be a local file path? If not you can access a SharePoint document library as a UNC path and possibly add the file that way.

    Michael

    ReplyDelete
  6. THe usage report is read from which log file? My problem is the result before 18th was empty, i think i deleted some of the log file.anywa to receover it back?

    ReplyDelete
  7. Usage reports come from the IIS logs of traffic, not any SharePoint logs.

    ReplyDelete