How to use SCCM CMPivot

Jonathan LefebvreSCCM8 Comments

SCCM Current Branch 1806 is loaded with amazing features. In this post, we will cover the latest addition in the reporting space: CMPivot. SCCM has always been good with reporting and inventory of it’s managed devices but SCCM data is up-to-date at the last time the inventory has been run. SCCM CMPivot allows SCCM administrators to initiate a live query on selected computers on a specific topic. The result of that query can then be used to mitigate and fix potential issues. How many time were you asked “what is the current state as of NOW?” well, you’ll finally be able to answer … Read More

How to use SCCM Dynamic Queries in your Deployment Collections

Stephane FaubertSCCM6 Comments

In this post we will be looking at using SCCM dynamic queries to populate collections in our deployments. As a SCCM administrator, you most likely had to plan out mass deployments to all your servers or workstations or even both. How did you go ahead and populate your collections? Queries? Since the introduction of SCCM 2012, we now have a multitude of options, most notably: Direct membership Queries Include a collection Exclude a collection Chances are, if you are deploying a new software to be part of a baseline for workstations (for example), you will also add it to your task … Read More

How to manage your Distribution Points with Collections

Jonathan LefebvreSCCMLeave a Comment

Do you have a high number of distribution point in your SCCM environment? Managing large SCCM environment with many Distribution Point or Pull Distribution Point is not an easy task. We’ve done a great post on 8 ways to monitor your Distribution Point, it was most related to the console monitoring and reports. We also provided a report to manage content on your Distribution Point. Additionally, you can use collections to regroup Distribution Point based on specific information. The advantage of using collections is that an action that can be taken based on the membership. (compliance settings, applications, etc.) This post will explain … Read More

PowerShell Script Create Operational SCCM Collections

Benoit LecoursPowershell, SCCM25 Comments

PowerShell Script Create Operational SCCM collections In each SCCM project that I get involved, I get the same question : “Can you create a collection for Servers, Laptops, Workstation, Windows 7, Windows 8, ect…” With time I built a set of “Default” query for device collections that I create right after the initial SCCM setup. This set of collection usually covers 95% of the initial client needs. I’ve built a PowerShell script so the effort to create 56 collections is near to none. By running the Powershell script, you’ll end up having 56 collections in a Operational folder. The collections are set to refresh on … Read More

Configuration Manager Servicing Extension

Benoit LecoursSCCMLeave a Comment

Updated 2014-12-09 : The tool is no longer in Beta version. It’s now available for download here The SCCM Product team has just release an interesting “Configuration Manager Servicing Extension” that add nice features to the SCCM console. Here’s the major features : Notifies you of Configuration Manager updates as they become available, with the ability to filter updates according to which major release they apply to Provides details on the sites in your environment, including the last major Configuration Manager version installed and the most recently installed Cumulative Update Provides a list of Configuration Manager client versions that may be … Read More

sccm query imported computer

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This sccm query imported computer might be helpful to know which user imported a specific computer. You add a new computer directly to the SCCM database by calling the ImportMachineEntry Method in Class SMS_Site. This can be used to deploy operating systems to computers that have not yet been discovered automatically by SCCM. You can view this information in the Status Message Queries and search for MessageID #30213. But this query will target only the information you need. You can use this query to create a report or directly in SQL MS. This query won’t work to create a collection since it’s … Read More