Anoop C Nair

I got the error “Unable to complete secondary site server installation” while installing a new Configuration Manager secondary server. Let’s try to fix the SCCM Secondary Server Installation Failed Error. Another error I could see in the ConfigMgr console related to SQL DB permissions. Either the user account running Configuration Manager Setup or NT AUTHORITY\SYSTEM […]

Learn how to Add SCCM Server Computer Account to SQL Login. Also, this post might help you learn how to add Sys Admin Access to a ConfigMgr server computer account. To complete this activity, the user account should have Sys Admin access to SQL DB. System administrators, also known as Sys Admins, play a crucial […]

Look at the step-by-step guide for installing Configuration Manager (a.k.a. SCCM) on a secondary server. The following sections provide more details about SCCM secondary server installation. You can’t install a secondary server without a primary server. A secondary site is designed to be installed as a child site under a primary site, effectively expanding the […]

Let’s find a list of devices that have SCCM CMPivot Query Patches Installed in last 90 Days. The ConfigMgr CMPivot provides real-time data based on fast-channel architecture. The Configuration Manager CMPivot tool allows us to assess the state of devices quickly. When a query is executed against a device collection, CMPivot promptly runs the query in […]

In this post, I will explain the SCCM Primary Server Upgrade to 2006. Microsoft released the latest version of Microsoft Endpoint Configuration Manager 2006; the 2006 version of ConfigMgr is generally available. This step-by-step guide provides all the details required to perform the SCCM Primary Server Upgrade to 2006. The 2006 update for Configuration Manager’s […]

Let’s Find devices with Windows 10 English Language(US) installed using ConfigMgr CMPivot Query. I have seen many questions in HTMDForum that we want the SCCM CMPivot pending reboot. In this post, you will learn how to use the SCCM CMPivot query to discover Windows 10 English Language Devices. You can customize the CMPivot query according to your […]

Create a Shortcut for Access Work or School Accounts section in Windows 10 settings apps. Let’s learn how to create a shortcut for Windows 10 settings apps. In this particular example, we will see something useful for Intune admins. Windows allows you to easily add multiple user accounts to a single device, ensuring that each […]

Hi, I will talk about Windows 10 Product Key Change Home to Professional Upgrade | Activate today. This quick guide will show you how to upgrade Windows 10 Home to a professional edition without formatting or reinstalling the System. You can use the Windows 10 Product Key change option to upgrade from Home to Professional […]

Today, I will explain SCCM Troubleshooting Out-of-Band Hotfix Logs | ConfigMgr. Let’s learn how to troubleshoot out-of-band hotfix installation logs. More details are available at Dmpdownloader.log (DMP Downloader Troubleshooting with State Messages), which I have already posted. Several hotfixes are released with limited availability to address specific issues, while others are universally applicable but cannot […]

You can Understand the TCP Reverse Connect Flow for AVD using Event Logs. Let’s quickly review the WVD event logs using TCP Reverse Connect technologies. You can also check this internal process of RDP connection through the secure channel from Windows 10 devices. In the previous post, I have a WVD Troubleshooting Options Tips Tricks […]

Let’s Find Missing Patches using ConfigMgr CMPivot Query. I have seen many questions in HTMDForum that we want the patch report using the SQL query. In this post, you will learn how to use the SCCM CMPivot query to find missing patches. You can customize the CMPivot query according to your needs and requirements. The main CMPivot […]

Let’s understand how to Fix SCCM Duplicate Records when Co-Management and tenant Attachment are enabled. Microsoft recently released a new hotfix for ConfigMgr 2002, KB 4575339, to fix the co-managed devices duplicated in the Microsoft Endpoint Manager admin centre. The KB 4575339 hotfix is an out-of-band hotfix similar to the one we discussed for the […]

Let’s discover the SCCM CMPivot Query for Devices with more than 15 GB of Free Disk Space. The ConfigMgr CMPivot is based on a fast-channel notification architecture. CM Pivot is a valuable feature within SCCM that enables administrators to execute real-time device queries, offering immediate insights into various aspects of the managed environment. The Configuration […]

In today’s post, we will learn the easiest way to create an SCCM query to group users and discover All Active Directory Security Groups. Then, we will see how to use the WQL query to create a Dynamic user Collection. In Configuration Manager, you can create and execute queries to pinpoint objects within the hierarchy […]

