If you want your end user experience to show them the progress of an installation from your Software Center, then you will need to ensure that you have your command lines and user experience tab setup correctly. We have seen many people follow the “install in the background and don’t tell anyone the progress” method … Read more
If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. WQL Script To set this up, create a new collection and copy and paste this as its query: Variables You can add or remove any … Read more
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
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
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
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
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
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
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. … Read more
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 … Read more
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 … Read more
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 … Read more