How to get list of installed HotFixes from SCCM database.

Use the following SQL query to easily get list of installed Hotfixes.

Query:

select
v_r_s.Resourceid,
v_r_s.Name0,v_r_s.User_Name0,
q_f_e.HotFixID00,q_f_e.InstallDate00,
q_f_e.InstalledOn00,q_f_e.Caption00,
q_f_e.InstalledBy00
from QUICK_FIX_ENGINEERING_DATA q_f_e
join v_R_System v_r_s on v_r_s.ResourceID =q_f_e.MachineID
join v_FullCollectionMembership f_c_m on f_c_m.ResourceID=v_r_s.ResourceID
where HotFixID00 in (‘KB4056888′,’KB4056893′,’KB4056898′,’KB4056895′,’KB4056897′,’KB4056568′,’KB4056894’)
order by v_r_s.Name0 desc