Eswar Koneti Blog
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
    • SCCM Reports
  • Windows 10
  • Orchestrator (SCORCH) Guides
  • Trainings /Webcasts
    • SCCM 2007
    • SCCM 2012 Labs
    • SQL Server 2005
    • MDOP
  • About Author
Friday, 22 February 2019

Category: SQL Queries

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

Posted on January 21, 2019 by Eswar Koneti | 0 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…
Read more »

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…
Read more »

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…
Read more »

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…
Read more »

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…
Read more »

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…
Read more »

SCCM Report for Missing Boundaries and Troubleshooting

Posted on January 17, 2018 by Eswar Koneti | 8 Comments
  Introduction: Boundaries for SCCM define network locations on your intranet that can contain devices that you want to manage. Boundary groups are logical groups of boundaries that you configure.…
Read more »

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

Posted on January 13, 2018 by Eswar Koneti | 1 Comment
  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…
Read more »
1 2 … 21 Next →

Awards

  • Latest
  • Popular
  • Comments
  • Managing Microsoft Edge browser on iOS/Android (Notes from the field)

    Managing Microsoft Edge browser on iOS/Android (Notes from the field)

    February 21, 2019
  • How to control Office proplus channel and which office apps are available to download from office portal

    How to control Office proplus channel and which office apps are available to download from office portal

    January 30, 2019
  • SCCM Technical preview version 1901 – Management insight rules for collections

    SCCM Technical preview version 1901 – Management insight rules for collections

    January 26, 2019
  • SCCM Report Get list of devices with pending reboot in a collection with different states

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

    January 21, 2019
  • 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
  • SCCM Configmgr SSRS Report Quick way to check if Clients are compliant or not for all the approved patches?

    SCCM Configmgr SSRS Report Quick way to check if Clients are compliant or not for all the approved patches?

    February 6, 2016
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • Eswar Koneti Hi, this is too late to respond but did you solve it ? do yo
  • Eswar Koneti Hi, I tried in CMCB 1802 and it works .Have you tried checki
  • Eswar Koneti Hi John, It doesnt need any certs however if you are running
  • Eswar Koneti Hi Nick, This is possible and you can make use of these soft

–

Subscribe to Blog via Email

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

Join 724 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

Translate This Page

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