ssc 0

SCCM WQL Query – All Windows 10 Installs

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
sql

SQL Server Version Numbers

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 logo

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…

Read More
TGHDesktop2048youtube

Website News Update

Just a quick update on the latest changes to our website…. We have recently setup our new responsive theme which will allow easily viewing access for smart phones and tablets. We have also moved to a much higher specification web host along with adding a CDN and caching service to our website so you should…

Read More
newsletter

Newsletter

We have now launched our newsletter service which you can sign up for completely free and get updates about our site and any important announcements or releases. To sign up, all you have to do is to enter a valid email address below and that’s it! If you get bored at any time, you can…

Read More
filezilla

Filezilla Client 3.21.0 Released

FileZilla Client 3.21.0 has been released and you can now download the latest version from the download button below. DOWNLOAD Download FileZilla Client NEW FEATURES Fixed vulnerabilities Fixed a string format vulnerability introduced in 3.20.0-rc1 when listing directories using SFTP New features: SFTP: Added support for AES-GCM ciphers as implemented in OpenSSH OS X: Ctrl+Tab…

Read More
TGHDesktop2048youtube

900th Post

This is our 900th blog post. When we first started this blog about four years ago, it was simply a place for us to pretty much store guides for ourselves to refer back to. Over the years it has grown and grown and we are on average now seeing around 6000 visitors a day as well…

Read More