1 Reply Latest reply: Mar 28, 2013 2:25 PM by Ramin Hashimzadeh RSS

    DBA_AUDIT_SESSION Report

    eshyam
      I have to create a SQL report and publish it about when the users logged in and when logged off

      I need only below info from DBA_AUDIT_SESSION (even though there is lot of other other information in the view)

      Username Timestamp Action OS_PROCESS
      ABC 3/28/2013 03:00:21 PM LOGIN 1100
      ABC 3/28/2013 03:10:21 PM LOGOFF 1100
      XYZ 3/28/2013 03:20:21 PM LOGIN 1200
      XYZ 3/28/2013 03:25:21 PM LOGOFF 1200


      Need report in the following formation

      USERNAME LOGIN LOGOFF OS_PROCES
      ABC 3/28/2013 03:00:21 PM 3/28/2013 03:10:21 PM 1100
      XYZ 3/28/2013 03:20:21 PM 3/28/2013 03:25:21 PM 1200

      Any help in this regard is appreciated


      Thanks