2 Replies Latest reply on Feb 21, 2007 9:08 AM by 563065

    login details

    562737
      Hi All

      I need query to find out list of users log into the production system at a given point of time and also for a period of time.

      ex. users logged in at 10.45am today
      2. 9.00 - 10.00am on 19th Feb 2007

      Thanks for your assistance

      Anna
        • 1. Re: login details
          512041
          try this....

          change start_time and use end_time for your time gap.
          SELECT DISTINCT ppf.full_name
          , fu.user_name
          , NVL(ppf.email_address,fu.email_address) email_address
          FROM per_people_f ppf
          , fnd_user fu
          , fnd_logins fl
          WHERE fl.start_time > SYSDATE - 2
          AND fu.user_id = fl.user_id
          AND ppf.person_id(+) = fu.employee_id
          AND fu.user_name NOT IN ('SYSADMIN', 'GUEST')
          Regards
          Prashant Pathak
          • 2. Re: login details
            563065
            Hi Prashant Pathak

            Thanks for your prompt reply.

            Could you please kindly modify the query for me to get the users currently (at the time of running the script) log -into the system

            Thanks

            Regards

            Anna