SQL Queries | Eswar Koneti Blog

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

Posted on May 31, 2019 by Eswar Koneti | 0 Comments

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 | 2 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…

SCCM Configmgr monitoring Collection Evaluations and change update membership schedule using powershell

Posted on January 1, 2019 by Eswar Koneti | 1 Comment

Introduction: It has been very long since i did post on Configmgr as i am spending more time on office 365 projects but i got something on SCCM this…

SCCM Configmgr CB 1802 SQL Views documentation

Posted on March 23, 2018 by Eswar Koneti | 2 Comments

With the release of SCCM Configmgr current branch 1802 ,there are some exciting features added from its previous version 1710. When there are new features released ,certainly there will…

SQL query to get client count with status active obsolete missing for collections in tabular column

Posted on March 19, 2018 by Eswar Koneti | 3 Comments

Quick blog post on how to get client count with active obsolete and missing status for collections in a nice tabular column. I used 3 SQL views in this…

SCCM Configmgr Technical Preview 1802 available

Posted on February 14, 2018 by Eswar Koneti | 1 Comment

On this Valentine day (Feb 14,2018 ), Microsoft released Feb 2018 Technical preview version 1802 for Configuration Manager with large number of features (21) that ever released before. These…