How to use SCCM CMPivot

Jonathan LefebvreSCCM5 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 FaubertSCCM5 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, SCCM23 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 to identify who imported OSD Computers

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This query might be helpful to know who imported a specific computer. 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. select CASE smsgs.Severity WHEN -1073741824 THEN ‘Error’ WHEN 1073741824 THEN ‘Informational’ WHEN -2147483648 THEN ‘Warning’ ELSE ‘Unknown’ END As ‘SeverityName’, smsgs.MessageID, smsgs.Time, smwis.InsString1 as Username, smwis.InsString4 as ComputerName, smwis.InsString5 as MAC from v_StatusMessage smsgs join v_StatMsgWithInsStrings smwis on smsgs.RecordID = smwis.RecordID join v_StatMsgModuleNames modNames on smsgs.ModuleName = modNames.ModuleName where smsgs.MessageID … Read More