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

Step-by-Step SCCM Installation and Configuration Guide

Benoit LecoursSCCM46 Comments

The new version of SCCM is out ! You may know this version as SCCM Vnext, SCCM 2016 or SCCM 1511. The product group explained on their blog that the new version will be simply called SCCM Current Branch. This blog post is a complete Step-by-step SCCM Installation Guide. SCCM installation has never been an easy process and the product itself can be complex for inexperienced administrators. With these blog posts, our goal is to bring it a bit further, explaining concepts and best practice rather than just guide the user through the installation process. If you’re not familiar with SCCM 1511 Features, you can visit this Technet article which covers it all. If you’re familiar with SCCM 2012 and plans to migrate, read our blog post about What’s New in SCCM 1511 and stop reading this guide. You do not need to do a complete installation if you’re already running SCCM 2012. See our blog post on how … Read More

Step-by-Step SCCM 2012 R2 Installation Guide

Benoit LecoursSCCM22 Comments

  Download and own part 1 to 18 of the SCCM 2012 R2 Installation Guide in a single PDF file. Use our products page or use the download button below. This blog post won’t be updated, only the document will be. [purchase_link id=”3614″ style=”button” color=”Gray” text=”Guide | SCCM 2012 R2 Installation Guide | Part 1-18″ direct=”true”]   Performing a SCCM 2012 R2 installation is not a walk in the park. The product itself can be complex for inexperienced administrators. There’s already tons of SCCM 2012 R2 Installation Guide available, written by experienced blogger and MVPs but I think that very few gives the whole picture from the start to the last component. Our goal is to bring it a bit further, explaining concepts and best practice rather than just guide the user through the installation process. We was hesitant to post this SCCM 2012 R2 Installation Guide because SCCM VNext is coming pretty fast (Release date could … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS22 Comments

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install a SCCM 2012 or SCCM 1511 reporting services point. This role can be installed on a remote machine, the process is the same but the logs location is different. Requirements Before you can install the reporting services point role you must configure SQL correctly. We’ll be using SQL 2012 on this post. We are assuming that SQL is already installed and that your SCCM site is up and healthy. During the initial SQL installation, you must select Reporting Services. If you have installed SQL Server, but have not installed Reporting Services follow the following steps. If Reporting Services is already installed, skip to the “Configure Reporting Services” section. Launch the SQL Server 2012 installation from the media. Click the Installation link on the left to view the Installation options. Click the top link, New SQL Server stand-alone … Read More