Making IT Happen
We have recently come across the live stream from a camera aboard the International Space Station and thought it was absolutely brilliant so thought we would share it with our visitors.
Live Video Stream from International Space Station (ISS) Read MoreMicrosoft 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 These iOS 10 devices may …
SCCM – Apple iOS 10 Update for Configuration Manager 1606 Read MoreIf 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 for other operating systems as …
SCCM WQL Query – All Windows 10 Installs Read MoreIf 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. Feedback If you have any …
SCCM SQL Query – Count Computers by Model Read MoreIf 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 if you would like us …
SCCM WQL Query – No ConfigMgr Client Installed Read MoreWe 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 length of your passwords also …
PassGenCrypter – Password Generator Free Utility Released Read MoreBelow 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 SQL Server 2008 R2 Kilimanjaro …
SQL Server Version Numbers Read MoreIf 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 currently using.
SCCM WQL Query – Clients without latest version installed Read MoreIf 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.
SCCM WQL Query – All Inactive Clients Read MoreWith the latest offering of Call of Duty coming out for release soon, we thought we would post some of the game trailers so that we can all get excited about Infinite Warfare coming out!
Call of Duty – Infinite Warfare Trailers Read MoreJust 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 now notice a much better …
Website News Update Read MoreWe 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 simply unsubscribe. Subscribe to our …
Newsletter Read More
