Practical IT Guides for Windows, SCCM & PowerShell Admins

TechyGeeksHome has been helping IT professionals and sysadmins since 2010. Find 1,500+ real-world guides covering Windows 10 & 11, Windows Server, SCCM/ConfigMgr, PowerShell scripting, Active Directory, networking, and virtualisation — all written from hands-on production experience by a UK IT pro with 26 years in the field.

SCCM WQL Query – All Windows 10 Installs

ssc 0

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 WQL Query – No ConfigMgr Client Installed

ssc 0

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

PassGenCrypter – Password Generator Free Utility Released

PGCSH1

We are very pleased to announce the release of our new free utility, PassGenCrypter. With the ever-increasing requirement for stronger passwords, you can use this very simple utility to generate complex passwords with ease. You can select how many passwords you want to generate allowing up to 100 different passwords. You can also select the … Read more

SQL Server Version Numbers

sql

Below is a full list of SQL Server version numbers dating from version 7.0 through to the current 2016 RTM release. Codename RTM Service Pack 1 Service Pack 2 Service Pack 3 Service Pack 4 SQL Server 2016 NA 13.0.1601.5 SQL Server 2014 SQL14 12.0.2000.8 12.0.4100.1 12.0.5000.0 SQL Server 2012 Denali 11.0.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0 … Read more

SCCM WQL Query – Clients without latest version installed

sccm logo

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