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

Benoit LecoursSCCM, SQL, SSRS6 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

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

Getting started with SCCM Powershell cmdlet

Benoit LecoursPowershell, SCCMLeave a Comment

You can run SCCM Powershell cmdlet and scripts from the SCCM console or from a Windows PowerShell session. This is very useful to do stuff in SCCM without using the console. You can do pretty much anything using Powershell. When you get used to it, you can write more complex scripts to automate and save lots of time. Supported versions of SCCM’s current branch support Windows PowerShell version 5.1. Starting in version 2010, the Configuration Manager PowerShell cmdlet library supports PowerShell 7.  If you’re not familiar with PowerShell and SCCM, the easiest way to connect to your site is to use the shortcut in the console : In the SCCM console Select the upper-left white arrow choose Connect via Windows PowerShell A Windows PowerShell loads, you’ll see a prompt that contains your site code. For example, if the site code is “SCD”, the prompt will show: PS SCD:\> SCCM Powershell Cmdlet Syntax … Read More

Create Operational SCCM collection using PowerShell script

Benoit LecoursPowershell, SCCM26 Comments

Using Powershell you can do many things in SCCM. Over the years, in many SCCM consulting projects that we got involved in, we get the same question: “Can you create SCCM collections for Servers, Laptops, Workstations, Windows 10…”. Back in 2015, I started to build an SCCM collection PowerShell script to create these operational collections that I create right after we do an SCCM installation. With time, I added more and more collections to the script. Today, the script contains more than 130 collections and has been downloaded more than 60 000 times making this my most downloaded contribution to the community. This set of collections usually covers 95% of the initial client needs. All you need to do is to run the SCCM collection PowerShell script on your SCCM server and wait. After running, you’ll end up having 134 collections in an Operational folder. The collections are set to refresh on a … Read More

SCCM Client Version and Cumulative Update List

Benoit LecoursSCCM97 Comments

SCCM Client Version Report

We compile a list of SCCM client version, build numbers and cumulative updates since the 2012 RTM release. SCCM Upgrades are released 3-4 times a year. After an SCCM Upgrade, it’s important to upgrade your SCCM Client version to the latest version. Cumulative updates are cumulative, meaning that the latest one includes the previous one. (Ex: You don’t need to apply CU1 if you plan to install CU2) Once you apply a cumulative update, your SCCM version on the site server itself will not change. The site server will show the latest major SCCM release (RTM,SP1,R2). However, the new SCCM version numbers will show on your Consoles and Clients. We recommend that you upgrade all your clients when you are applying the latest SCCM version. We release a step-by-step guide on how to update your SCCM server each time a version comes out. Just use the link next to the client … Read More

Creating an SCCM report viewer role

Benoit LecoursSCCM2 Comments

In many SCCM environments, we see administrators that want to give access to the SCCM reporting node only. Unfortunately, there’s no SCCM Report Viewer role when you browse to the Security role of the console. So … What if you want to give a user the right to only run reports? This blog post will show how to create an SCCM report viewer role in the console. A simple way to do this is to grant access to the Read-only Analyst role which will be enough to run a report but maybe you don’t want them to see all nodes and get lost in the console. If you’re unfamiliar with role-based administration, we suggest you first read the Microsoft docs which explains the basics. It combines security roles, security scopes, and assigned collections to define the administrative scope for each administrative user. We’ll use this concept to create a new … Read More

Send an Email when SCCM OSD Completes a Deployment

Benoit LecoursPowershell, SCCM32 Comments

When deploying an operating system with SCCM / MEMCM, monitoring your deployment is crucial. You can use reports in a more dynamic way. Imagine receiving an email saying “Hey your deployment is complete. The computer can be delivered to the client”. SCCM can send an email based on a specific status message generated by the site server. And this is exactly what will be done in this blog post. SCCM records everything action in Status Messages. You are probably familiar with the tons server logs files but SCCM also records everything on the site server itself. A quick look at the Status message shows that there’s tons of available information. Status Message In the SCCM Console Go to Monitoring / System Status / Status Message Queries / All Status Message Status Message shows all actions, there’s lots of valuable information in there Yeah great !… now what? Using the power … Read More

Useful SCCM CMTrace tips

Benoit LecoursSCCMLeave a Comment

If you’re new to the SCCM world, you have to know that SCCM comes with a log viewer. CMTrace is the tool you need to use to read any SCCM log files. We still meet lots of SCCM admins that don’t know some basic CMTrace features. We’ll show you a couple of SCCM CMTrace tips to improve your skills. In SCCM, client and site server components record process information in individual log files. You can use the information in these log files to help you troubleshoot issues that might occur. By default, SCCM enables logging for client and server components. For more general information about log files in Configuration Manager, see About log files. This article includes information on the tools to use, how to configure the logs, and where to find them. SCCM CMTrace tips #1 The first tip we want to share is the Error Lookup feature. Built-in CMTrace, you … Read More

Monitor SCCM Task Sequence Progress

Benoit LecoursSCCM, WINDOWS 104 Comments

When deploying Windows 10 operating system using SCCM (OSD), you will need to monitor SCCM task sequence progress. This allows us to track task sequence start, end time and most importantly errors (if any). Our post will show 4 different ways to monitor SCCM task sequences. Each of them has its own benefits and drawbacks. Monitor SCCM Task Sequence Using the Console You can view the progress of a task sequence using the SCCM console. This method is simple and easy but permit to see the status of only one machine at the time. If your deployment staff don’t have access to the console or view deployment status, this option is not for you. Open the SCCM Console Go to Monitoring / Deployments Search and right-click the deployment linked to your Windows 10 task sequence On the menu, select View Status In the Deployment Status screen, select the In Progress tab for a running … Read More

New Product – SCCM Migration to new operating system Guide

Jonathan LefebvreSCCM10 Comments

With the release rhythm of SCCM and latest requirements on the OS and SQL side, sometimes, it’s inevitable to migrate to a newer operating system to remain under support and also gain new features as part of the latest SCCM Current Branch release.This product is a complete SCCM Migration Guide. Over the years, we’ve done many migrations of all kinds, depending on the environment and needs. We created this complete SCCM Migration to new operating system guide based on our knowledge and experience. This guide is a refreshed version of our previous post about Side-by-Side Migration to new Hardware. It also includes answers and how-to to the most commonly asked questions on side-by-side migration. Also included: all the details to achieve the migration to a new operating system by using the Backup and Restore strategy. This guide aims to help SCCM administrator evaluate, plan, understand and achieve a migration to … Read More