Page 1 of 1

How do I tell when a user last signed in?

Posted: Fri Jul 07, 2017 7:37 am
by robberendt
I want to remove inactive accounts. I see no way to see a last signed in date on a user. Logs only go back 30 days or so.

Re: How do I tell when a user last signed in?

Posted: Fri Jul 07, 2017 8:38 am
by Support_Tim
Hi Robberendt,

As you have probably found, the web user login history can be found by clicking Logs > Audit Logs > HTTPS (or other service). You can then enter a user name to easily find the user's history.

The amount of history you have depends on the log settings. Click Logs > Log Settings > Services to view or change these settings for "Days To Keep Audit Log Records".

If you have the "Archive" box checked, and you want to view records older than what you have retained in the database, follow the path specified in this section and you will find the archived records in CSV files, which can be easily viewed and sorted in Excel. I recommend making a copy before.

You can also export the Audit Log Screen and open in Excel.

Re: How do I tell when a user last signed in?

Posted: Tue Jul 11, 2017 2:43 pm
by Support_Rick
Rob,

If you connect to the GAMFT Database and query the Web User table for last login-date, you could retrieve a list (rowset) of Web Users that haven't logged in since "X" date.

Will that help?