I would like to run a report of computers that are XP and all patches are up to date

[pbalderos]

Hello

 

I would like to run a report that will show all windows XP computers (already have the query for that below) and if the patches are all up to date.

This part of the query satisfies the search for all Windows XP computers. I just need to know how to see the patch status for these machines.

 

select distinct SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.AgentTime from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "%Workstation 5.1%"

 

Any assistance would be appreciated.

Thanks,

Phil

 

[GarthMJ]

Are you looking for a report or a collection query? You state report but you posted a collection query, so...

 

If you are looking for a report have you looked at the built-in reports, what wrong with them.