locked
Collection setting RRS feed

  • Question

  • Dear All

        I install new Primary sccm server on my HQ, I configure boundaries by IP on each Floor. I need to create new collection defiand by IP address on each floor, I see on property on collection, I can not find rule that can used IP for defind client member, please tell me how to do it, it make by defule membership rule or we must create sql query

    Wednesday, December 22, 2010 1:44 AM

Answers

  • Hi

    This query will gve you all the computers in a specific subnet

    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.IPSubnets = "192.168.3.0"


    Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
    • Marked as answer by densei27 Friday, December 24, 2010 4:42 AM
    Wednesday, December 22, 2010 5:38 AM

All replies

  • Hi

    This query will gve you all the computers in a specific subnet

    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.IPSubnets = "192.168.3.0"


    Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
    • Marked as answer by densei27 Friday, December 24, 2010 4:42 AM
    Wednesday, December 22, 2010 5:38 AM
  • Dear Kent

     

       It work, thank you for your support

    Friday, December 24, 2010 4:42 AM