SCCM

Setting the Local Computer Description During SCCM Task Sequence

Setting the Local Computer Description During SCCM Task Sequence

If you are using Configuration Manager (SCCM) to deploy your operating systems, you might want to set the local computer description during the task sequence phase. This is a straightforward process, and you can either manually input the computer name during the task sequence or use an HTA (HTML Application) at the beginning of the […]

Setting Computer Name Automatically During SCCM OSD Process

Setting Computer Name Automatically During SCCM OSD Process

We have been looking into getting our OSD process to automatically change the computer name to what we want it to be for a while now but never really had much luck with it. Reading various forums and blogs, many people have said to use WSNAME and many others saying use scripts, all of which […]

Configuration Manager – Where are my OSD Task Sequence Log Files?

Configuration Manager – Where are my OSD Task Sequence Log Files?

When running Configuration Manager OSD Task Sequences, it can be extremely frustrating trying to find the ever moving log files if you get an error during the deployment. The log files move locations on your hard disk depending on what stage of deployment your task sequence is at. To try and help you find where […]

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot

Creating a query for Power BI from the System Center Configuration Manager (SCCM) database to identify devices pending a reboot involves several steps. Below is a detailed approach, including the SQL query to extract the relevant data. 1. Understand the SCCM Database Structure The SCCM database contains several tables and views. Key tables/views for this […]

SCCM SUP Products Server 2022 Hotpatch

SCCM SUP Products Server 2022 Hotpatch

Following on in our series on SCCM SUP Product definitions, today we are looking at the Server 2022 Hotpatch Product. You can view the other product definition posts we have posted using the button below: Definition and Purpose What It Covers The Server 2022 Hotpatch category includes updates that can be applied to Windows Server […]

SCCM SUP OOBE ZDP (Out-of-Box Experience Zero Day Patch)

SCCM SUP OOBE ZDP (Out-of-Box Experience Zero Day Patch)

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 […]

Reporting on Office 365 Channels with SQL Query

Reporting on Office 365 Channels with SQL Query

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 […]

The Ultimate Guide to Adobe Acrobat Reader: Silent and Unattended Installation

The Ultimate Guide to Adobe Acrobat Reader: Silent and Unattended Installation

Adobe Acrobat Reader is an essential tool for viewing, printing, and annotating PDF documents. Whether you’re a casual user or an IT administrator managing multiple installations, deploying Adobe Acrobat Reader silently and unattended can save time and streamline the process. In this comprehensive guide, we’ll explore how to achieve just that. Why Silent and Unattended […]

SQL Queries for Make, Model and Architectures of Devices

SQL Queries for Make, Model and Architectures of Devices

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 […]

Use Powershell to download the latest offline definition updates for Microsoft Forefront Client Security, Microsoft Forefront Endpoint Protection 2010 and Microsoft System Center 2012 Endpoint Protection

Use Powershell to download the latest offline definition updates for Microsoft Forefront Client Security, Microsoft Forefront Endpoint Protection 2010 and Microsoft System Center 2012 Endpoint Protection

This post will show you how to download the latest anti-malware definition updates for Microsoft Forefront Client Security, Microsoft Forefront Endpoint Protection 2010 and Microsoft System Center 2012 Endpoint Protection using Powershell commands. Step by Step Guide Windows x86 (32-bit) To download the definition updates files for 32-bit (x86-based) versions of Windows, run the following […]

30 Useful SCCM SQL Queries

30 Useful SCCM SQL Queries

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 […]

Scroll to top