SQL Server Report Packs for IIS and SPS

Monday, July 11, 2005 8:11 AM

[via Mark Harrison]

There are two “report packs” which are SQL Server Reporting Services 2000 canned reports for IIS and SharePoint Portal Server.

SQL Server Report Pack for SPS:

  • Storage Report Shows a listing of the virtual servers and the number of collections, sites, areas, lists, files and size. Also shows a size distribution and storage usage chart, and a top 20 sites based on size.
  • Storage Trend Report Shows four charts illustrating the virtual server storage trend, site collection growth trend, area growth trend and list growth trend.
  • Site Trend Report Shows hit counts for virtual servers, collections, areas and lists. Also shows the top 20 sites based on hits.
  • Comprehensive Site Collections Report Shows the list of site collections, who owns the collection, configurable characteristics about the owner and the date the collection was last accessed.
  • Detailed Site Collection Report Shows top 20 pages accessed (based on hit count) for this site collection.
  • Detailed Page Report Shows users who have access to the page, when they last accessed it, any referrer URL and number of hits. Also shows two charts illustrating user distribution and referrer distribution.
  • Best Bet Keyword Shows top 20, top 10, bottom 10, or bottom 20 keywords used for searching. Also shows which keywords have best bets.
  • Search Terms Shows top 20, top 10, bottom 10, or bottom 20 search terms used for searching. Also shows which search terms match a defined keyword.

More info here, download here.

SQL Server Report Pack for IIS:

  • Global Statistics Contains a top-level summary chart of visits and bandwidth for one or more sites with drill though for each month.
  • Site Summary Contains a site summary for a specified site, month, and year. Includes a document map and all other detail reports.
  • Time Period Shows a parent report with subreports containing time and date based visitor statistics.
  • Day of Week Contains bar chart, bubble chart and table with visitor information per day.
  • Hourly Statistics Contains a chart and table with visitor information per hour of the day.
  • Day of Month Contains chart and table with visitor information per day of the month.
  • OS Statistics Shows a table containing of the number of visits based on the operating system type. Also shows detailed chart with version information for Windows OS visitors.
  • Browser Statistics Shows a table containing the number of visits based on the browser type. Also shows detailed chart with version information for Internet Explorer visitors.
  • Country Statistics Contains a breakdown (table and chart) of the number of visits based on the country of origin.
  • Length Statistics Contains a breakdown (table and chart) of the number of visits based on the amount of time spent on the site.
  • Pages Contains statistics about the top 5 most viewed pages on the site.
  • Visitors Contains of sub reports of Web site visitor statistics grouped by time and date.

More info here, download here.

comments powered by Disqus