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
Saturday, 3 June 2023

Tags: subselected query

SCCM Configmgr SQL WQL query compare 2 or more collections to get the difference

SCCM Configmgr SQL WQL query compare 2 or more collections to get the difference

Posted on March 22, 2017 by Eswar Koneti | 1 Comment | 4,480 Views
This is quick post to show you ,how to compare 2 or more collections to find clients that are not member of other collections. The reason for me to write this collection is ,for server patching ,we have been using direct membership rules ( I know AD sec groups is good way to automate this…
Read more »

SCCM collection based on Heartbeat Agent older than X days

Posted on November 29, 2011 by Eswar Koneti | 6 Comments | 12,779 Views
In my previous post,we saw how to create SCCM report to list clients with its heartbeat time stamp . In this post ,we are going to see ,how to create Create a collection to list clients that are not sending or not reported to SCCM since X days based on its heartbeat (DDR) agent time. To get…
Read more »

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.