I have a couple queries setup, but I'm not sure if I'm doing them right. I have the software update setup to send XP SP3, but the problem is that when I look, it shows plenty of computers that show it as "required", but they won't install SP3 for whatever reason.So, I tried to build a query to show computers with XP SP3 and then computers that weren't in that list. I have it set to show the System Name, Last Logged In User, System Operating System Name, and Operating System CSD Version. Here is my query for looking for anything with XP SP3 that only returns the system name:select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%windows xp service pack 3%"The problem is that the one I had was showing computers that were showing SP3 in Add/Remove and so I've been changing it around. What I'm trying to find is a way to build and up-to-date query that shows all systems without XP SP3 so we can get those numbers to our upper management and then find out why Software Updates isn't installing it. That being said, I don't know how to find any computer without XP SP3. The way I've always done is is make a query that looks for it, then make a sub-select statement referencing that query, but when I did, some computers showed that they had "SP3".