hi - I would like to get a report of users logged in on our AM 8.1 a given day directly from the postgre sql db - I found this liggel sql script which partly runs fine:
Select LOGINUID, SERIAL_NUMBER, LAST_LOGIN_DATE
from AM_TOKEN_OOB, AM_TOKEN, IMS_PRINCIPAL_DATA
where AM_TOKEN_OOB.AM_TOKEN_ID=AM_TOKEN.ID and AM_TOKEN.PRINCIPAL_ID=IMS_PRINCIPAL_DATA.ID and LAST_LOGIN_DATE >'2016-05-07';
but I also need the users real name and email adresses - how should it look to get these also? I cannot find the fields...
IMS_PRINCIPAL table contains FIRST_NAME, LAST_NAME, and EMAIL fields.