hi, how can I find the last login date for users from the bamboo database?
I was trying to use this query as a base
but I don't see a table similar to cwd_user
Bamboo has users but it doesn't have the same information.
Good question - I don't have a Crowd + Bamboo set up atm, but you can get the date of last logins on Crowd:
You can probably filter to check only for members of the groups which have application access to Bamboo, but I don't have the schema in front of me to tell you which tables.
Hope that helps
That would be the SQL user that the DBA/sysadmin created when they set up Crowd, following https://confluence.atlassian.com/crowd/postgresql-4030906.html
If you don't know the credentials for atlcrowd, try checking crowd.cfg.xml file in the home directory, where it should list the credentials for atlcrowd. This assumes you have shell access to the Crowd server.
G’day Bamboo customers, Bamboo DC 8.1 is now available with it the following features and programs: SAML 2.0, OpenID Connect, and Crowd SSO In order to help admins with a simplified user manage...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events