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 brings value to an SCCM installation, it bring visibility on your hard work toward your management. Without SCCM reports, this huge management tools is running silently on all your devices but you’re not benefiting of all the advantages. It’s like having a sport 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 … 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 … Read More