Create an SCCM query to show only Windows Servers in a collection

Problem:
You only want to see Windows Servers in an SCCM collection

Solution:
Use the following SCCM query:

select * from sms_r_system where OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%'