select "NUMBER",category,action,XREFERENCE,RESOLUTION,CLOSING_COMMENTS from srvman.PROBSUMMARYM1
where assignment = 'TS_BASES_DE_DATOS' and update_time > sysdate - 30
--and update_action like '%MIRANDA%'
and lower(XREFERENCE) like '%oracle%'
and XREFERENCE not like '%Paso manual a work in progress%'
--and xreference = 'Paso manual a work in progress'
order by update_time desc;