R – MOSS – get site usage summary by code

iissharepointsharepoint-2007

I want to build a WebService that shows two columns:
User Name , Url.

It will be a list of all the entrances to my sharepoint site.

I think to use the "MOSS usage service",
are there any articles about how to get to the service's data?
or maybe I need to deal here directly with the IIS ?

Best Answer

First of all you need to enable usage analysis processing (TechNet). Then for out-of-the-box options you already have, there are instructions in that TechNet article and you can also use SharePoint Designer.

Unfortunately the usage data cannot be accessed programmatically via the SharePoint API. You should set up IIS Log Parser instead. There is lots of information in this question Exporting SharePoint usage log files into a database using LogParser and blog posts from Todd Klindt, Cory Burns.