Create your first SCCM Dashboard with Power BI Desktop

Benoit LecoursSCCM3 Comments

Beginning with SCCM/MEMCM 2002, it’s possible to Integrate Power BI Report Server to an existing Reporting Point or to a site that doesn’t have a reporting point installed. Doing so will give you the ability to manage your Power BI Dashboard the same way you manage your SSRS report. All done directly from the console makes it easier to deploy and edit your existing dashboard and to create a new one. You may already use many SSRS reports to monitor and visualize your SCCM data. Microsoft has released Power BI a couple of years ago and has its advantage over SSRS A large amount of data can be processed Rich visuals Less engineering resources to use It can be embedded into your own custom apps System Center Dudes team has decided to develop a series of Power BI dashboard. We think that, if you have the skills, the visualization of your SCCM data should be … Read More

Customize Software Center with SCCM Task Sequence/Package Icons

Benoit LecoursSCCMLeave a Comment

Beginning in SCCM 2203, you can now set a custom icon for Task Sequence and packages in the Sofware Center. In the past, it was possible to add an icon to Applications but not to task sequences and packages. Prior to 2203, task sequences and packages were showing a generic icon which decrease the user experience to identify the needed software. In this blog post, describe the limitations and we’ll show you how to add SCCM Task Sequence and Package Icons to the Software Center. This 2203 new feature is another great addition making SCCM better from an end-user experience perspective. The default SCCM package and task sequence icon can now reflect your purpose instead of this : Display this, to your users : SCCM Task Sequence and Package Icons Requirements Before seeing Task Sequence and package icons, make sure that your site is running SCCM 2203 and that your … Read More

SCCM Upload RDL File to Report Server

Benoit LecoursSCCM, SSRS62 Comments

SCCM Reporting is a great way to see insight of your inventory and data. There’s many custom reports out there on the internet. If you download a custom report, you’ll have a RDL file. This RDL then need to be uploaded on your report server. You can do it manually using the web portal or use a script. This post will show all the ways you can upload an RDL file on an SCCM Reporting Point. An RDL file is simply an XML application and a standard proposed by Microsoft for defining reports. SCCM Upload RDL file Requirements SSRS installed and all running components. If you don’t have a reporting server, you can refer to our post on how to install SCCM 2012 Reporting Services Point. A healthy RDL file. A user account with enough access to upload a report. Please read predefined roles on MSDN for more detailed information. Upload the RDL … Read More

Step-by-Step SCCM 2203 Upgrade Guide

Benoit LecoursSCCMLeave a Comment

Microsoft has released the first SCCM version for 2022. SCCM 2203 has been released on April 8th, 2022. This post is a complete step-by-step SCCM 2203 upgrade guide, meaning that if you want to upgrade your existing SCCM/MEMCM installation to the latest SCCM/MEMCM updates, this post is for you. If you’re looking for a comprehensive SCCM installation guide to building a new server, refer to our blog series which covers it all. You won’t be able to install SCCM 2203 if you are running SCCM 2012. Well, that’s an odd phrase! Thank you current branch naming. SCCM 2203 is a baseline version. This means that if you’re downloading the source from Volume Licensing, SCCM 2203 will be the starting version of your new SCCM site. At the time of this writing, SCCM 2203 is available in the Early update ring. You must run the opt-in script to see it appear in … Read More

Popular SCCM Tips and Tricks

Benoit LecoursSCCMLeave a Comment

If you’re following the SCCM/MEMCM/Configmgr Twitter community, you often see tweets about SCCM Tips and Tricks. Those tweets get a lot of likes and retweets so I decided to compile a list of the most popular SCCM Tips and Trick tweets into a single post. Like our popular SCCM Must Have blog post, we are planning to release an updated version of SCCM Tips and Tricks on an annual basis. We hope that the second round of tips and tricks will hit Twitter soon. Thanks to all the author that took their time to share their tips. Some of these tips were taken from the #30DaysOfConfigMgr initiative launched in March 2020 by Sandy Zeng and Donna Ryan. SCCM Tips and Tricks The list of SCCM Tips and Tricks is in no particular order. Make sure to follow these authors if you’re not doing it already. At the end a couple … Read More

