How to get detailed Site information (# of lists, libraries) via Web Application Reports? - SharePoint Management - SharePoint for All - Dell Community

How to get detailed Site information (# of lists, libraries) via Web Application Reports?

How to get detailed Site information (# of lists, libraries) via Web Application Reports?

This question is not answered

Hello,

Is it possible to generate Site Metrics report at the Web Application level using Quest Site Admin? We are looking to gather information on # of lists, # of libraries etc for all site collection in a Web Application. So far we have found that only way to gather # of lists, libraries etc is via Site Metrics report but that is only available per site, not at the web application level.

Please let me know if i need to clarify.

Thank you.

All Replies
  • We don't have report with these numbers.

    As an option

    Try the new featue of 5.1.1 - enterprise collector

    http://sahelp.sharepointforall.com/TableRepDataGathering.html

    It collects all information to tables in repository (list of tables is in documentation) - then you can use simple SQL queries to get statistics.

    For example count of all doc libs in webapp:

    select count(*)  from [sa4sp_repdata_document_libraries] where [web url] like 'http://webapp/%'