Alerting and Reporting Pack (ARP) 1.0 for Dell Site Administrator 5.X for #SharePoint from @cmcnulty2000 #SASP #MSBI

We are greatly pleased to present our initial release of the Alerting and Reporting Pack 1.0 (ARP) to Dell Site Administrator for SharePoint.

 

Requirements:

  • SharePoint 2007-2013
  • Dell Site Administrator 5.1.1 or greater
  • SQL Server 2008 R2 or 2012

 

In 2012, we made the decision to move away from embedding a full business intelligence subsystem inside Site Administrator. Historically, Site Administrator for SharePoint (“SASP”) had made close use of Microsoft SQL Server Reporting Services. However, we knew that many of largest enterprise customers also made use of other BI systems and data sources – while some of our smaller environments were unfamiliar with SSRS. ()To be fair, running SSRS in integrated mode on SharePoint 2007 was not trivial.)

 

We made the decision in SASP 5.0 to continue to use the SASP web InfoPortal as the principal way to deliver SharePoint dashboards and reports. However, we recognized that many customers also needed to integrate SASP data with other data sources in their enterprise. So we made all the data elements collected by SASP available for export to SQL Server itself, leaving customers free to decide how best to integrate their data – either by exporting to permanent data warehouses or integrating with other queries and BI subsystems.

 

Figure 1 - Content Databases SSRS Report

 

SSRS reports can be easily deployed to SharePoint document libraries, or rendered using native SharePoint web parts. In addition, PerformancePoint Services (part of the SharePoint Enterprise license) allows for easy delivery of SSRS reports and other BI elements in a convenient tabbed dashboard interface as an optional adjunct to the InfoPortal

 

We also recognize the need to provide a good template for users, already committed to Microsoft technologies, who seek to extend that investment by using the Microsoft BI toolset – including the reporting engine in SQL Server. In that spirit, we’ve released version 1.0 of the ARP as a free, community supported add-on for Site Administrator.

 

We look forward to feedback from the community about this release, and any additional needs or reports you may find helpful. We already have a backlog of enhanced reports and new functions to add in a subsequent release. We appreciate our customers' commitment to SharePoint, to Quest, and to Site Administrator for SharePoint. We hope that the ARP helps demonstrate our commitment to you. Please let us know how we can assist further. Thanks.

What’s In ARP 1.0

The ARP provides SSRS reporting files (.RDL) for each of the major reporting areas in the Site administrator Info Portal, as noted below. When each report’s data is “exported” to SAL using the Export Scheduler function provided in SASP, that data set is stored in a separate corresponding SQL table in the SASP reporting database. Each of these reports is published in the SASPReports folder of the ZIP file.

 

InfoPortal Report

SQL Table

SQL Report

Servers

sa4sp_repdata_servers

  1. Servers.rdl

Content Databases

sa4sp_repdata_contentdbs

  1. ContentDatabases.rdl

Web Applications

Sa4sp_repdata_web

  1. WebApplicatons.rdl

Site Collections

sa4sp_repdata _site_collections

  1. SiteCollections.rdl

Documents and Pages

sa4sp_repdata _documents_and_pages

  1. DocumentsAndPages.rdl

Lists

sa4sp_repdata _lists

  1. Lists.rdl

Document Libraries

sa4sp_repdata _document_libraries

  1. Libraries.rdl

Sites

sa4sp_repdata _sites

  1. Sites.rdl

Site Permissions

sa4sp_repdata _site_permissions

  1. SitePermissions.rdl

Security Changes

sa4sp_repdata _activity_Security

  1. SecurityChanges.rdl

Daily Usage

sa4sp_repdata _daily_active_users

  1. DailyUsage.rdl

Content Changes

sa4sp_repdata _activity_Content

  1. ContentActivity.rdl

 

However, one of the most consistent customer requests for Site Admin has been alerting – how best to notify stakeholders when key data elements cross critical thresholds, such as

  • Database size approaching 200GB
  • File versions greater than 10
  • Sites with particularly high daily usage levels
  • Low disk space on SQL servers

 

Although there are many ways to setup alerts, SSRS itself provides integrated alerting when reports are delivered through the SSRS Shared Service Application introduced as part of SQL Server 2008n R2.

 

We’ve also included an extra report, Site Collections Billing (SiteCollectionBilling.rdl). This is a sample report that joins site collection database usage with cost centers and billing rates form an external data source to generate a monthly chargeback report.

Anonymous