create report from shell

[ThomasIwang]

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

[_EricaChalfin]

Thomas Iwang‌,

I have  moved your question to the RSA SecurID Suite" data-type="space‌ space so you can get information about your SQL query.

Regards,

Erica

[TedBarbour]

Hi Thomas - are the users coming from an external Identity Source?  If so, those items are only stored in the IS and not duplicated in the AM database.

Ted

[ThomasIwang]

Hi ted

No they are local users in the rsa user db

Br ti

[TedBarbour · Accepted solution]

IMS_PRINCIPAL table contains FIRST_NAME, LAST_NAME, and EMAIL fields.