lunes, 25 de abril de 2016

WCP 11gR1: Last Login of Portal Users

Hi.

Recently I was asked about how to retrieve the latest login time of a specific user in WebCenter Portal 11.1.1.8

Basically, the solution was consuming WebCenter Analytics schema which holds analytics about user login.

SELECT DISTINCT ASDIM_USERS.USERID AS "User", ASFACT_WC_LOGINS_0.OCCURRED as "last_login"
FROM ASFACT_WC_LOGINS_0 , ASDIM_USERS
WHERE ASFACT_WC_LOGINS_0.USERID = ASDIM_USERS.ID AND ASDIM_USERS.USERID = 'myuser'
ORDER BY ASFACT_WC_LOGINS_0.OCCURRED DESC

 Obviously, WebCenter Portal has to be configured with WebCenter Analytics Collector for using the above query consuming the ACTIVITIES Schema.

Thanks to Paco Roldán for collaborating on it :).

No hay comentarios:

Publicar un comentario