Making IT Happen
This registry fix download will make sure that your MDT or SCCM task sequences will update correctly when using a local WSUS server. Download To download, simply scroll down towards the bottom of this page and you will see the options for this download. Ensure you select the correct one and click the blue Download button as detailed below:
WSUS Regedit Fix Read MoreWe 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 using Generation 2 technology. To …
How to create correct partitions to deploy a Windows image to a UEFI based device 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 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 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 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 …
SCCM SQL Query for all server CPU information Read MoreIf 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, …
Uninstalling System Center Endpoint Protection Read MoreSome time ago there was a bug within SCCM where when you deployed an application, you had to change the deployment date back a day to make it work. This seemed to have been fixed when moving over to current branch but this issue has raised it’s head again. This will cause clients trying to install the deployment to get …
SCCM Deployment Time Bug Read MoreThis guide assumes that you use Microsoft Deployment Toolkit (MDT build 8443) or Microsoft System Center Configuration Manager (SCCM) capturing Windows. You capture a task sequence, and the capture computer does not have Internet access. When the task sequence is running and the computer is checking for updates (pre-application installation), the installation freezes for 2 hours while searching for updates. After …
Updates fail or time out when WSUS is used during an MDT or SCCM capture Read MoreIf you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. The best way to start creating a custom report is to ensure that you get your SQL query correct first. We have written hundreds of various queries over the years …
SCCM – SQL Query for all Laptops Read More
