Hello,

Can you help me with identifying computers that still has a certain patch installed?

I would like to do it as report or query but I'm clueless how to begin. I have found similar questions here but answers have syntax problems and basically, I don't know what the query means and how to edit it to what I need. 

What I need is to identify and list computers from a collection, that still has KB3023562 installe

Have you looked at the built-in reports, at least one of them will do this for you.

I did, but I didn't find any that would work like this.

Chances are that I'm either blind or I don't know what to be looking for.

What report in SCCM 2007 do you have in mind?

In SCCM 2007 depending on the reporting that you have installed you should have luck with: Compliance - Specific software update states <secondary> At any rate if you filter by the software update category of reports you should find what you need.

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator 17 hours 19 minutes ago

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S 17 hours 58 minutes ago

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM
• Proposed as answer by Garth JonesMVP, Moderator Saturday, March 14, 2015 2:13 PM
• Marked as answer by Jiri S Tuesday, March 17, 2015 1:35 PM

select v_R_System.Name0,UpdateID,ID,Title,LastStateName,LastStatusTime as 'Installed Date' from v_GS_PatchStatusEx inner join v_R_System on v_GS_PatchStatusEx.ResourceID=v_R_System.ResourceID
where Title='Security Update for Windows Server 2012 R2 (KB2961072)' and LastStateName like 'Install Verified' order by AgentInstallDate desc

• Edited by Ashribad Rout Thursday, February 26, 2015 2:07 PM

Thank you all, I will try these and let you know.

this one worked for me