TechyGeeksHome

SCCM – Hardware and Client Version SQL Query

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, SUM(PM.Capacity0) as Memory, SUM(LD.Size0)as [Disc …

News / General Tech

5 Home Gadgets That Will Actually Make Your Life Better

by T.R Powell - Leave a Comment

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 gives you total control of …

Guide / System Center

SCCM SQL Query for Software not in Add Remove Programs

by Andrew Armstrong - Leave a Comment

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. The query you can use …

Promotional graphic for a Windows Updates Stuck on Shut Down or Reboot Fix, featuring a computer screen with a rocket graphic and relevant symbols.

Video Guides / Guide / Microsoft / YouTube

Video Demo – Windows Updates Stuck on Shut Down or Reboot Fix

by Andrew Armstrong - Leave a Comment

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 our comments section.

Guide / Gadgets

Sat Nav and Dashcam Suction Cup Issues Fixed

by Andrew Armstrong - Leave a Comment

There is an ever-growing number of dashcams now being purchased due to the very low cost of them along with the YouTubers out there that want to stick you making the tiniest of driving errors, on the internet for all to see! This has been the case for sat navs over the last 10 years with them becoming almost an …

Guide / System Center

SCCM – Differences between Add Remove Programs Database Tables

by Andrew Armstrong - Leave a Comment

We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you for Add Remove Programs, knowing …

Microsoft / Guide

Power BI – Refresh data every working hour

by Andrew Armstrong - Leave a Comment

If you are using Power BI and a personal gateway, you may want to ensure that your report data is updated regularly during working hours. Power BI is an excellent tool that can be utilised in many ways including the power bi jira combination as an effective solution for specialists dealing with numerous administrative tasks. To learn more about Power BI and …

System Center / Guide

SCCM SQL Query for all server CPU information

by Andrew Armstrong - Leave a Comment

If you are looking for an SQL query to use against your System Center Configuration Manager database to give you the ability to report on server CPU information, this is the query for you! You can use the below to get various information on the CPU or you can use SELECT * to bring back all information and make your …

News

Filestore Microsite Announcement

by Andrew Armstrong - Leave a Comment

We are delighted to announce our new filestore microsite which we have now launched and is available at https://filestore.techygeekshome.info All our new downloads will now be uploaded to this microsite and we have so far uploaded our most popular downloads already and will continue to migrate all of our existing downloads over the next few coming weeks. You will find …

News

Disable Windows Defender GPO

by Andrew Armstrong - Leave a Comment

If you are going to install a different anti-malware program onto your corporate computers, you may want to disable the built in Windows Defender from Windows 10 machines. Although you cannot uninstall Windows Defender as such, you can disable it which is as good as carrying out an uninstall. To do this, you should create a new Group Policy Object …

Guide / System Center

Uninstalling System Center Endpoint Protection

by Andrew Armstrong - Leave a Comment

If you have been using System Center Endpoint Protection and you now want to move away from it, you will need to carry out an uninstall of the software. This can be very easily carried out either through a manual process of uninstalling using the Programs and Features within the Windows Control Panel or if you have the original installer, …

News

5 Tech-Savvy Features to Consider for Your Home

by T.R Powell - Leave a Comment

Technology is in nearly every aspect of life, and your home is no exception. New gadgets are revolutionizing how people accomplish everyday tasks. Here are five common smart technologies to integrate into your home to make life just a little bit easier. Smart Lighting Changing your home over to smart lighting can make your life much simpler. An intelligent home …