I've a site with a lot of sub site and i'd like to do some query in the table RequestUsage to retrieve the pages consulted by user, site
The pages edited by user , site, Pages deleted etc.
I don't know which table, which filter use?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
it’s fully supported by Microsoft to directly read, query and build reports from the logging database. As per TechNet:
A single place that stores various monitoring information helps you efficiently monitor SharePoint Server 2010 servers and services. More importantly, you can create your own reports for unique monitoring, reporting and troubleshooting requirement based on tables inside the logging database. This article describes how to create reports using existing tables and views.
MSFT provide you some pre-define views and you can also write your own views as well.
Also check this: