none
How to query wss_logging DB

    Question

  • Hi,

    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, ...

    I don't know which table, which filter use

    Thanks

    
    
    Tuesday, August 26, 2014 8:28 AM

Answers

  • Hi,

    Please use the analysis log files too in here it will do the same for you by getting pages consulted by user

    http://gallery.technet.microsoft.com/sharepoint/The-SharePoint-Flavored-5b03f323#content

    Please let me know if it is helpful

    Kind Regards,

    John

    Tuesday, August 26, 2014 11:06 AM
  • check the below URL but dealing with DB direct is not allowed there is tool called SharePoint Diagnostic Studio that is mainly for SP2010 but works with 2013 you can download it from Microsoft

    http://epmainc.com/blog/capturing-performance-counters-sharepoint-and-project-server-logging-database-part-2


    Kind Regards, John Naguib Technical Consultant/Architect MCITP, MCPD, MCTS, MCT, TOGAF 9 Foundation

    Tuesday, August 26, 2014 1:25 PM

All replies

  • Hi,

    Please use the analysis log files too in here it will do the same for you by getting pages consulted by user

    http://gallery.technet.microsoft.com/sharepoint/The-SharePoint-Flavored-5b03f323#content

    Please let me know if it is helpful

    Kind Regards,

    John

    Tuesday, August 26, 2014 11:06 AM
  • check the below URL but dealing with DB direct is not allowed there is tool called SharePoint Diagnostic Studio that is mainly for SP2010 but works with 2013 you can download it from Microsoft

    http://epmainc.com/blog/capturing-performance-counters-sharepoint-and-project-server-logging-database-part-2


    Kind Regards, John Naguib Technical Consultant/Architect MCITP, MCPD, MCTS, MCT, TOGAF 9 Foundation

    Tuesday, August 26, 2014 1:25 PM