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

Adobe Reader 11.0.17 Released

Adobe have now released an update to their Acrobat Reader software to take it up to version 11.0.17. You can now download the MSI, EXE and MSP files for this release from their FTP site which you can get to using the download button below: DOWNLOAD Download Adobe Reader XI v11.0.17 COMMENTS If you have

Read More

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 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

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

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