Currently, there is no way to tell when was the latest date/time a user logged in Bamboo, regardless the authentication type (e.g.: Internal Directory, External Directory)
- When authenticating in Bamboo (Internal Directory), there is no database table that holds information on user's latest authentication against the application.
- When authenticating in Bamboo (External Directory, e.g.: JIRA) you can run the following SQL statement against JIRA's database:
However, when authenticating with the same USERNAME in JIRA and re-running the SQL statement above, the same gets updated:
Due to the information above, you cannot tell whether the authentication was from Bamboo or JIRA.
Be able to determine when a particular last authenticate against the application.
Information cannot be retrieved.
In Bamboo, there is a table "AUTH_ATTEMPT_INFO" that stores failure login attempts.
This table could store information related to not only failure login attempts but actual login as well.
LAST_AUTH_TIMESTAMP should store date/time.
Last login date can be pulled from log files, such as <bamboo-install>/logs/catalina.out using a shell command. The command below, tested on Unix machines, allows for multiple catalina.out files in multiple directories, for example in the case of upgrades:
- The command provided will only work on terminals which support GNU tools
- This can be run from any directory accessible by the Bamboo user
- This command may take some time to run, dependent on the size of your catalina.out file(s)
- This suggestion is provided as-is and support will not be available from Atlassian Support