All about Microsoft Endpoint Manager
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
  • SCCM Reports
  • Intune
  • About Author
Thursday, 1 June 2023

Category: SQL Queries

SCCM report list collections with no deployments

Posted on December 5, 2022 by Eswar Koneti | 6 Comments
The following SQL query can be used to query the list of collections that doesn't have any deployments. you can review the number of collections with no deployments and you…
Read more »

How to migrate standalone MBAM to SCCM for bitlocker

Posted on November 10, 2022 by Eswar Koneti | 5 Comments
We all know that Microsoft BitLocker Administration and Monitoring (MBAM) is an administrative tool for managing BitLocker Drive Encryption for windows devices that are on-prem domain joined. MBAM mainstream support…
Read more »

Investigating SCCM Client Policy Request and Communication Status with a Collection Specific Report

Posted on October 15, 2022 by Eswar Koneti | 14 Comments
Being as SCCM Configmgr administrator, your primary aspect is to maintain health of your sccm clients for application deployment,software updates,inventory etc. Questions often come up in forums ,email list asking…
Read more »

What is new in Configuration Manager 2111 Reporting

Posted on December 4, 2021 by Eswar Koneti | 2 Comments
Microsoft has released the version 2111 for Configuration Manager (Current Branch) which is now available as in-console update and is currently via opt-in script. You can apply this update on…
Read more »

Audit messages for software update deployments in Configuration Manager

Posted on March 5, 2021 by Eswar Koneti | 0 Comments
In Microsoft Endpoint Configuration Manager, To monitor infrastructure and operations, we use the Monitoring workspace in the Configuration Manager console. One of the common ask in many forums is that…
Read more »

What is new in Configuration Manager 2010 reporting

Posted on December 1, 2020 by Eswar Koneti | 0 Comments
Microsoft has released update 2010 for Endpoint Manager Configuration Manager , the last build for this year with some great and enhanced features, for a complete list, please refer to…
Read more »

Use SCCM to find the excluded apps in Microsoft 365 Apps or Office 365 Proplus for custom reporting

Posted on November 18, 2020 by Eswar Koneti | 0 Comments
I was asked by a customer to find the devices with excluded apps in C2R products such as Office 365 Proplus or Microsoft 365 Apps or Office 2019 etc. When…
Read more »

Create a collection and upgrade the Configuration Manager Console

Posted on October 20, 2020 by Eswar Koneti | 2 Comments
I was recently assisting a customer on the Configuration Manager upgrade and after the upgrade is done, we need to upgrade the console on endpoint devices to the latest version.…
Read more »
1 2 … 23 Next →

Eswar Koneti

Awards

Support the website

  • Latest
  • Popular
  • Comments
  • Company portal – Install option grayed out due to primary user

    Company portal – Install option grayed out due to primary user

    May 9, 2023
  • Efficiently Target Your Devices and Users with Intune Filters

    Efficiently Target Your Devices and Users with Intune Filters

    April 16, 2023
  • MyApps and Conditional Access – Exclude with ease

    MyApps and Conditional Access – Exclude with ease

    January 26, 2023
  • Efficiently Identify Co-Managed Devices: Techniques and Tools

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 2023
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    March 25, 2010
  • SCCM report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • Eswar Koneti Hi Bob, can you post your query here for me to look at it? i
  • Andre Piva Thanks! I lost a lot of time with this screen, several forma
  • Bob Hiya, this mostly works however it's definitely flagging som
  • Eswar Koneti Hi, with windows 10 and windows 11, you hardly need to use t

.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7,434 other subscribers

@eskonr on Twitter

Tweets Eswar

All Rights Reserved

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Archives

.

© Copyright 2009-2023 Eswar Koneti , All rights reserved.