Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

last login date for a user

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

https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

but I don't see a table similar to cwd_user

Bamboo has users but it doesn't have the same information.

Thanks.

1 answer

Hi Sebastian,

It doesn't look like this is possible.

On JAC, there's an outstanding feature request - https://jira.atlassian.com/browse/BAM-17728

so it doesn't look like the information is stored in Bamboo anywhere.

I'm actually using Crowd for managing the users..... would it be possible in this case?

Good question - I don't have a Crowd + Bamboo set up atm, but you can get the date of last logins on Crowd:

https://confluence.atlassian.com/crowdkb/list-the-last-login-date-for-all-users-in-crowd-218278872.html

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

when I run this query I get

ERROR: permission denied for relation cwd_user_attribute

I think the user I'm using has admin permissions so not sure what's going on.

the owner of this table is a user called "atlcrowd".

is this a system user or something?

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bamboo

Bamboo Data Center 8.1 is now available

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

204 views 0 4
Read article

Community Events

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

Events near you