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
SCCM 2012 R2 CU1 Released
The wait is over. Microsoft has just release SCCM 2012 R2 CU1 which fix lots of stuff. Follow the link to see all issues that are fixed : http://support.microsoft.com/kb/2938441/en-us One bug that I’ve talked about last year is finally fixed. The Uninstall option may not be available in Software Center for applications that are made available through multiple deployment types. For example, if two deployment types for an application apply to a client, and if both have an Uninstall action, the Uninstall button is unavailable. Happy updating.
The Microsoft Software License Terms have not been Completely Downloaded
Problem SMS_WSUS_SYNC_MANAGER state is critical even if it worked in the previous months. Environment SCCM 2012 R2 SQL 2012 Windows 2012 R2 Wsyncmgr.log shows error on 2 updates : The Microsoft Software License Terms have not been completely downloaded and cannot be accepted Event viewer/Application Logs shows Access Denied errors on a different patch. Resolution 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 new sync. Everything sync successfully. All the details come from Technet.
PowerShell to change Page File Location in your SCCM TS
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 ! 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 it by 1.5 $PageFileSizeMB = [Math]::Truncate(((Get-WmiObject Win32_ComputerSystem).TotalPhysicalMemory) … Read More
Change CDROM Drive Letter using Powershell during OSD
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. Add a Run command Line step in the end of your task sequence that run a powershell command. %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -command “(gwmi Win32_cdromdrive).drive | %{$a = mountvol $_ /l;mountvol $_ /d;$a = $a.Trim();mountvol z: $a}” You change the last Z: to another letter to fit your environment.
SCCM 2012 Resultant Client Settings
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
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 Distribution Point using Powershell
Working in 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. First you need to add your site system in SCCM using this CMDLET (replace with your server name and site code) New-CMSiteSystemServer -Servername “xxxx.yourdomain.com” -Sitecode PS1 Once run, you’ll see your new site system added to the SCCM console. After, you need to add the DP role using : (replace with your server name and site code) Add-CMDistributionPoint –SiteSystemServerName “yourmachine.yourdomain.com” –SiteCode PS1 –MinimumFreeSpaceMB 5000 –CertificateExpirationTimeUtc “Saturday, March 28, 2015 5:55:05 PM” … Read More
Remove Computer from Collection after OSD
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
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 resolve slow OSD deployments. This KB was already applied and still, the download of the .WIM during a task sequence was taking 30 minutes just to download. Application installations in software center that was using the same DP was also experiencing slow installs. Reviewing the SMSTS.log during the OS Deployment had no errors. Looking at the Resource monitor, I saw that the network throughput was around 6 Mbps on a Gb connection… Something was … Read More