How to: Create custom SQL- based Reports in System Center 2012 R2: Configuration Manager

A customer asked me  for a “how-to” on how to Create reports in SCCM 2012, so why not share with everyone. This post is not intended to show how to write or design queries, but show you have to create  a report based on a SQL query you might already have. Even-though we are skipping […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager 2012, Configuration Manager 2012 R2, Configuration Manager 2012 SP1, Home, Microsoft SQL, SQL Reporting services  |  1 Comment

Error when running Application reports in ConfigMgr 2012

During the SQL Reporting Services site system role, SCCM automatically create a login in SQL and assign the required permissions to the account that you have specified. However I have seen several times that the account do not have the permissions required to run some of the Application reports.   When running the Software Distribution […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, SQL Reporting services, Tips and tricks, Troubleshooting  |  5 Comments

State of the Empire: How to use E-mail Notifications in ConfigMgr 2012 SP1

In the old days you found out something was wrong when phones started to ring and senior management was at you "doorstep" with an angry look. In Configuration Manager 2012 SP1 we have many ways of being proactive with the state of our environment and the state of our precious clients. In this blog post […]

Category: Configuration Manager 2012 SP1, SQL Reporting services  |  5 Comments

Configure E-mail Notification component in ConfigMgr 2012 SP1

In order to send Alert notifications or Reports via E-mail we need to make some configurations in the Console and in SQL Reporting Services Configuration Manager. In the Administration section select the Site Configuration folder and click Sites. In the Ribbon click Configure Site Components and select E-mail Notification. Enter the details for the SMTP […]

Category: Configuration Manager 2012 SP1, SQL Reporting services  |  4 Comments

Role Based Administration change in ConfigMgr SP1

RBA or Role Based Administration is one of the many new features in ConfigMgr 2012. It’s a very powerful feature and has already helped lots of customers minimizing the need for having multiple primary sites. One annoying fact in RTM is that all collections (users and devices) shows up when running a report. This has […]

Category: Configuration Manager, Configuration Manager 2012, Security, SQL Reporting services, Tips and tricks  |  Comment

No SRS Reports showing up in SCCM console

During a recent SCCM 2012 installation for a customer, we ran into some strange problems with the Reporting services point and the SCCM console.

Category: Configuration Manager 2012, SQL Reporting services, Troubleshooting  |  7 Comments

Error installing SQL Reporting Builder 3.0 in ConfigMgr. 2012

It has happen to me before, and it will happen again. I ran my ConfigMgr. 2012 administrator console without starting it as Administrator. When trying to edit a report I got the error message: Report Builder 2.0  is not installed as a click-once application on report server The error message is kind of funny, as […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, SQL Reporting services, Tips and tricks  |  Comment

Timeout Expired on Report Server

One question I often get from System Center folks is about the SQL Reporting Services and report timeout. Unfortunately Microsoft have an default value on many report dataset which is to low for an production environment. The easy solution would be to edit the RSReportServer.Config XML file, I mean – in this file we have […]

Category: Config Mgr. SP2, Configuration Manager, Home, SQL Reporting services  |  2 Comments

SQL Reporting Services and antivirus settings

Just installed and configured SQL Reporting Services 2008 with ConfigMgr. 2007 R2 SP2 this morning. Everything went smoothly except for one minor detail; I got an error in my mail subscription: Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not […]

Category: Config Mgr. Inventory and Reporting, SQL Reporting services, Troubleshooting  |  Comment

Creating a basic Config mgr. report with SQL reporting services

Converting the Configuration manager ASP reports to SRS reports (SQL Reporting Services) is a really easy task. Once you want to modify or create new the reports you need to a little more work. I create reports using these applications. SQL Server Report Builder 1.0 SQL Server Report Builder 2.0 (requires SQL Server 2008) Business […]

Category: Config Mgr. Inventory and Reporting, SQL Reporting services  |  1 Comment