Use this SQL query to find all Hot fixes update within ITMU in the last month.
SELECT Distinct
v_GS_PATCHSTATEEX.ID0 as ‘ ID’,
v_GS_PATCHSTATEEX.Product0 as ‘Product’,
v_GS_PATCHSTATEEX.QNumbers0 as ‘KB #’,
v_GS_PATCHSTATEEX.Title0 as ‘Title’
FROM
v_GS_PATCHSTATEEX v_GS_PATCHSTATEEX
WHERE
datediff(MM,getdate(),v_GS_PATCHSTATEEX.DateRevised0) >= -1
ORDER BY
v_GS_PATCHSTATEEX.ID0,
v_GS_PATCHSTATEEX.Product0,
v_GS_PATCHSTATEEX.QNumbers0,
v_GS_PATCHSTATEEX.Title0