How to create a MDT Package within SCCM

microsoft black logo

As a SCCM administrator you are probably fully aware that you have a lot of power available to you when carrying out deployments using task sequences. But you can add even more options to SCCM task sequences by adding Microsoft Deployment Toolkit (MDT) integration. This gives you a load more options during a task sequence … Read more

SCCM – Full list of web security proxy exceptions

System Center Configuration Manager SCCM

When using Configuration Manager, you may find that some things may not work fully if you are also behind a web security proxy service. We came across this problem recently where the Asset Intelligence Point was being blocked from contacting the internet due to web security. This caused this error in our Configuration Manager Console: … Read more

Asset Intelligence GLS Spreadsheet

Microsoft Blue Logo

The Asset Intelligence GLS Spreadsheet is a pre-built Excel spreadsheet for use with SCCM Asset Intelligence. Import this GLS file to enhance hardware and software inventory reporting in Configuration Manager. Requirements Microsoft Excel SCCM / Microsoft Endpoint Configuration Manager How to Download Watch our video guide on how to download from TechyGeeksHome: Support & Feedback … Read more

WSUS Regedit Fix

Microsoft Blue Logo

The WSUS Regedit Fix resolves update failures that occur during MDT or SCCM task sequences when using WSUS. This registry fix corrects the WSUS client settings that cause updates to fail or time out during OS deployment. Requirements Windows 10, Windows 11 or Windows Server SCCM or MDT for OS deployment Administrator rights For full … Read more

How to create correct partitions to deploy a Windows image to a UEFI based device

microsoft black logo

We have recently come across an issue when trying to deploy a test virtual machine using Hyper-V (Generation 2 – UEFI) that once you have selected your task sequence, you get an error and the task sequence bombs out. This is because we had not setup the correct drive partitions to be able to deploy … Read more

SCCM – Create a device collection based on Exchange Server role

sccm logo

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 … Read more

SCCM – Create a device collection based on Domain Controller role

microsoft black logo

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 … Read more

SCCM – Hardware and Client Version SQL Query

sql2016

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, … Read more