We are greatly pleased to present our initial release of the Alerting and Reporting Pack 1.0 (ARP) to Dell Site Administrator for SharePoint.
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.
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.
Documents and Pages
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
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.