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 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 … 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
Some 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 … Read more
If you have recently upgraded to Windows 10 Fall Creators Update and you use Remote Server Administration Tools (RSAT), then you may have noticed that the DNS console is missing from the list of available consoles. This seems to be a fault on Microsoft‘s side and I’m sure that they will release an update soon, … Read more
The DNS Console for Windows 10 allows you to manage your Windows Server DNS service directly from a Windows 10 or Windows 11 workstation. A standalone console tool for IT administrators managing DNS without server access. Requirements Windows 10 or Windows 11 Network access to a Windows Server DNS server Administrator rights How to Download … Read more
After our recent post about providing our visitors with a number of evaluation and KMS Microsoft product keys, please see below the latest set in this series. These are the full range of Microsoft Evaluation keys for all editions of Windows 10. Windows 10 Edition Product Key Windows 10 Professional W269N-WFGWX-YVC9B-4J6C9-T83GX Windows 10 Professional N … Read more
If you are getting Group Policies that are not applying to a users machine, you may well come across this error: The processing of Group Policy failed. Windows could not apply the registry-based policy settings for the Group Policy object LocalGPO. Group Policy settings will not be resolved until this event is resolved. This can … Read more
This 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 … Read more