locked
Looking for Query to find clients that wont ping or heartbeat. RRS feed

  • Question

  • I am working on a SCCM 2012 SP1 install that has a large number of clients that will not ping or heartbeat.

    Im looking for a query or method to discover and list them in bulk then remove them from SCCM.


    tconners

    Wednesday, October 2, 2013 2:31 PM

Answers

  • Create these collections with a query:

    Systems with no client.

    select *  from  SMS_R_System where SMS_R_System.Client = "0"

    This will allow you to look for all clients not on "your site code".(just change that to a site code i.e. "CM1")

    select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System where SMS_R_System.AgentSite != "your site code"


    Tod Elliott

    • Marked as answer by tconners Thursday, October 3, 2013 4:12 PM
    Wednesday, October 2, 2013 10:29 PM

All replies

  • Im also looking for a few other querys so I can create a few lists in excell.

    1. Systems with no site code.

    2. Systems with no client.


    tconners


    • Edited by tconners Wednesday, October 2, 2013 2:48 PM
    Wednesday, October 2, 2013 2:48 PM
  • Create these collections with a query:

    Systems with no client.

    select *  from  SMS_R_System where SMS_R_System.Client = "0"

    This will allow you to look for all clients not on "your site code".(just change that to a site code i.e. "CM1")

    select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System where SMS_R_System.AgentSite != "your site code"


    Tod Elliott

    • Marked as answer by tconners Thursday, October 3, 2013 4:12 PM
    Wednesday, October 2, 2013 10:29 PM
  • Is this correct? I'm not seeing the collections populate.....


    tconners

    Thursday, October 3, 2013 4:53 PM

  • tconners

    Thursday, October 3, 2013 4:55 PM
  • Both look right.. Keep in mind we can't wee the full query.

    http://www.enhansoft.com/

    Thursday, October 3, 2013 11:11 PM