Category: PIPER-Rx Reports (Free) Name: FDBA001-10 Patch Details ReportDefFileName: .\FDBA001-10 Patch Details.fr3 ===Begin Comments=== Copyright (C) 2009 G Piper This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. a copy of the GNU Affero General Public Licenses provided is part of the down load Terms and Conditions available on our site www.piper-rx.com or you can refere to www.gnu.org/licenses/gpl.html ===End Comments=== ===Begin SQL=== -- **************************************************** -- ** PIPER-RX - Free Reports -- ** -- ** Copyright (C) 2010 G.Piper -- ** -- ** Patch List for prior X days -- ** -- ** ------------------------------------------------- -- ** Version 1.0 May-10 G.Piper Initial Creation -- **************************************************** SELECT report_headings.report_date, report_headings.sid_name, :DAYS report_days, to_char(sysdate - :DAYS, 'DD-Mon-YY (Dy)')||' and '|| to_char(sysdate, 'DD-Mon-YY (Dy)')report_period, substr(app.patch_name,1, 50) patch_name, app.patch_type, apr.patch_run_id, decode(apr.success_flag, 'Y', 'SUCCESS', 'FAILED') patch_result, apr.failure_comments, '('||decode( apr.server_type_admin_flag, 'Y', 'A', '-')||':'|| decode(apr.server_type_forms_flag, 'Y', 'F', '-')||':'|| decode(apr.server_type_node_flag, 'Y', 'N', '-')||':'|| decode(apr.server_type_web_flag, 'Y', 'W', '-')||')' patch_server_type, to_char(apr.start_date, 'DD-Mon-YY HH24:MI') patch_start_date, to_char(apr.end_date, 'DD-Mon-YY HH24:MI') patch_end_date, round(((apr.end_date - apr.start_date) *24 * 60),0) load_time_minutes FROM ad_patch_runs apr, ad_applied_patches app, ad_patch_drivers apd, ad_appl_tops aat, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE apr.patch_driver_id = apd.patch_driver_id and apd.applied_patch_id = app.applied_patch_id and apr.appl_top_id = aat.appl_top_id and apr.end_date is not null and apr.end_date > trunc(sysdate - :DAYS ) ORDER by apr.patch_run_id desc ===End SQL=== ParamName: DAYS ParamType: Number ParamValue: 7000 ParamExp: ===Begin Report Definition===