AnsweredAssumed Answered

create report from shell

Question asked by Thomas Iwang on Sep 13, 2017
Latest reply on Sep 13, 2017 by Ted Barbour

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...

Outcomes