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?

  • Sorry but i don't understand your link – user1898765 Aug 26 '14 at 9:04
  • It's unsupported to query SharePoint databases, just a heads up. – Christoffer Aug 26 '14 at 9:18
  • 1
    it's false, the db wss_logging is there for reporting – user1898765 Aug 26 '14 at 9:30
  • It's true, and yes the wss_logging is there for reporting but to directly query the db is not supported. Use the object model or enable auditing settings on a site to get ootb webparts for reporting. – Christoffer Aug 26 '14 at 11:30

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.

Pre-defined SQL views in the logging database Custom SQL views in the logging database

Also check this:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.