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

The Microsoft Software License Terms have not been Completely Downloaded

Benoit LecoursSCCM, SQL7 Comments

Problem – the Microsoft software license terms have not been completely downloaded SMS_WSUS_SYNC_MANAGER state is critical even if it worked in the previous months. Wsyncmgr.log shows the error on 2 updates : The Microsoft Software License Terms have not been completely downloaded and cannot be accepted Environment in use when this issue occurs SCCM 2012 R2 SQL 2012 Windows 2012 R2 Event viewer/Application Logs shows Access Denied errors on a different patch. Resolution of this issue The Wsuscontent directory was missing an NTFS permission. I added the “Network Service” account full control on the directory and sub-directory and launch a … Read More

SCCM Task Sequence Page File Location change using PowerShell

Benoit LecoursPowershell, SCCM7 Comments

SmsSwDistCacheDirDelete in ccmsetup.log 03

You can script the placement of the Windows page file in your SCCM Task Sequence. Sure you could use the good old wmic pagefileset but we’re in 2014, Powershell is your new friend! SCCM Task Sequence Page File Location Script My clients needed a script that : Disable page file on OS drive Move it to D: Set the page file based on the allocated memory installed (x1.5) I used a Powershell module found here. My Script then uses a function of this modules to fits my needs. Save this script in a .ps1 file. #Reads the physical memory and multiplies … Read More

SCCM Change Drive Letter using Powershell in OSD Task Sequence

Benoit LecoursPowershell, SCCM5 Comments

SmsSwDistCacheDirDelete in ccmsetup.log 03

By default, Windows will assign the next available letter to your CD/DVD ROM drive. For servers and even workstation, it could be useful to change it to a standard value. This post will describe how SCCM Change Drive Letter in an OSD task sequence. In computer data storage, drive letter assignment is the process of assigning alphabetical identifiers to volumes. As an SCCM admin, you should always find ways to optimize your work and stop doing repetitive tasks. Add a Run Command Line step at the end of your task sequence that runs a PowerShell command. The latest SCCM 1902 Version can now directly … Read More

SCCM 2012 Resultant Client Settings

Nicolas PilonSCCMLeave a Comment

There’s a new feature that come with the release is SCCM 2012 Resultant Client Settings. If you are familiar with GPO, it does exactly the same thing as GPResult except for the client settings configuration. Very useful when it’s time to troubleshoot client settings or you want to double check one of your change before releasing in production. It is really simple to use, in your console, right click on a device, user or user group in the Asset and Compliance section. Click on Client Settings and Resultant Client Settings. As a side dish, this tool need a minimum requirement in RBAC to use … Read More

SCCM 2012 Management Point Error 1603

Benoit LecoursPowershell, SCCM2 Comments

We have recently experienced a SCCM 2012 management point error 1603. Scenario : Installing a new MP gives an error 1603 SCCM 2012 R2 Windows 2012 R2 The first thing to check is the MPSetup.log, you can see the error 1603 but you have not much information about what’s the problem really is. You have to dig deeper in the MPMsiLog.LastError to see the root cause.                     As you can see the error is cause by a previous version of the client being installed on the server. My environment had SCCM … Read More

Add SCCM Distribution Point Powershell

Benoit LecoursPowershell, SCCMLeave a Comment

Working in a large environment with lots of DPs, I don’t like to add my distribution point manually. Since SCCM 2012 SP1 CU1, there’s a new Add-CMDistributionPoint CMDLET to do the dirty work. This blog post will describe how to add SCCM Distribution Point Powershell. Choose a site system server as a distribution point before content can be made available to client computers. Assign a distribution point to at least one boundary group before on-premises client computers can use that distribution point as a content source location. Add the distribution point role to a new site system server, or add it to an … Read More

Remove Computer from Collection after OSD

Benoit LecoursPowershell, SCCM1 Comment

This post is a step-by-step guide on how to remove computer from collection after OSD. If you’re using specific collections for your OSD deployments you certainly knows that the collections are not emptied automatically. After a couple of weeks, you’ll end up with a collection full of systems. The bad news is that there’s nothing built-in the product, the good new is that our friend PowerShell can do this dirty job. To run the script : The imported module needs to be trusted The script must run in x86 mode The computer account must have proper permission (SCCM and DCOM) … Read More

SCCM Slow Distribution Point

Benoit LecoursSCCM7 Comments

I had an interesting case where OSD deployment and application download were really slow using SCCM 2012 R2. My first thought was to apply KB2905002 which resolves SCCM Slow Distribution Point. Distribution Point Definition : Choose a site system server as a distribution point before content can be made available to client computers. Assign a distribution point to at least one boundary group before on-premises client computers can use that distribution point as a content source location. Add the distribution point role to a new site system server, or add it to an existing site system server. This KB was already applied … Read More

SCCM Internet Based Client Management

Benoit LecoursSCCM52 Comments

The goal of this post is to describe the steps needed to implement SCCM Internet-based client management. With the increasing client working from home, this solution would allow you to manage your client on the internet. The other option would be to install a cloud management gateway (CMG) Download the step-by-step guide in the download section or directly here. For now on, this blog post won’t be updated. Only the document will be. In this scenario, SCCM 2012 R2 is installed as a stand-alone primary site. For security reasons, a second site server will be installed in the DMZ to respond … Read More