Query to Retrieve Bundle and maintenance pack

Hi Guyz...just thought to share this ,hope it helps you all to check the bundle or maintenance pack applied.

Query to retrieve Bundle

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like Upper('%BUNDLE%') ORDER BY 2 DESC

Query to retrieve maintenance pack :

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like Upper('%Maintenance Pack%')  ORDER BY 2 DESC

Data will come in Descending order of date when last bundle applied.