We recently built a new Configuration Manager system for a client who wanted user collections for all departments and companies within their corporate group. We were going to set these up manually which is a fairly simple, but time consuming, job to do. But this was a time restricted installation so we had a quick […]
Month: January 2018
SCCM – Create a device collection based on Exchange Server role
![SCCM - Create a device collection based on Exchange Server role 2 sccm logo](https://techygeekshome.info/wp-content/uploads/2016/02/sccm.jpg)
Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new device collection and then use this query: select * from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name like “Microsoft Exchange%” Save the […]
- Guide
- ...
Technical Support Videos
![Technical Support Videos 3 TechyGeeksHome desktop wallpaper](https://techygeekshome.info/wp-content/uploads/2016/03/tgh-desktop-wallpaper-moon-2.png)
Take a look through our range of technical support videos. Many more also available on our YouTube channel. Windows Updates Stuck on Shut Down or Reboot VMWare ESX Serial Number Activation How to Fix Bluetooth Issues in Windows 8.1 Create a capture boot image in Windows Deployment Services WDS How to elevate a program – […]
Rescue Lost Data with Free Data Recovery Software
![Rescue Lost Data with Free Data Recovery Software 4 Logo EaseUS](https://techygeekshome.info/wp-content/uploads/2017/05/Logo-EaseUS.png)
Missing files is a huge hassle regardless if they are connected to your personal life or your professional one. As losing an important piece of a document could cost you a great deal in both cases. To help you out we are offering you a free data recovery software by that will help you recover […]
Enable Windows Remote Desktop Protocol and Set Firewall Rules using PowerShell
![Enable Windows Remote Desktop Protocol and Set Firewall Rules using PowerShell 5 powershell](https://techygeekshome.info/wp-content/uploads/2017/08/powershell.png)
If you are using Windows Server 2012 or newer, or if you are just using Windows Server Core, then this Powershell script will help you out by enabling Remote Desktop and setting the correct firewall inbound rules. Simply open up an elevated Powershell command box, or use Powershell ISE and use the two scripts below, […]
SCCM – Create a device collection based on Domain Controller role
![SCCM - Create a device collection based on Domain Controller role 6 microsoft black logo](https://techygeekshome.info/wp-content/uploads/2017/05/microsoft.png)
We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go ahead and create a new device collection and then use this query: Save the query and you should now see a collection of all your […]
Java 8 Update 161 MSI Installers and Offline Installers for x86 and x64 Browsers Released
![Java 8 Update 161 MSI Installers and Offline Installers for x86 and x64 Browsers Released 7 Java MSI](https://techygeekshome.info/wp-content/uploads/2018/11/WordPress-Java-MSIs-1.jpg)
We have now uploaded to our Filestore microsite the MSI installers and Offline Installers for the latest Java version release. The versions that have been added are: Java 8 Update 161 x86 MSI Installer Java 8 Update 161 x64 MSI Installer Java 8 Update 161 x86 Offline Installer Java 8 Update 161 x64 Offline Installer […]
SCCM – Hardware and Client Version SQL Query
![SCCM - Hardware and Client Version SQL Query 8 sql2016](https://techygeekshome.info/wp-content/uploads/2016/10/sql2016.jpg)
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU, […]
- General Tech
- ...
5 Home Gadgets That Will Actually Make Your Life Better
![5 Home Gadgets That Will Actually Make Your Life Better 9 Technology](https://techygeekshome.info/wp-content/uploads/2018/01/glasses-2172280_640.jpg)
Technology continues to creep into every aspect of life as it advances, and your home is no exception. New gadgets are introduced continuously that make life just a little bit easier. Consider adding these five devices to your home to take advantage of advancements in technology and simplify your life. Smart thermostat A smart thermostat […]
Adobe Flash Player MSI Installers v28.0.0.137
![Adobe Flash Player MSI Installers v28.0.0.137 10 Adobe Flash Player MSI Package](https://techygeekshome.info/wp-content/uploads/2017/08/Adobe-Flash-Player-1.jpg)
Adobe have released another update to their Adobe Flash Player software, this time taking it up to version 28.0.0.137. As always, you can download the executable file but if you want the MSI files so that you can load it into your Configuration Manager Software Catalog, you can get that here. The update is also […]
SCCM SQL Query for Software not in Add Remove Programs
![SCCM SQL Query for Software not in Add Remove Programs 11 sccm logo 600x400](https://techygeekshome.info/wp-content/uploads/2017/11/sccm-600x400.jpg)
If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: Then you can use the variable @displayname to choose from a drop down of software that is in the SCCM database pulled from client machines. […]
Video Demo – Windows Updates Stuck on Shut Down or Reboot Fix
![Video Demo - Windows Updates Stuck on Shut Down or Reboot Fix 12 Promotional graphic for a Windows Updates Stuck on Shut Down or Reboot Fix, featuring a computer screen with a rocket graphic and relevant symbols.](https://techygeekshome.info/wp-content/uploads/2018/01/Windows-Update-Stuck-on-Shutdown-or-Reboot.jpg)
We also have written guides for the different versions of Windows available here: Windows 10 Windows 7 Windows 7 Alternative Method Feedback We would love to hear your feedback on whether any of these methods helped you at all. If they have, please feel free to go ahead and leave us a message below using […]