SCCM WQL Query – All Inactive Clients
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.
In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
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.
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
If you are using SCCM for your operating system deployments across different countries, then you may want to set the time zone within the task sequence. To do this, you can take advantage of the built in Windows tool call tzutil.exe. In this example we will set the time zone for a computer deployment based … Read more
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
If you are looking at setting up your System Center Configuration Manager (SCCM) with PKI, then there is an excellent step by step guide that you can follow from SCCMGuy. The link to this guide is below: https://sccmguy.com/2013/11/26/pki-certificates-for-configuration-manager-2012-r2-part-1-of-4-web-server-certificate/ We have used this in the past our various labs and it details well what you need to … Read more