SQL Queries | Eswar Koneti Blog

How to find ConfigMgr client boundary and boundary group details based on boundary group caching

Posted on December 25, 2019 by Eswar Koneti | 0 Comments

Use boundary groups in Configuration Manager to logically organize related network locations (boundaries) to make it easier to manage your infrastructure. You must Assign boundaries to boundary groups before using…

SCCM Collection–how to identify devices that have old AD system discovery timestamp ?

Posted on September 18, 2019 by Eswar Koneti | 0 Comments

SCCM has multiple discovery methods help you discover devices on your network, devices and users from Active Directory, or users from Azure Active Directory (Azure AD). Read more about the…

How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

Posted on July 23, 2019 by Eswar Koneti | 0 Comments

Configuration Manager site database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. Being SCCM Admin, you need…

Clean up your WSUS database for better performance and SCCM software update compliance

Posted on June 24, 2019 by Eswar Koneti | 2 Comments

Introduction: With the recent Current Branch updates starting from 1806 , Microsoft is making good improvement on Software updates maintenance but there is lot to come in the near future.…

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

Posted on May 31, 2019 by Eswar Koneti | 1 Comment

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname.…

What’s new in SCCM ConfigMgr 1902 Reporting

Posted on March 28, 2019 by Eswar Koneti | 0 Comments

Microsoft has released SCCM ConfigMgr Current Branch build version 1902 and is available as in-console update and baseline version. You can apply this update on sites that runs on 1710,1802,1806…

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

Posted on January 21, 2019 by Eswar Koneti | 3 Comments

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…

SCCM ConfigMgr Compliance status of client for multiple software update groups

Posted on January 9, 2019 by Eswar Koneti | 0 Comments

After long-time ,i am back with quick SCCM Configmgr software update compliance report .A friend of mine asked me today morning that ,he wants to check the compliance report…