All articles about Microsoft System Center range of products.
We came across a problem with our SCCM OSD recently where it was getting through approximately half the build process and then seemingly getting stuck on “Just a moment…” before timing out and not completing the build. This was a bit of a head scratcher as there did not seem to be any crash or…
We recently had a problem with our Service Manager database server using massively high RAM usage. It was using up all the RAM we gave it no matter how much extra we allocated to it. So we needed to try and figure out why it was doing this, like all good IT people, we started…
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…
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:…
We have now updated our SCCM Autodesk serial number MOF collection script to include the recently released AutoCAD 2019 and AutoCAD LT 2019. The following additions have been made to the script: AutoCAD 2019 – English AutoCAD LT 2019 – English The full instructions on how to use this script can be found below: Instructions…
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…
So Microsoft have today released version 1802 of Current Branch for Configuration Manager. This is great and there are some features in this upgrade that we are looking forward to trying out. But, on the slow ring, it could be a few days or weeks until it drops into your Configuration Manager Console. That’s bad….
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…
Adobe have released another update to their Adobe Flash Player software, this time taking it up to version 28.0.0.161. As always, you can download the executable file but if you want the MSI files so that you can load it into your Configuration Manager Software Catalog, then you can download them from our site right…
We recently built a new Configuration Manager system for a client who wanted user collections for all departments and companies within their corporate group. We were going to set these up manually which is a fairly simple, but time consuming, job to do. But this was a time restricted installation so we had a quick…
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…
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…
We have now uploaded to our Filestore microsite the MSI installers and Offline Installers for the latest Java version release. The versions that have been added are: Java 8 Update 161 x86 MSI Installer Java 8 Update 161 x64 MSI Installer Java 8 Update 161 x86 Offline Installer Java 8 Update 161 x64 Offline Installer…
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,…
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….
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…
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…
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…