SCCM report subscription ssrs does not list Email in Drop Down Menu

Benoit LecoursSCCM, SQL, SSRS7 Comments

When configuring your Reporting Service on an SCCM server, one of the popular options is to configure reports to be delivered as an automatic email to recipients in your organization. Unfortunately, this option is not always available in the report Subscription wizard. What can you do when your SCCM report subscription SSRS does not list email in the drop-down menu? But first, let’s define what is exactly a Reporting Services subscription : Microsoft definition : A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify. For example, every Wednesday, save the MonthlySales.rdl report as a Microsoft Word document to a file share. Subscriptions can be used to schedule and automate the delivery of a report with a specific set of report parameter values. You can create multiple subscriptions for a single … Read More

SCCM PowerShell Script to Delete Unused Collection

Benoit LecoursSCCM1 Comment

Are you using an SCCM Script to Delete your collection? From all SCCM management activities, collections are arguably the most important object to know about. Collection evaluation, if not configured correctly can have a huge impact on your SCCM hierarchy. This Powershell script will detect and delete SCCM Devices Collections that have no members and no deployment assigned to them. This can be useful to delete unused/unneeded collections. We often see lots of these “orphan” collections after years of management. The less collection, the fewer evaluation task for your server. Why would you want to consume server resources on collections that are useless? Even worst, if you are using incremental collection refresh, it could slow down considerably your server. You can do the whole process manually but it will be difficult to identify and fastidious to delete all collections one by one. This is where Powershell becomes really useful and saves … Read More

Using SCCM Collection variables in Task Sequence

Benoit LecoursOSD, SCCM28 Comments

For this post, I’ve built a little scenario to explain how to use SCCM Collection variables in Task Sequence. I get often asked how to reduce the number of SCCM task sequences and how to make them dynamic. I’m always surprised when I hear from an SCCM administrator that they don’t use variables in their task sequence. Let’s say you are working in an international company and use SCCM to deploy operating systems. Each office has its own configuration and specific software to install. You decide to create 1 task sequence per office. Wrong! You’ll end up in a management nightmare. One task sequence is often enough and this is where you need variables to the rescue. The magic that you need to understand is collection variables. You have 2 choices, let the user enter the variable value at the beginning of the deployment (explain later) or pre-load these values using collection … Read More

How to uninstall or remove SCCM Secondary site

Benoit LecoursSCCMLeave a Comment

This blog post will guide you through the step to remove or uninstall an SCCM secondary site. SCCM Secondary sites have been around since the beginning of the product. SCCM has improved a lot with time and the need for a secondary site is less needed. There are so many new options, especially for content management that you should need an SCCM secondary site. If you have clients in remote network locations, consider using one or more content management options instead of a secondary site. In fact, we don’t remember the last time we installed a new one on a new SCCM site. However, we are still seeing a lot of secondary sites on the existing site that has been installed some years ago. Our general recommendation is simply to replace these secondary sites with a local distribution point and use multiple content management solutions. We like to keep the … Read More

How to Find SCCM Server Log Files

Benoit LecoursSCCM2 Comments

Here’s a simple tip to know which SCCM server logs files to check if you want to dig an error returned by an SCCM Component. In SCCM, client and site server components record process information in individual SCCM log files. You can use the information in these log files to help you troubleshoot issues that might occur. The default path to find the SCCM server logs files is in your SCCM Installation Directory\Logs. If you’ve used the default installation directory, it will be located in C:\Program Files\Microsoft Configuration Manager\Logs. The problem is that when opening this directory, you’ll find dozens of SCCM logs files. When you manage SCCM for multiple years, you get to know which logs to look at, but as a beginner, it can be hard to find the right log. This post aims to help you find the right log file based on a specific component error. … Read More