Making IT Happen
If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and […]
If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System […]
We are pleased to announce the release of our RemoveIE software in an MSI format. This will allow you to distribute the application to a large number of computers using tools such as Group Policy or SCCM. The MSI program is a free download and this does allow you to distribute the software within your […]
If you are trying to run a Powershell script, you may find sometimes that you get this following error message: Cannot be loaded because the execution of scripts is disabled on this system. There is a very simple fix for this, all you have to do is ensure that you run your Powershell program as […]
The below SQL query can be used against your SCCM database to return information about your servers. You can edit this query to bring back different information and also use it to create a report using SSRS. This query by default brings back the following information: Query More Queries Our full range of SQL and […]
Most users in organisations believe that Google Earth is a great tool for their work and freely install it on their work machines and think nothing of it. Well, Google Earth is NOT free for commercial use and if business users want to use Google Earth for work purposes on work machines, then a licence […]
If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. This WQL query can then be used as part of an import function to create a device collection within SCCM. More Queries Our full range of SQL and WQL […]
You can use Problem Steps Recorder to automatically capture the steps you take on a computer, including a text description of where you clicked and a picture of the screen during each click. Once you capture these steps, you can save them to a file that can be used by a support professional or someone […]
We have had reports of people purchasing Need for Speed: Rivals for their Xbox One and installing the game, starting the tutorial at the beginning and then finding that the car does not move!! A quick fix for this is to completely power off your Xbox One console and start up the game again – […]
Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just a tutorial for how to gather your OWN PAID FOR serial numbers using SCCM, it seems this is not good enough for NitroPDF or Google. So, we have had to […]
We are pleased to announce the release of our updated utility – RemoveIE v3.4 This utility follows on the success of our previous release – RemoveIE10 v2.1 which can still be downloaded from our site. In this release, we have added the option to remove Internet Explorer 11 from your Windows 7 machines. This is […]
I have been asked to provide a solution to a situation where during SCCM OSD, they want to run Windows Updates across multiple sites worldwide using the local WSUS replica servers. So as an example, the main Headquarters office is in New York with the main WSUS server and then in Rome there is another […]