Collection Query Help

Question

I am trying to modify this query to exclude windows 2003 servers. Any help would be much appreciated I am not a SQL guy at all

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.Client is null

Answer 1

You'd be better off doing another Collection with a Query for Server 2003, then exclude it from your collection.

You can actually look at this script, as it would create all of the collections you'd probably want, then create your own with Includes & Excludes to get your desired group of machines: https://github.com/prae1809/PowerShell-Scripts/tree/master/OperationalCollections

Also note, Collections are not SQL, they are WQL: https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/create-queries

Answer 2

@Zachery Chandler
Thank you for posting in Microsoft Q&A forum.
You may use the query like below:

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.Client is null and OperatingSystemNameandVersion not like '%Server 5.2%'  

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.