Solved

Sharepoint 2010: TSQL: Total Unique Visitors in a Month

Posted on 2012-04-05
4
1,596 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

730 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