Making IT Happen
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 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 MoreIf you are using WordPress for your blog and trying to set W3 Total Cache, you may find that on your Administration page, you are getting this error: “W3 Total Cache Error: Page Cache Rewriting is URL Not Working. Please verify that the server configuration allows .htaccess” There can be a few reasons for this but you can try this …
W3 Total Cache Error: Page Cache Rewriting is URL Not Working Read MoreSo it’s the start of a new month shortly and Xbox Live Gold members can again download some free games! This month is split into the first half of the month and the second half, so from 1st September until 15th September you can get Forza Horizon and then from 16th September until 30th September you can get Mirror’s Edge. …
Xbox Live Gold Free Games for September Read MoreIf you are using System Center Service Manager (SCSM) you may want to delete all your incidents. This may sound strange but if you are setting up and testing and then want to remove all those test incidents – this can sometimes be the case. So, all you need to do is to start up your SCSM PowerShell and run …
SCSM – How to delete all incidents Read MoreApple have released iOS 9.3.5 for iPhone, iPod and iPad. Details about the latest update can be found by clicking the button below: Apple iOS 9.3.5 Update
Apple iOS 9.3.5 Released Read More
