Guide - TechyGeeksHome

SCCM WQL Query – All Windows 10 Installs

17 February 202615 September 2016 by Andrew Armstrong

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this 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.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections … Read more

SCCM SQL Query – Count Computers by Model

17 February 202614 September 2016 by Andrew Armstrong

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. … Read more

SCCM WQL Query – No ConfigMgr Client Installed

17 February 202612 September 2016 by Andrew Armstrong

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 … Read more

SCCM WQL Query – Clients without latest version installed

17 February 20267 September 2016 by Andrew Armstrong

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 … Read more

SCCM WQL Query – All Inactive Clients

17 February 20266 September 2016 by Andrew Armstrong

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.

W3 Total Cache Error: Page Cache Rewriting is URL Not Working

1 May 20262 September 2016 by Andrew Armstrong

If you are using WordPress for your blog and trying to set W3 Total Cache, you may find that on your Administration page, you are getting this error: “W3 Total Cache Error: Page Cache Rewriting is URL Not Working. Please verify that the server configuration allows .htaccess” There can be a few reasons for this … Read more

SCSM – How to delete all incidents

1 May 202630 August 2016 by Andrew Armstrong

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

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

1 May 202625 August 2016 by Andrew Armstrong

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

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

1 May 202624 August 2016 by Andrew Armstrong

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

WSUS Installation Errors on Microsoft Server 2012

1 May 202622 August 2016 by Andrew Armstrong

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, … Read more

SCUP – Failed to connect to the update server error

1 May 202617 August 2016 by Andrew Armstrong

We were recently setting up a new WSUS server in our lab and also setting up System Center Updates Publisher (SCUP) and kept getting an error when trying to connect SCUP to WSUS which were installed on the same server. The error we were getting was: “Failed to connect to the update server. Check your … Read more