Ankit Shukla

Let’s see how to find out SCCM SQL Query Windows 10 Version Count | Dashboard | SCCM. The different versions of Windows 10 use SQL queries and the total number of Windows 10 versions is calculated using the SQL query. Since most environments are moving towards Windows 10 or have moved to it, tracking down […]

Let’s learn how to Install Multiple Applications using ConfigMgr Task Sequence. As an SCCM Admin, you might have encountered a scenario where your customer asked if we could build a machine for a specific department, like Finance, and install the required application during the machine build. There are many ways to achieve this requirement. You […]

This post teaches about ConfigMgr Task Sequence OSD Multiple Physical Drives. Let’s try to understand how we can use conditions in the Task sequence to install operating systems via the SCCM Task Sequence on a machine having dual drives. SCCM OSD, which stands for Operating System Deployment, is a crucial management solution within the SCCM […]

Let’s build an SCCM Report Office 365 Client Upgrade Readiness Dashboard. This post continues with Part 1 and Part 2. In my previous posts, we imported two raw data reports that gave us information about different versions of Microsoft Office.  We also understood a few more details were added after enabling the ‘Office365 ProPlusConfigurations‘ information on Office […]

Let’s discuss SCCM SQL Query to Find Collections Used for App Deployment | ConfigMgr. In this post, I will explain the ConfigMgr Application, Packages, and collections used to deploy using the SQL query. We shared many other SQL queries and custom reports with the HTMD Forum community. The following sections provide more details about the […]

In this post, we will create an SCCM Microsoft 365 App Report Dashboard by importing the rdl file and see how we can interlink the previous post with this one. We will also understand a few Columns enabled in the Hardware Inventory of Office365 ProPlusConfigurations and how to use those columns. This post continues in […]

Let’s learn more about SCCM Microsoft 365 Office Client Management Reports. In this series of posts, I will share the RDL files for custom reporting of Microsoft 365 apps (a.k.a. Office 365 Pro Plus) reports. Many organizations have already moved to Office 365, some are in the middle of upgrading, and some have yet to […]

In this post, I will explain how to Install VAMT Activate Windows 7 ESU keys using VAMT | SCCM. Let’s learn how to install and activate VAMT (Volume Activation Management Tool) and how to automatically activate Windows 7 devices for extended security updates (ESU). Microsoft announced the end of Windows 7 on January 14, 2020. […]

Let’s find the ConfigMgr Include Membership collection Rule using Custom Report, SQL query, and report builder. We have many other SQL queries and custom reports we shared with the HTMD Forum community. An Include Membership Rule adds members from another collection to the device collection where the rule is applied. Membership rules cannot be added […]

Today we will discuss SCCM Application Deployment Based on System Description | ConfigMgr. Let’s learn how to Deploy Application Based on Active Directory System Description using ConfigMgr (a.k.a SCCM). I have been using the AD system description to create a dynamic collection and deploy applications based on the description. Well, it’s SCCM Application Deployment Based […]

Let’s find the ConfigMgr or SCCM Application Deployment Status using Custom Report, SQL query, and report builder. We have many other SQL queries and custom reports we shared with the HTMD Forum community. In this post, I will explain how to create a working Application Deployment SQL query to find the deployment status from your […]

Find more details on SCCM Client Version Dashboard SQL Query Custom Report. Let’s see how to create a custom SCCM Client Version Dashboard using a report builder and SQL query. Since the release of the Configuration Manager (aka SCCM) Current Branch, admins must analyze and keep their environments up to date with the latest client […]

Let’s learn how to Create the SCCM Custom Report Using Report Builder. If you are an SCCM Admin in your organization, you might have been asked to create custom reports according to customer requirements. Some admins create WQL queries, and some prefer to work on SQL Queries and achieve their desired results. Creating SCCM Custom […]

Hi, My name is Ankit Shukla. In my first post, let’s discuss FIX SCCM OSD Machine Domain Join Issue ldap_add_s failed: 0x35 0x216d. My Posts will help you find the solution, but if you start following them, you will see the approach we need to follow while troubleshooting issues. I have worked in SCCM/MECM technology […]

Let’s build an SCCM Report Office 365 Client Upgrade Readiness Dashboard. This post continues with Part 1 and Part 2. In my previous posts, we imported two raw data reports that gave us information about different versions of Microsoft Office.  We also understood a few more details were added after enabling the ‘Office365 ProPlusConfigurations‘ information on Office […]

Let’s discuss SCCM SQL Query to Find Collections Used for App Deployment | ConfigMgr. In this post, I will explain the ConfigMgr Application, Packages, and collections used to deploy using the SQL query. We shared many other SQL queries and custom reports with the HTMD Forum community. The following sections provide more details about the […]

Hi, My name is Ankit Shukla. In my first post, let’s discuss FIX SCCM OSD Machine Domain Join Issue ldap_add_s failed: 0x35 0x216d. My Posts will help you find the solution, but if you start following them, you will see the approach we need to follow while troubleshooting issues. I have worked in SCCM/MECM technology […]

Let’s learn how to Create the SCCM Custom Report Using Report Builder. If you are an SCCM Admin in your organization, you might have been asked to create custom reports according to customer requirements. Some admins create WQL queries, and some prefer to work on SQL Queries and achieve their desired results. Creating SCCM Custom […]

Find more details on SCCM Client Version Dashboard SQL Query Custom Report. Let’s see how to create a custom SCCM Client Version Dashboard using a report builder and SQL query. Since the release of the Configuration Manager (aka SCCM) Current Branch, admins must analyze and keep their environments up to date with the latest client […]

Let’s find the ConfigMgr or SCCM Application Deployment Status using Custom Report, SQL query, and report builder. We have many other SQL queries and custom reports we shared with the HTMD Forum community. In this post, I will explain how to create a working Application Deployment SQL query to find the deployment status from your […]

Today we will discuss SCCM Application Deployment Based on System Description | ConfigMgr. Let’s learn how to Deploy Application Based on Active Directory System Description using ConfigMgr (a.k.a SCCM). I have been using the AD system description to create a dynamic collection and deploy applications based on the description. Well, it’s SCCM Application Deployment Based […]

Let’s find the ConfigMgr Include Membership collection Rule using Custom Report, SQL query, and report builder. We have many other SQL queries and custom reports we shared with the HTMD Forum community. An Include Membership Rule adds members from another collection to the device collection where the rule is applied. Membership rules cannot be added […]

In this post, I will explain how to Install VAMT Activate Windows 7 ESU keys using VAMT | SCCM. Let’s learn how to install and activate VAMT (Volume Activation Management Tool) and how to automatically activate Windows 7 devices for extended security updates (ESU). Microsoft announced the end of Windows 7 on January 14, 2020. […]

Let’s learn more about SCCM Microsoft 365 Office Client Management Reports. In this series of posts, I will share the RDL files for custom reporting of Microsoft 365 apps (a.k.a. Office 365 Pro Plus) reports. Many organizations have already moved to Office 365, some are in the middle of upgrading, and some have yet to […]

In this post, we will create an SCCM Microsoft 365 App Report Dashboard by importing the rdl file and see how we can interlink the previous post with this one. We will also understand a few Columns enabled in the Hardware Inventory of Office365 ProPlusConfigurations and how to use those columns. This post continues in […]