How to connect with Jira Cloud database?

Kishor Ghongade April 6, 2021

How to connect with the Jira Cloud database? we want to fetch some details related to login users details from Jira cloud database etc.

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 6, 2021

If by "connect", you mean "log in and use SQL", you do not.  You have no direct access to it.

You have to get to your data via the application, either using the UI or REST APIs.

Kishor Ghongade April 6, 2021

We wanted to fetch reports kind of data for our Jira cloud site e.g. users logged in in past N days. We wanted to check frequency of users logging-in during weekend or for last one week or for last one month. We need these details so that we can plan our Jira migration task accordingly. Can this be achieved using REST APIs? or is there any other way by which we can fetch this kind of information?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 6, 2021

That level of tracking is not yet available in the REST APIs, but admins can see last logins in the list of users - a manual check, yes, but it's a simple one.

If you're planning a migration though, it's not really a lot of use.  You shouldn't actually be worrying about it.  You should be simply telling all your users "Migration is happening at this time, you will not have access to the old system from that point"

Like # people like this
Spencer Bartz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 12, 2022

When will that level of tracking be available? 

My company's reporting system queries multiple databases including our Jira and GitLab DBs and combines the results. If we can't even have read access to last_login_date in a DB table we're paying Atlassian to host, my company management definitely won't migrate to Jira Cloud.

Like TomA likes this
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 12, 2022

User last logged in is available in the UI already, and in Access if you're using that for accounts.

Spencer Bartz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 12, 2022

Your answer implied there was an intention to add that level of tracking to the REST API. True or false?

As it stands, my company will NOT adopt Jira Cloud because our DBA and Business Analyst cannot access its database. 

If the UI was any substitute for database queries, no one would have asked the original question.

Like # people like this
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 13, 2022

A Jira database has always been the ultimately terrible way to try to do any form of reporting.

Now you've moved to a SaaS version of it, where the database is inaccessible so you can't do bad things with it,  it's a good thing that you have no database access, it forces you to do your reporting properly, including monitoring your user base.

Like Julian Ting likes this
James Seabrook February 3, 2023

@Nic Brough -Adaptavist- can you advise on how to get a report of user group assignment For example:

* permission schemes to which a user group belongs

* roles on each project to which a user group has been assigned

I have set up a load of user groups, roles and projects with user groups as roles and need to be able to see what each user group has access to.

Thanks.

Like # people like this
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 3, 2023

This is not going to tell you a lot.  The access is such a complicated mess, a simple list will be mostly unusable.

Talk to your project admins, ask what they want, and how they would like people to use their projects.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events