Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CrashRider

    How to exclude clusers

    I get an error when trying to do the exclude systems in another container 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 inner join...
  2. CrashRider

    How to exclude clusers

    I need to exclude clustered servers from a Collection. I tried to do it by not equal to service name "Cluster Service" but it they still showed up. Thanks, Codis
  3. CrashRider

    Need Help: Need to build a collection of just my Domain controllers

    I got it! 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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID =...
  4. CrashRider

    Need Help: Need to build a collection of just my Domain controllers

    I've been trying to figure this out all morning. I need a query that will pull in only domain controllers. I did look at the domain role section but the atributes 0-5 seemed to be fore the Operation Roles. Thank you for any help, Crash

Part and Inventory Search

Back
Top