SCCM Report to find Last time a patch installed on a Server

[Leebro]

Hi everyone ...

 

Just wondering if anyone has written a report that will give me a list of all the Servers and the date and time that a patch was last installed on them. As we have been asked to give a list of ALL servers and the last time they have had any patch installed.

 

ie :

 

"Servername" "The Last time a patch was successfully installed"

ABC194823 28/02/1962 12.32 AM

 

etc ...

 

I have tried with a couple of SQL Queries using LastStatusChangeTime from v_UpdateComplianceStatus ... but I am not sure I'm going down the right path

[Eswar Koneti]

Hi everyone ...

 

Just wondering if anyone has written a report that will give me a list of all the Servers and the date and time that a patch was last installed on them. As we have been asked to give a list of ALL servers and the last time they have had any patch installed.

 

ie :

 

"Servername" "The Last time a patch was successfully installed"

ABC194823 28/02/1962 12.32 AM

 

etc ...

 

I have tried with a couple of SQL Queries using LastStatusChangeTime from v_UpdateComplianceStatus ... but I am not sure I'm going down the right path

 

try the view "V_add_remove_programs"with column "InstallDate0" with filter display name "security update"

[blindpepper]

Hello Leebro,

 

did you manage to get this report?

I'm looking for the same thing.

Could you please share it with me.

 

thanks