SCCM reporting for KB ID

Can SCCM generate patch status report based on the required  kb ID for machines that are Not patched/Patched?
sadiojr1Asked:
Who is Participating?
 
joyofsharingCommented:
0
 
merowingerCommented:
Patch installed
select * from SMS_R_System
where SMS_R_System.ResourceId in
(select ResourceID from SMS_R_System 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 "KB976073")

Patch not installed
select * from SMS_R_System
where SMS_R_System.ResourceId not in
(select ResourceID from SMS_R_System 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 "KB976073")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.