Making IT Happen
We recently had a requirement to restart a single service on multiple devices across a single network. At first, it was going to be the job of the helpdesk to logon to each device and manually restart this service. However, as usual, there is always a way of using Powershell to speed up such tasks. Powershell Script This simple Powershell …
Restart a service on multiple devices using Powershell Read MoreWe are delighted to announce that we are now a part of SlideShare and you can start to download our free PDF ebooks immediately from our SlideShare profile. We will be adding many, many more to our profile over the next few months, so please feel free to pop along from time to time to download and share our completely …
TechyGeeksHome Free eBooks now on SlideShare Read MoreFollowing 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 query and you should now …
SCCM – Create a device collection based on Exchange Server role Read MoreTake 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 – Run as admin Add drivers …
Technical Support Videos Read MoreIf 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, one to enable Remote Desktop …
Enable Windows Remote Desktop Protocol and Set Firewall Rules using PowerShell Read MoreWe 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 domain controllers. Just be careful …
SCCM – Create a device collection based on Domain Controller role Read MoreIf 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 …
SCCM – Hardware and Client Version SQL Query Read MoreIf 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 …
SCCM SQL Query for Software not in Add Remove Programs Read MoreWe 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.
Video Demo – Windows Updates Stuck on Shut Down or Reboot Fix Read MoreThere 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 …
Sat Nav and Dashcam Suction Cup Issues Fixed Read MoreWe 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 …
SCCM – Differences between Add Remove Programs Database Tables Read MoreIf 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 …
Power BI – Refresh data every working hour Read More