Let’s find out the SCCM Application Deployment Custom Report SQL Query with Collection. I have seen many questions in HTMDForum that we want the application-related reports, how to write a SQL query to write a report on app deployment, etc. In this post, you will learn how to create a working Configuration Manager SQL query […]

This post will discuss the AVD Disable Shutdown Button for Windows 10 Devices Using Intune. Let’s find the easiest way to turn off the shutdown button for an AVD (aka Azure Virtual Desktop) VM. AVD VM management with Intune is looking great! This statement applies to all supported AVD, Intune, and Azure AD scenarios. By […]

Let’s check SCCM CMPivot Architecture and Sample Queries in this post. CMPivot allows you to quickly assess the state of devices in your environment and take action. Fast channel architecture changed the entire behavior of SCCM. Now it’s not at all a slow-moving server(SMS). You can make it run as fast as you can. The […]

Key Takeaways Here, we are discussing Microsoft Azure Removes Default Internet Access for New Virtual Networks. According to the latest news coming that After March 31, 2026, any newly created Virtual Network (VNet) will no longer have automatic access to the internet. This update was highlighted by Christiaan Brinkhoff on his social media platform. Microsoft […]

Let’s discuss how to Enable or Disable Device Delete Setting for Diagnostic Data in Windows using Intune Policy. Intune system settings let users manage device features by creating configuration profiles. These profiles control how devices act and ensure they follow company rules. The Disable Device Delete policy in System settings controls if the delete diagnostic […]

Let’s explore the 3 Easy Methods to Delete Alternate Rows in Microsoft Excel. Excel arranges data in a grid with numbered rows and lettered columns. This lets users easily perform calculations and other tasks using formulas and functions. In this article, I will explain how to delete every other row in Excel. There are three […]

This blog post explains Enforce DDM Software Updates on macOS Device using Intune Settings Catalog. DDM makes it easier to handle updates. Devices can now automatically manage updates based on set policies. This reduces interruptions for users and improves their overall experience. Through macOS Settings, IT administrators can control the macOS versions in their organization, […]

Let’s discuss Entra Refresh Tokens Valid for 90 Days Key Actions Based on Your Licensing Entra ID Free E3 P1 and E5 P2. Microsoft extended the default validity of the Entra Refresh token to 90 days. Before the recent update, the validity of tokens was typically 14-90 days, depending on the configuration. Refresh tokens themselves do not require a specific […]

Microsoft rolled out a New Office ADMX Template Version: 5469.1000 for Microsoft 365 Apps for enterprise Project and Visio. This post shows how to import the ADMX template to Intune. The administrative Template files (ADMX/ADML) for Microsoft Office have been significantly updated. IT administrators use the Administrative Template files (ADMX/ADML) for Microsoft Office to manage and […]

Let’s discuss the Top 83 Windows 11 Desktop Admin Interview Questions. Desktop Admins are the real heroes of the IT world because they are real people who interact with end users. They help users resolve various issues in the cyber world. They are technology problem resolvers responsible for establishing, diagnosing, repairing, maintaining, and upgrading hardware […]

Let’s discuss the AZ-500 Exam Prep Guide Microsoft Azure Security Engineer Associate Professional Certificate. This exam is designed for professionals working with Azure security services and solutions. It validates a candidate’s expertise in managing Azure security controls, identity management, and securing data, applications, and networks in Azure environments. This certification is ideal for security engineers […]

Hi, there today with a new topic Allow or Block Audio Capture Policy in MS Edge Browser using M365 Admin Center. As we all know that Edge browser is one of the significant browsers that uses in many organizations. With the help of MS365, they are providing a list of policies for oragnizations. So we […]

Hi there today we are discussing how to Allow or Block Web Authentication Requests on Sites with Broken TLS Certificates in Edge Browser using M365 Admin Center. As you all know that security measurements are very important for the users Especially using a browser. Here secure method that allows users to log in to websites […]

SCCM DP Roles have PXE and Throttling Options ConfigMgr. Exciting changes have been made to the Configuration Manager 2012 DP and PXE (more details). In Configuration Manager 2012, unifying infrastructure and simplifying administration are two of the release’s three key pillars (the third is user empowerment). Keeping those pillars in mind, we have updated the […]