We have OAM 11g installed on several systems (RHEL5, WLS 11g, OAM 11g, Oracle DB 11.2.0.3) but need to figure out how we can query the OAM DB tables to retrieve user login/authentication metrics?
We need to track the number of logins and the number of unique logins over a period of time. We use both PKI and username/password authentication therefore although username/password can be tracked by our login screen, the PKI is authenticated through an Identity Store and does not log the successful login.
We have found that the <prefix>_IAU tables are supposed to handle this information (Note: 1492681.1). We followed this Note -- as part of the OAM 11g install the IAU tables are created, we created the AuditDS data source, attached the data source to our AdminServer and oam_server1, and set the Domain audit store and policy.... but even though the audit information is going into the audit.log it does not get transferred to IAU tables.
Is there something missing?
Thanks in advance....