Step-by-Step SCCM Report Creation using Report Builder

Benoit LecoursREPORT, SCCM, SSRS8 Comments

One of our favorite tasks when it comes to ConfigMgr management is SCCM Report Creation. Not only it bring value to an SCCM installation, but it also brings visibility to your hard work toward your management. Without SCCM reports, this huge management tool is running silently on all your devices but you’re not benefiting from all the advantages. It’s like having a sports car and discovering the Autobahn … ok maybe not. But what makes a good SCCM report? Data, data, data This is the more important part of your reports. You need to query the right SQL views in the SCCM database. If you’re showing incorrect information, your report will be useless Building an efficient SQL query is the hard part of report creation. Without any SQL skills, it will be hard to achieve what you want… but, everything can be learned. Two years ago I’ve never done an … Read More

Complete SCCM 2012 SQL Install Guide

Benoit LecoursSCCM47 Comments

In the first part of this SCCM 2012 and SCCM 1511 blog series, we planned our hierarchy, prepared our Server and Active Directory. In part 2, we will install and configure SQL before installing SCCM 2012 R2 or SCCM 1511. Click the following link to see all supported SQL versions. For our post, we will install SQL 2012 SP2 locally on the same server where the Primary Site will be installed. SCCM 2012 SQL Install Guide Execute Setup.exe from the SQL installation media, select New Installation Review and Click Next Select Enter Product Key and skip the proposed updates. We will install CU4, later Select SQL Server Feature Installation Select the Database Engine, Reporting Services and Management Tools features and specify the SQL installation directory. This is the directory for the program files and shared features Select Default instance and ensure that your instance is created on the SQL Volume Review and click Next Set all … Read More