SharePoint 2010 - Web Analytics Reports - Top Visitors results limit

Hello,

In Central Administration -> Monitoring -> View Web Analytics Reports, in any web application for the Top Visitors I can get a maximum of 2000 results. This appears to be the default maximum. Does anybody know if there is a way of getting more that 2000 results?

Thanks,

Mauro

July 16th, 2015 7:54am

Hi,

According to your description, my understanding is that you want to get more than 2000 results about top visitor report in SharePoint Web Analytics Reports.

By default, A rank report shows the top 2000 results for a particular metric. As a workaround, you could query the web analytics reporting database to get the complete result.

More detailed steps about how to get the complete result for your reference:

http://askraghuabtsp.blogspot.com/2013/05/sharepoint-2010-top-visitor-report.html

Thanks,

Dean Wang

Free Windows Admin Tool Kit Click here and download it now
July 17th, 2015 9:31am

Hi Dean,

Thank you for your quick answer, do you know if the script also works for whole web application? Otherwise I will need to run the script for each site collection.

Thanks,

Mauro

July 17th, 2015 12:10pm

Hi Mauro,

According the query, it works for site collection. You could obtain all site collection IDs by coding and loop the query by IDs.

Any help about SQL statement you could post to the Transact-SQL forum, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge. 

The URL of the Transact-SQL forum:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql

Thanks,

Dea

Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 2:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics