What is RicherReports?
RicherReports 2.0 is a highly customized reporting solution for System Center Configuration Manager built on SQL Server Reporting Services 2016, designed for Configuration Manager. Creating a beautify alternative SSRS report server portal view for accessing and running SQL Reporting Services reports. Using a navigation menu system that enables accessing reports fast and easy. Additionally, RicherReports aggregates all reports published to a SQL Reporting Service report server making those report easily accessible and report names readable.
Over the last 16 years, we found ourselves focusing our attention on how clients wanted to see their data in reports and yet wanted reports to be meaningful and pleasant to look at especially when it comes to presenting that data to management in dashboards.When displaying data and reports in dashboards, the developer or owner of the reports may not be around to answer the questions that arises about the data. So We wanted to develop reports that answers the questions for your that might come to mind. we also add Tool-tips to show when the mouse hoovers over KPI's allowing for anticipated questions to be answered right in the reporting dashboard.
When it comes to capturing and discovering system management data and displaying that information in a meaningful and beautiful way as well making it easy to find and access the right reports, RicherReports brings the beauty and custom visualization to reports along with industry used customized reporting solutions and ideas of the field together in one reporting solution.
We wanted to build a portal for the SQL report server on the platform that's integrated with Configuration Manager as well as on a platform the industry is moving towards. The portal had to be a simple solution that aggregates reports with a menu style making navigating for finding and accessing the right reports hosted by SSRS easy.
At least for the SCCM Guys, we know the default SCCM reports are not that pleasing to look at, but they do provide the data and meaningful information we need. So we have taken note of the most used and useful reports, data that is leveraged and recreated and customized reports making the easily accessible thru RicherReports report server portal report.
With RicherReports Customized Solutions consulting services, we can help you bring other organization data sources into the RicherReports reporting solution, for example: Active Directory, Service Manager, Operations Manager, Microsoft BitLocker Administration and Monitoring, OMS etc.
Benefits of RicherReports 2.0
Report Server Portal
For example, look at the screenshot of a SQL Reporting Services report server portal. The report server portal shows published reports and folders in a flat format that is liner and seems a bit difficult to search for a report due to some of the report names are truncated. Unless you access the same report often or have a saved bookmark to for a specific report, you’ll find yourself spending some time looking and searching for a desired report you might be interested in.
Our Server Portal
Compared to the SQL Reporting Services report server options for navigating reports, as you can see below that navigation are better, and groups reports in categories. If there is no report for a specific category, that category will not show. You can even publish your own custom reports to a SQL Reporting Services report server with a specific naming convention in the RicherReports default folder, your report will show it the RicherReports navigation panel. If you publish your custom report to any other folder, your report will show under Local Reports.
RicherReports 2.0 consists of highly customized SQL Reporting Services reports built and designed to run on SQL Reporting Services 2016 platform for System Center Configuration Manager, improving the user experience when accessing reports published to SQL Reporting Services report server.
Local reports are any existing reports published to SQL Reporting Services that RicherReports discovers and aggregates these reports in the navigation panel located under Local Reports for a seamless integration into the RicherReports menu.
Sub-Folder / Sub-Menus
RicherReports will also discover all reports published to the report server and group those reports based on the subfolders reports are located in, including creating a submenu structure based on reports location.
RicherReports will also remember the last 10 recent reports that was access previously giving you the option to easily find and access commonly used reports.
There is an All collections default report that comes with Configuration Manager, Shown below… This report has three columns, Name, Comment and Collection ID.
Now Let's Review
Let’s call out the noticeable difference between these two reports. This report to the right shows 12 columns, Collection ID, Collection Name, Comment, Members, Numbers of clients, Number of Virtual Machines, MDM Managed, Site Code Is Approved, Is Blocked, And Last Refresh Time.
And To Continue
Column names speak for them self. But as you can see you get allot more helpful information at first glance across all selected collections when using All Devices Collections and Members report. This type of report provides the opportunity to compare collections.
Even More Details
The All Devices Collections and Members report goes even further, it also provides the option to click the + plus sign and drill into the members of each collection from the view of the same report.
More and More
After drilling into the report, you'll also have the option to click on a computers name and get more information about that devices. The All Devices Collections and Members report will also show the virtual host if the devices happens to be a virtual machine.
Let's look at some of the improvements of the default Configuration Manager reports.
Let's look what you see on the first view when accessing a default Configuration Manager report on the Reporting point, which is actual SQL Reporting Services report server. The screen shots was taken when using Internet Explorer.
SQL Reporting Services report server
The following report is the initial view after clicking on the ConfigMgr reports folder in the SQL Reporting Services report server portal. Notice each reports folder for various categories.
Oh My God!
RicherReports 2.0 report server report
The following is the initial view after clicking on the ConfigMgr Default Reports folder in RicherReports 2.0 report server portal. Notice each reports folder in the left navigation menu for various categories each representing the report folder shown above.
Now lets compare a commonly used ConfigMgr report used for determining the Software Update compliance for a deployment group across a selected collection.
SQL Reporting Services report server
Notice the formatting and how the two different tables are off centered and not aligned. This makes viewing the default reports unpleasant.
RicherReports report server report
Notice the difference in the reports. Both are Complinace 1 - Overall compliance reports for the same Software Update deployment group and selected collection.
Let's look at a more complex report
Lets compare a Power Manager report, specifically the Power Management - Computer activity report. The screen shot below is the ConfigMgr default report version.
And the following screen shot is of the same report and data shown thru a customized version of the same Power Management - Computer activity report.
Let's take a look at a simple All collections report. First the default ConfigMgr All collection report.
Now take a look at the same All collections report viewed thur RicherReports 2.0 report server portal.
RicherReports 2.0 improves reporting, usability and accessibility of reports published to a SQL Reporting Services report server.
Custom Configuration Manager Reports
Now lets look at some custom ConfigMgr reports that are included with the RicherReports 2.0 Custom reporting solution. Starting from some of the default ConfigMgr reports, we elaborated a bit more on those reports to create the following custom ConfigMgr reports. These are some real examples of some of the reports that are included in RicherReports.
When you run the Device Collections and Members report, you're presented with a select option that allows you to select the collections you want to view and see more information for. Then once the report renders, you are presented with a wealth of information regarding the selected collection.
For example: you can see the number of members of a specific collection, number of systems that are clients, or virtual machines, if the device is managed by MDM or not. Active clients, number of sitecode's, if the computer is blocked or not. You can also see the operating system of devices, domain and even client version. You also have the option to client on a computer name and get more detailed information about that computer from the same report.
That's the beauty of RicherReports, it brings reporting data together as well as have a nice flow from one report to another. If you want RicherReports customized to fit your organization, please contact us today for a quote.
Features & Capabilities
All System BIOS Details report
This custom All System BIOS Details report shows all computers grouped by Operating System and reveals the Bios version information discovered by System Center Configuration Manager. It also shows the Bios released date, the OS installation date, domain and Active Directory site name the computer is in.
Discover Manufacturer and Models report
Ever wanted to know how many different versions of Operating Systems you have across all hardware?
This custom Discover Manufacturer and Models report shows all computers grouped by the hardware manufacturer and model, then by Operating System providing you a count of computers by Operating Systems. This report will give you a quick view into this type of data for preparing for an Operating System deployment project or simply wanting to know this information maybe for licensing purposes.
All Deployment Groups report
Features and Options
This custom All Deployment Groups report shows a list of all Software Update deployment groups and some status information about the deployment group.
- Shows the deployment groups description provided.
- Shows if the deployment groups is deployment or not.
- Shows the last modified and created date.
- Shows the targeted collections name and collection ID.
- Click-drop-down action on the Title to show additional detailed information about the deployment.
- Shows a deployment statistics bar chart on the right side of the report after using the Click-drop-down action.
- Click-thru action on the targeted collection name to shows members of the targeted collection in another report.
This report can be future customized based on your organizations requirements and when you purchase RicherReports 2.0 Customized that includes consulting services for RicherReports 2.0 Reporting Solutions.
Organizational Unit Members and Subnet report
Have you ever want to see the structure of your Active Directory Organizational Unit as it relates to where clients are sitting on subnet's within your network, as well have see a break-down is how Operating Systems saturate the network across your Active Directory environment?
This custom Organizational Unit Members and Subnet report will show you just that. Of course this report can be customized to your liking or requirements.
Per Update Status In A Deployment report
The custom Per Update Status In A Deployment report shown above starts off by presenting you with 2 select options to choose the deployment group and one for the targeted collection. There may be multiple collections targeted by the deployment, so select 1 collection is required. After running the report you get the following report details per the selected Software Update deployment group.