I want to get createtimestamp, krbLastSuccessfulAuth, and krbLastPwdChange for all active users The "ipa user-find" or "ipa user-show" commands only give krbLastPwdChange and failed login count/date The "ipa user-status" command shows "Last successful authentication", but it has to be run for each user I found this suggestion https://www.redhat.com/archives/freeipa-users/2016-May/msg00213.html Could you use ldapsearch? # ldapsearch -Y GSSAPI -b "cn=users,cn=accounts,dc=rhel72" createtimestamp krbLastSuccessfulAuth and tried it adding in krbLastPwdChange, and using a service account as described here https://www.freeipa.org/page/HowTo/LDAP#System_Accounts but it did not return any krbLastSuccessfulAuth values. A bit of tinkering revealed that I have to use the Directory Manager to get back the krbLastSuccessfulAuth. Is it possible to tweak the service account to allow it to read krbLastSuccessfulAuth ? ______________________________________________________________________________________________ Daniel E. White daniel.e.white(a)nasa.gov NICS Linux Engineer NASA Goddard Space Flight Center 8800 Greenbelt Road Building 14, Room E175 Greenbelt, MD 20771 Office: (301) 286-6919 Mobile: (240) 513-5290 _______________________________________________ FreeIPA-users mailing list -- freeipa-users(a)lists.fedorahosted.org To unsubscribe send an email to freeipa-users-leave(a)lists.fedorahosted.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedorahosted.org/archives/list/freeipa-users@lists.fedoraho...

Thanks, Russel, I missed that, but you have to do it in a "for each user" loop. The single ldapquery would be easier.

______________________________________________________________________________________________ Daniel E. White mailto:daniel.e.white@nasa.gov NICS Linux Engineer NASA Goddard Space Flight Center 8800 Greenbelt Road Building 14, Room E175 Greenbelt, MD 20771 Office: (301) 286-6919 Mobile: (240) 513-5290 From: Russell Long <kd8fre(a)gmail.com&gt; Date: Friday, July 10, 2020 at 09:58 To: FreeIPA-Users <freeipa-users(a)lists.fedorahosted.org&gt; Cc: Daniel White <daniel.e.white(a)nasa.gov&gt; Subject: [EXTERNAL] Re: [Freeipa-users] It ain't easy to dig a user's last login time info out of IdM/FreeIPA I use this: ipa user-show $USER --all --raw | grep krbLastSuccessful | awk '{print $2}' _______________________________________________ FreeIPA-users mailing list -- freeipa-users(a)lists.fedorahosted.org To unsubscribe send an email to freeipa-users-leave(a)lists.fedorahosted.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedorahosted.org/archives/list/freeipa-users@lists.fedoraho...