Making IT Happen
All articles about Microsoft System Center range of products.
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 […]
![Create an SSRS Report using Configuration Manager Database Data [2023 Updated]](https://blog.techygeekshome.info/wp-content/uploads/2014/04/SSRS-Report-using-Configuration-Manager-Database-Data.png "Create an SSRS Report using Configuration Manager Database Data [2023 Updated] 3")
![SCCM Collection Query for Devices with specific software installed and version or below [2023 Updated]](https://blog.techygeekshome.info/wp-content/uploads/2014/01/sccm_mecm_logo.jpg "SCCM Collection Query for Devices with specific software installed and version or below [2023 Updated] 4"){kind=logo}
![SCCM – Add Local User During OSD [2023 Updated]](https://blog.techygeekshome.info/wp-content/uploads/2016/02/SCCM-Add-Local-User-During-OSD.png "SCCM - Add Local User During OSD [2023 Updated] 5")
