SCCM – Apple iOS 10 Update for Configuration Manager 1606

apple logo

Microsoft have now released an update for Configuration Manager version 1606 to add Apple iOS 10 to the supported platforms list. This update adds the following platforms to the supported platforms list for Microsoft System Center Configuration Manager current branch, version 1606: All iOS 10 iPhone or iPod Touch devices All iOS 10 iPad devices … Read more

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 SQL Query – Count Computers by Model

sql

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

Google Chrome version 53.0.2785.101 Released and MSI Installer

google

Google have now released a new version of their Chrome browser, version 53.0.2785.101. If you are looking at deploying Google Chrome using systems like Configuration Manager, WDS, SCUP or Group Policy, you will want to use their MSI installer to make it much easier. You can now download the Google Chrome MSI installer direct from … 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 … Read more

Adobe Reader 11.0.17 Released

adobe reader free downlaod

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

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

Website News Update

TGHDesktop2048youtube

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