SSRS Report – All about Microsoft Endpoint Manager

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

Posted on October 15, 2022 by Eswar Koneti | 14 Comments | 12,534 Views

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 for ,list of computers not contacted the server since X days (25) or how do I know the clients who’s policy request is old or…

SCCM Report Get list of devices with pending reboot in a collection with different states

Posted on January 21, 2019 by Eswar Koneti | 10 Comments | 41,214 Views

Beginning with the release of SCCM ConfigMgr Build 1710 or later , you can use the SCCM Console to identify client devices that require a restart, and then use a client notification action to restart them. If you want get this feature enabled on the client side ,you must also upgrade clients to version…

SCCM Report for Missing Boundaries and Troubleshooting

Posted on January 17, 2018 by Eswar Koneti | 14 Comments | 17,841 Views

Note:If you are running Microsoft Endpoint Manager Configuration Manager 2002 and later, this post is not applicable. In 2002 and later builds, the boundary group information is available as default value for client devices and you dont need to extend the custom MOF file. For more information about boundary groups in build 2002 and later,…

Configmgr Report list empty collections with no query rules defined (collection clean-up)

Posted on January 13, 2018 by Eswar Koneti | 1 Comment | 5,196 Views

I was looking at the console other day and found that, there were many collections created in the root folder (device collection) with 0 count. So i looked at the collection properties ,i found empty there (No direct or query based rule). So i decided to write SQL query to identify the list of…

Configmgr How use compliance settings to check windows update agent version (WUA) is older ,Collection and SQL query

Posted on November 9, 2017 by Eswar Koneti | 0 Comments | 4,213 Views

Using compliance settings in Configmgr, you can do many tasks as part of compliance. In the last couple of blogs, we have utilized compliance settings to identify WU settings,automatic update,trusted publisher settings etc. http://eskonr.com/2017/10/configmgr-how-to-use-compliance-settings-to-check-the-windows-update-policy-settings-like-wuserver-usewuservernoautoupdate-on-clients/ In this blog post ,we will see how to use compliance settings to check for Windows update agent version if it…

SCCM Configmgr Report for Boundary group relationships with Fallback Sites

Posted on September 16, 2017 by Eswar Koneti | 5 Comments | 6,914 Views

Beginning with configuration manager version 1702, clients use boundary groups to find a new software update point. You can add individual software update points to different boundary groups to control which site servers, a client can find the content or update scan. More information about boundary groups and its relationship with software update point changes…

SCCM Configmgr Software Update Compliance Report for Specific Collection within Specific Time Frame

Posted on July 20, 2017 by Eswar Koneti | 30 Comments | 15,794 Views

In this post, i will discuss about the requirement that i have got recently. Local team /manager wants to run the software update compliance report for their LBU machines (collections) to see if all the clients in collection are compliant or not for all the patches with released date between X date to Y date.…

How to Query Clients collection or SSRS with Online Status in SCCM Configmgr 1602

Posted on April 19, 2016 by Eswar Koneti | 13 Comments | 20,862 Views

Microsoft has introduced new feature in System Center Configuration manager Build Version 1602 called Client Online Status .This is really cool and exciting feature which is really needed these days to know if the computer is online or offline (of course ,SCCM agent must be working and healthy which is different story). A new…