[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sharepoint 2010: TSQL: Total Unique Visitors in a Month

Posted on 2012-04-05
4
Medium Priority
?
1,720 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 1000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

864 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