subselected query – All about Microsoft Endpoint Manager

Saturday, 3 June 2023

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…

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…