+ Post New Thread
Results 1 to 3 of 3
Enterprise Software Thread, SCCM query computers not in security group in Technical; Hi, I want to make a collection based on computers not in a security group. I have done the attached ...
  1. #1

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    13,903
    Blog Entries
    8
    Thank Post
    728
    Thanked 1,371 Times in 1,201 Posts
    Rep Power
    363

    SCCM query computers not in security group

    Hi,

    I want to make a collection based on computers not in a security group. I have done the attached but it includes machines in the group.

    Any thoughts please?

    Thanks

    Code:
    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.SystemGroupName != "FALINGE\\SD-Adobe-Premiere-Elements-4.0"
    Attached Images Attached Images

  2. IDG Tech News
  3. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    13,903
    Blog Entries
    8
    Thank Post
    728
    Thanked 1,371 Times in 1,201 Posts
    Rep Power
    363
    Anyone please?

  4. #3

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    13,903
    Blog Entries
    8
    Thank Post
    728
    Thanked 1,371 Times in 1,201 Posts
    Rep Power
    363
    bump

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 10th September 2010, 07:27 AM
  2. Find security group usage in shares
    By teejay in forum Windows
    Replies: 2
    Last Post: 13th August 2010, 09:21 AM
  3. 1 computer not showing in WSUS
    By aaronjwilkinson in forum Windows Server 2000/2003
    Replies: 3
    Last Post: 3rd February 2010, 09:23 AM
  4. Replies: 13
    Last Post: 21st January 2008, 09:40 AM
  5. Security Groups in 2003
    By SpuffMonkey in forum Windows
    Replies: 1
    Last Post: 19th July 2006, 11:18 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •