2 Replies Latest reply: Feb 14, 2013 5:36 AM by 778476 RSS

    Portal User metrics

    778476
      We've been asked to provide a list of users who haven't user our Portal pages for 6 months or more. I've had a look through a number of tables but can't find any relevant info. Can anyone say where I could find this info?

      We are user version 10.1.2.3.0

      Thanking you in advance.
        • 1. Re: Portal User metrics
          oportalist
          Oracle Portal user activity can be reported on using PORTAL.WWLOG_ACTIVITY_LOGS but what is actually being logged and the length of time that data is available (it gets purged) depends on what was setup/configured for your portal. For just the data on user logins using SSO, you could report on that using ORASSO.WWSSO_AUDIT_LOG_VIEW. (From what I can tell from our portal instance, that data does not get purged.)
          • 2. Re: Portal User metrics
            778476
            Apologies for not getting back to you oportalist, your advice was spot on and we got the info required. Thanks, and apologies again.