What hot fixes have been updated in the last month?

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *