Explore Microsoft System Center Products

SCCM WQL Query – Clients without latest version installed

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are currently using.

Guide / System Center

SCCM WQL Query – All Inactive Clients

by Andrew Armstrong - Leave a Comment

If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.

Guide / System Center

SCSM – How to delete all incidents

by Andrew Armstrong - Leave a Comment

If you are using System Center Service Manager (SCSM) you may want to delete all your incidents. This may sound strange but if you are setting up and testing and then want to remove all those test incidents – this can sometimes be the case. So, all you need to do is to start up your SCSM PowerShell and run …

Guide / System Center

SCCM – How to Create a DCM Item to Detect If the Firewall Is Off

by Andrew Armstrong - Leave a Comment

We recently came across a great guide on how to setup a DCM item to detect if any users machines had the Windows Firewall turned off and how to report on it. So, we thought we would share this guide with our visitors, so head on over to MyITForum to check out how to carry this out. SCCM – DCM …

Guide / System Center

SCCM Task Sequence Error – Can’t find script engine VBScript

by Andrew Armstrong - Leave a Comment

We have recently started to have problems with running a CScript command in one of our SCCM task sequences where we send the local computer description to Active Directory to automatically set the Active Directory computer name description. It has always worked fine but seemed to have stopped working after the latest hotfix. So, after many hours of Googling, we …

Guide / System Center

Microsoft SQL Server 2012 Express

by Andrew Armstrong - Leave a Comment

This is more of a reminder for ourselves, but if you are looking to download Microsoft SQL Server 2012 express, for which you can use to install the SQL Console Management Tools as well, then the download link is below: Microsoft SQL Server 2012 Express Download

Guide / System Center

SCCM – Time Zone Codes

by Andrew Armstrong - Leave a Comment

We have been carrying out some work on various HTA’s for SCCM OSD processes lately and that has included automatically setting time zones. We struggled to find a comprehensive list of the time zone settings so thought that we would share that information here. If you find anything that we may have missed, please let us know and we will …

Guide / System Center

SCCM OSD Fails with Error 80220005 at the “Apply Windows Settings” step

by Andrew Armstrong - Leave a Comment

If you are trying to deploy an operating system using SCCM and you are getting an error 80220005 at the “Apply Windows Settings” step, then there can be two reasons for this. One is that the computer name that you are trying to give to the machine is over 16 characters long and will cause a failure. The second is …

Guide / System Center

SCCM Distribution Point Pre-Requisite Powershell Script

by Andrew Armstrong - Leave a Comment

If you are setting up some distribution points for Configuration Manager (SCCM) then you will need to ensure that you have all the correct server features installed and also the correct firewall ports opened. To do this, we have created a quick PowerShell script to carry this all out for us. To download this script for yourselves, please click the …

Guide / System Center

Microsoft Office 2013 – Skype and OneDrive for Business not installing when using OCT

by Andrew Armstrong - Leave a Comment

If you are deploying Microsoft Office 2013 then you will have used the Microsoft Office Customization Tool (OCT) to tell your installer what parts of Office to actually install. So what if you have setup your installer to carry out the standard Word and Excel installs but you also want Skype for Business (or Lync as its known in Office …

Guide / System Center

How to Capture Microsoft Office Updates

by Andrew Armstrong - Leave a Comment

This is a guide on how to capture Microsoft Office updates from a machine and then use these captured updates to either streamline a fully updated installation of Microsoft Office, or it can be used with Configuration Manager to ensure that you are pushing out the software fully patched. The reason we started using this method was to ensure that …

Guide / System Center

SCCM – 52 Operational Collections

by Andrew Armstrong - Leave a Comment

There is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a look: 52 SCCM Powershell Collections Full list of collections created using the Powershell script are: All Clients All Clients Active All Client Inactive All Clients R2 CU0 All Clients R2 CU1 All Clients R2 CU2 …