Category: PIPER-Rx Reports (Free) Name: FAA002-11 Aged Application Accounts ReportDefFileName: .\FAA002-11 Aged Application Accounts.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) 2009 G.Piper -- ** -- ** Simple Aged Application Accounts Report -- ** Accounts not used or not used in past 120 days -- ** -- ** -- ** ------------------------------------------------- -- ** Version 1.0 May-09 G.Piper Initial Creation -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- **************************************************** SELECT report_headings.report_date, report_headings.sid_name, fu.user_id, substr(fu.user_name, 1, 30) user_name, substr(fu.description, 1, 30) description, fu.email_address, nvl(to_char(fu.last_logon_date, 'DD-Mon-YY HH24:MI'), 'Never Used') last_logon_date, trunc((sysdate - fu.last_logon_date)) days_since_last_connect FROM applsys.fnd_user fu, ( 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 (fu.last_logon_date IS NULL OR (SYSDATE - fu.last_logon_date) >= 120 ) and (fu.end_date IS NULL OR fu.end_date > SYSDATE ) ORDER by fu.user_name ===End SQL=== ===Begin Report Definition===