I am wondering why Windows Server 2008 Standard, etc. is missing from the possible values when selecting from Operating System Name and looking at the subsequent values, even Windows 7 is there, but not Server 2008.Using operating system version is worthless since WIndows Vista version number is the same. SnoBoy

I had tried the above, but SCCM changed it after entering to: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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name like "Microsoft Windows Server 2008%"which worked eventually.I hada problem to fix but am left with a question. The problem was that SCCM was not pushing the client to the servers in the first place, which I had to do manually.The question is this: How did you know to look for, "Microsoft Windows Server 2008%" since ADU&C says that the Operating System attribute for one of my serversis: "Windows Server 2008 Standard", which I entered as "Windows Server 2008%"? Checking the computer's properties shows the OS as "Windows Server Standard", so nothing I can find matches what you entered.Is there a secret place you need to go to find out what you really need to query for? Searching for "Server 2008" without the quotes in the registry on the server finds nothing, so where doesMicrosoft Windows Server 2008 come from??WQL documentation, as far as I can tell, is a mystery inside a conumdrum wrapped in an enigma. I can't find anything helpful from MS onlineabout WQL, my SCCM Administrators' Companion doesn't document it - it leaves it at filling in the query builder.SnoBoy