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.
Thanks.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.