Making IT Happen
If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use this SQL query below using SSRS to create a custom report: More Queries Our full range of SQL and WQL Collection queries are available here. […]
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or […]
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 […]
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.
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 […]
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 […]
We have recently been installing WSUS on a rebuilt Microsoft Server 2012 and found that although the role would install without any issue, when we tried to run the configuration wizard we were getting an error and in the log file it stated: “Config file did not contain a value “ContentDirectory”” So, first of all, […]
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 […]
If you are looking at upgrading your user machines up to Windows 10 1607 then you can do this quickly and easily using an inplace task sequence with Configuration Manager. All you need to do is create an operating system upgrade source for Windows 10 1607 and then create the upgrade task sequence and deploy […]
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 […]
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 […]
You should have noticed by now that the default internet browser Microsoft want you to use is their new Edge browser. Well, ok, its fine for home browsing but a lot of companies have legacy programs that still need Internet Explorer 11 to run them. So, how do you get your SCCM Operating System Deployment […]