How to install and configure SCCM Power BI Dashboard

Benoit LecoursPowerBI, SCCM31 Comments

Last September, the Power BI solution template for System Center Configuration Manager was released. The SCCM Power BI Dashboard provides detailed information of your SCCM hierarchy including client and server health, malware protection, software updates, and software inventory. Better late than never, we decided to do a blog post on how to link your SCCM server to Power BI and install the SCCM Power BI Dashboard. The SCCM Dashboard will show data as soon as you finish this wizard. You’ll also be able to build your own Power BI reports and publish it if you have a valid Power BI license. If you are not familiar with Power BI, you can read the FAQ which has answers to the most common questions. SCCM Power BI Dashboard System Requirements SCCM 2012 R2 SP1 (5.00.8239.1000) or later An account with Read access to SCCM database is required Destination database: Azure SQL database … Read More

Configure SCCM 2012 to Inventory RAID Controller Drivers

Nicolas PilonHardware Inventory, SCCM, SQL1 Comment

A RAID controller is a device used to manage hard disk drives (HDDs) or solid-state drives (SSDs) in a computer or storage array. It has the ability to access multiple copies of data on multiple physical devices and improve performance with data protection in case of a system failure. We suggest to keep your RAID controller drivers updated to have the latest fixes from the manufacturer. In this post, we will show you how to configure SCCM 2012 to inventory RAID controller drivers to prepare a deployment targeting the affected systems. We will show how to modify SCCM 2012 hardware inventory classes to get this information. RAID Controller Drivers Information You can find RAID controller drivers information in System Information. Launch System Information from msinfo32.exe directly from Run in Start Menu Expand Components / Storage / SCSI In the WMI, the information of RAID controller is in WIN32_SCSIController but it doesn’t include driver version. In this case, you … Read More

How to install Endpoint Protection Point in SCCM 2012 R2

Benoit LecoursSCCM8 Comments

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install SCCM 2012 R2 or SCCM 1511 Endpoint Protection Point (EPP). Role Description The Endpoint Protection Point provides the default settings for all antimalware policies and installs the Endpoint Protection client on the Site System server to provide a data source from which the SCCM database resolves malware IDs to names. When you install this Site System Role, you must accept the license terms for System Center 2012 R2 Endpoint Protection. This is not a mandatory Site System but you need to install a EPP if you’re planning to use SCCM as your anti-virus management solution (using Endpoint Protection). Site System Role Placement in Hierarchy This Site System is a hierarchy-wide option. SCCM supports a single instance of this site system role in a hierarchy and only at the top-level site in the hierarchy. It’s supported to install this role on a Central Administration Site … Read More

SCCM 2012 Useful Resources

Benoit LecoursSCCM3 Comments

I often get question about where to start or where to find the best resources about Configuration Manager. I decided to build a list of the best tools to help you manage your SCCM environment. This list will evolve with time so bookmark this page and come back on a regular basis. SCCM 2012 Books To start learning or to deepen your knowledge, theses are my books recommendation. You can’t go wrong with these authors. They have been working, talking, blogging  about SMS/SCCM since forever. The first 3 are about SCCM in general and the last 3 are more oriented toward system deployments. Education Here’s some links to learn about SCCM. Microsoft Virtual Lab | Installing a demo SCCM environment can be a pain if you don’t have experience. Virutal Labs is THE place to start with SCCM . It allows to run an SCCM virtual machine in your web browser for 2 hours … 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

SCCM 2012 Reports not Running from the Console

Benoit LecoursSCCM2 Comments

SCCM reports are great way of getting information from SCCM 2012. Any users who has access to run reports can see them locally  from SCCM Console on their computer. They can also use the reporting web portal to see them (Usually : http://SccmServerName/reports) Problem Your SCCM Reporting Point is running fine, you can see all reports in the console but SCCM 2012 Reports not running when you : Browse to the Monitoring / Reporting / Reports Right-click any SCCM 2012 report and select Run                                Running the same report from the web portal is working fine Cause Navigate to the console log file C:\Program Files(X86)\Microsoft Configuration Manager\AdminConsole\AdminUILog\smsadminui.log The following error will be displayed : Microsoft ReportViewer Winforms version 10.0.0.0 or one of its dependencies. The system cannot find the file specified This error means that Report Viewer is not locally installed on the computer. Resolution Close … Read More