Solved

Sharepoint 2010: TSQL: Total Unique Visitors in a Month

Posted on 2012-04-05
4
1,556 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

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…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

773 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