Making IT Happen
If you are using SCCM to update your Microsoft devices, then you may have noticed the large amount of Products that are available under the Software Update Point (SUP) configuration. I’ve struggled to find good explanations for each of the products so my plan is to find out as much information as I can for […]
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 […]
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.
We recently encountered a problem with our System Center Operations Manager (SCOM) console where some old alerts could not be removed or cleared. Despite confirming that the alerts were no longer relevant, every attempt to clear them resulted in a red X generic Microsoft error, causing the console to crash. What Caused the Issue? The […]
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 […]
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 […]