Hi,

I know that ,SharePoint-2010 is recording the request log in WSS_Logging--> RequestUsage Table, my requirement is to get the report w.r.t following criteria:

 

Total Number of Visit (we can retrieve form web analysis report)    
Unique Visits     (we can retrieve form web analysis report)
Page Impressions (Page Views) ???     
Pages/Visit   ????  
Avg Time on the Site  ???   
% New Visitors   ???  
% of Returning Visitors ???    
Top Referring Sites     (we can retrieve form web analysis report)
Language (we can retrieve form web analysis report)  

Please advice how i can get above reports from RequestUsage Table ?

Hi Nazish,

You can consider this approach like Querying the WSS_Logging DB and display results in your custom reports, As:

• The SharePoint logging database is fully supported for reading, querying or even writing data back to it unlike other databases of SharePoint.

• The capturing of usage and health data collection is enabled by default.

• It is recommended to have the SharePoint logging database  database on a separate server or separate drive with its own spindles. By default database name is WSS_Logging.

• By default, information is logged in a Log folder under the root folder where SharePoint has been installed. You should consider changing this location to some other drive than the drive on which SharePoint has been installed (and consider a high speed drive especially in case you are using verbose logging). Also make sure that the same location is available on all the servers of the farm.

• A developer can write custom messages for diagnostic logging using the SPDiagnosticsService class. Not only that, you can even control the diagnostic logging behavior programmatically using this class. Please note it does not work in a Sandboxed environment (unless you create a full trusted proxy and call it from the Sandboxed solution). There is an unsupported ULS log viewer which you can use to view the log in a more user friendly interface instead of using standard log file viewers, click here for more details.

Can you go through following article's for further reference:

http://www.codeproject.com/Articles/70865/SharePoint-2010-Logging-Database

http://www.mssharepointtips.com/tip.asp?id=1139&page=1

http://technet.microsoft.com/en-us/library/hh769359%28v=office.14%29.aspx

Thanks Mahesh for prompt reply :)

I researched it thoroughly on logging database and web analytics report and I create my query to get the data from Production server also.

Actually I can't access the production server only I have access to  1. web analytics reports and 2. I give my query to production, they will return the result from DB to me.

Avg Time on the Site  ???   
% New Visitors   ???  
% of Returning Visitors ???  

So, my question how can I get/calculate above special data from my share point.