Solved

Sharepoint 2010: TSQL: Total Unique Visitors in a Month

Posted on 2012-04-05
4
1,576 Views
Last Modified: 2012-04-06
Hello Experts, i was looking to find out a tsql query to find number of unique visitors in  a particular month for a particular site. We do have default Web Analytic report feature in MOSS 2010 but i need to get a tsql to run againt content DB. Any help will be highly appreciated.

Thanks Much.
0
Comment
Question by:resolution11
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 37814809
One way to find out would be to run a profiler trace against your sharepoint server while you run you analytic report to se what t-sql is being run to populate the report
0
 

Author Comment

by:resolution11
ID: 37814987
yes, i know a profiler should capture it. I did ran it once, made all the filters needed but still could not get that. But i was looking, if someone already knows, those queries, that will be really nice.

Thanks Much,
0
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 37815001
What do you mean "could not get that"?
The captured SQL is exactly the statements that SP is sending to SQL Server to return the data.

This might set you on the right road
http://otak-otak-it.blogspot.co.nz/2012/01/how-to-query-sharepoint-web-analytics.html
0
 

Author Comment

by:resolution11
ID: 37816664
Thanks QPR, i will try it.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question