All articles about Microsoft System Center range of products.
If you’re responsible for managing Office 365 deployments within your organization, having visibility into which channels your devices are using is crucial for effective administration and maintenance. With the help of SQL queries, you can extract pertinent information from Configuration Manager data, allowing you to generate insightful reports or visualize data using tools like Power…
These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your business. Instructions To get this information, open a new query within SQL Server Management Studio and copy and paste the query that you wish to…
I’ve been creating a lot of collections with our SCCM recently, so I thought I would share the ones we thought were most useful: Show all computers in SCCM: Show all computers with a specific name: Show all computers with a specific operating system: Show all computers with a specific IP address: Show all installed…
How to write custom SCCM reports using SSRS. This guide will show you exactly how to create your own custom SCCM SSRS report.
If you need to identify machines with specific software installed on a device but would also like to know whether they have a certain version of the stated software or below, then you can use the below query. This can help with software upgrades to identify machines that have not yet been upgraded. SCCM Collection…
If you want to add a local machine user to your deployed machine during your SCCM OSD process then you can do this using a standard “Run Command Line” step. Instructions So, you need to add a “Run Command Line” step in your task sequence towards the end, after the Windows deployment and after the…
Autodesk 2020 serial numbers are now available for collection using SCCM and our guide will walk you through how to do it.
Problem Scenario When using SCCM, you may find that you want to either add or remove application deployments based on what administrative categories each application has assigned. As an example, we had a number of applications for the Marketing department that were only distributed to a Marketing collection we had set up with only Marketing…
Just a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only. This query you can use to create a collection to do this: You can check out our other SCCM collection queries by following this link. Free Subscription If you want to…
Autodesk 2020 serial numbers are now available for collection using SCCM and our guide will walk you through how to do it.
Adobe have released version 12.3.5.205 of their Shockwave Player software and if you would like to either add this to your Configuration Manager Software Catalog or even have it available through WDS or Group Policy, then you will want to download the MSI file for it. Adobe do provide a direct download link for its…
We manage a number of businesses across the world and we very often have to ensure that end-users in different countries have their required Windows languages available to them. We do this in two ways, one is that when Windows devices get built for a user in, let’s say France, the System Center Configuration Manager…
Autodesk 2020 serial numbers are now available for collection using SCCM and our guide will walk you through how to do it.
We recently had a situation where we needed to upgrade our SQL server that had the System Center Service Manager (SCSM) databases on it. This meant that we would need to migrate the databases from the old server to the new server. We thought that this would be a fairly straight forward task and it…
We were running through our list of servers and looking at what each one was doing in terms of Domain Controllers, Exchange servers, SQL servers, System Center servers etc when we noticed that we had quite a few servers that were using pretty small databases but had a large amount of host resource allocated to…
Adobe have released version 12.3.4.204 of their Shockwave Player software and if you would like to either add this to your Configuration Manager Software Catalog or even have it available through WDS or Group Policy, then you will want to download the MSI file for it. Adobe do provide a direct download link for its…
We recently helped out with a data migration which included creating a completely new set of Active Directory security groups. They wanted all the members to have the same level of access but wanted all the new security groups to have a matching standard. So we needed to create all the new security groups and…
We were asked recently about how to use a SCCM package to amend current user registry keys (HCU). To be honest, we didn’t really know, HCU registry changes have always been a bit of a nightmare to manage. However, we started to have a look around and found an excellent guide on how to carry…
CMTrace is an awesome tool and I have been copying it onto an end users machine using a batch file during the OSD process for years. But finally, Microsoft have added it into the Configuration Manager Client installation. So, once you have an up to date client installed on a users machine, you can browse…
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…
