Is it possible to migrate data from JIRA server which has not renewed maintenance and support?

[Kotresha B]

Is it possible to migrate data from JIRA server which has not renewed maintenance and support?

[Mikael Sandberg · Accepted solution]

Yes, you should still be able to export data from the server. You can use a full backup to extract everything from the system and restore it on another server, or you can export issues to csv. For the full system backup, have a look at Backing up data and Moving or archiving individual projects. 

[Kotresha B]

Hi @mik  So to export and import few of the projects do we need to use 3rd part app Project Configurator for Jira which is recommended ?

[Kotresha B]

But I dont see option to export in JIRA server 7.12!

[Mikael Sandberg]

It all depends on what you want to export. Are you exporting the whole project including project configurations? Or are you looking at only exporting the issues in a project? 

You can use an app to do it like Project Configurator, or you can use the built-in system export, restore it on a test server, delete the projects you do not want to migrate, do another system backup with the projects you want, and then restore that backup. In order to do the system backup you need Jira admin permissions and then go to Administration > System > Import & Export > Backup System.

[Kotresha B]

Hi, I want to export few of the projects with all data which includes configurations, permissions , fields , screens settings in short everything related to respective projects so which is the best method ?

[Mikael Sandberg]

Okay, so in that case you are looking at either doing the steps I described using the system backup or using an app. It all comes down to if you want to spend the money on an app or spend your own time by setting up a test server and do the clean up there. I have done migrations in the past, but it has been mainly full migrations and not just specific projects. The only exception was when I migrated a Jira Cloud project back into our server environment.

[Kotresha B]

@Mikael Sandberg  How to remove inactive and never logged in users in JIRA server ?

I dont see that option!

[Mikael Sandberg]

You can only remove users that have been created in the internal user directory. If you are using an external directory you can only deactivate a user.

[Kotresha B]

Ya either way, I want to deactivate or remove both works for me but I’m not getting that option in Jira either to deactivate/remove!

[Mikael Sandberg]

If you are using an external user directory you have to deactivate the user in Active Directory/LDAP and this will then be synced in Jira. The only thing you can do in Jira is to remove them from your application group so the user cannot log in to Jira.

[Kotresha B]

I tried to remove them in application group but it’s giving me error saying cannot remove users from group because you have read only access from directory!

[Mikael Sandberg]

Okay, so when you use the read-only external user directory you have to make the change in that directory, you cannot make any changes to your users in Jira. 

[Kotresha B]

@Mikael Sandberg  Is there any way to hide/restrict projects in JIRA server 7.12?

[Kotresha B]

@Mikael Sandberg  Is it possible to take JIRA server 7.12 data as SQL back up and store? 

[Mikael Sandberg]

Yes, but keep in mind that attachments are not stored in the database, so you would have to get those from the file system on the server.

[Kotresha B]

@Mikael Sandberg Thank you so do you have any link with procedure mentioned how to take SQL back up for JIRA 7.12?

[Mikael Sandberg]

@Kotresha B I don't, Atlassian do not provide it but instead rely on that you follow the vendor's recommendation to do backups.

[Kotresha B]

@Mikael Sandberg So now we are selling one part of our organization so we going to handover our JIRA server instance 7.12 to them before handover we need to change to there new URL, so is it easy to do?

[Mikael Sandberg]

@Kotresha B on server the URL is not fixed or associated with your projects, it is determined by the Base URL that you set. All you have to do is have the new organization change the base URL when they import the backup. You can find the information here on how to change the base URL.

[Kotresha B]

@Mikael Sandberg And to do this should I log in to server locally and make cahnges?

[Kotresha B]

@Mikael Sandberg And I tried to take xml backup in JIRA server 7.12 in web browser , when I given file name and clicked submit, its keeps on rotating and i dint get any response/error/completed!

So take take XML back up should I log in to server locally ? 

[Mikael Sandberg]

@Kotresha B the change can be made either before after, that is up to you.

The XML backup takes some time, it all depends on your instance. And don't be afraid if you get a time out error. The backup still happens, you just have to monitor the file increase on the server side in that case, and the increase of the file size increases, that is when the backup is done.

[Kotresha B]

@Mikael Sandberg  Thank you and how to take attachments back up? XML will not include attachments in the back up so.

[Mikael Sandberg]

@Kotresha B the easiest way of backing up the attachments is to just zip up the data folder. Take a look at the backup section in the documentation, Migrating Jira applications to another server.

[Kotresha B]

@Mikael Sandberg Is there any way to get active/inactive users list who worked on any projects in JIRA server 7.12?

[Mikael Sandberg]

You can use the REST API to get the list of active/inactive users, see GET /rest/api/2/user/search. It will not tell you if the user worked on a project or not, if you are looking for users that are assigned or was assigned to an issue you can get that too by running a JQL and then parse out the assignee. 

[Kotresha B]

@Mikael Sandberg How to run JQL query ?

[Kotresha B]

@Mikael Sandberg @And what’s the JQL query?

[Mikael Sandberg]

@Kotresha B it depends on what you want to get out of the JQL. For example, to get all issues where the assignee is set you can use assignee is not EMPTY. And you can either create a filter and access it from the REST API or run the query directly using the REST API. As mentioned above, it all depends on what you are looking for. I would start with the list of active/inactive users and go from there.

[Kotresha B]

@Mikael Sandberg 

Thank you finally I listed some users to retain.

So now i need to delete some of the users in JIRA server 7.12, so is there anyway to select all and delete?

[Kotresha B]

@Mikael Sandberg Is there any way to export few of the projects (only selected not all ) in JIRA cloud standard platform? OR any add -on?

[Mikael Sandberg]

@Kotresha B yes, but with restrictions unless you use an app or using the XML backup. If you do not want to use the XML backup to do it you will not be able to get any of the project configuration in the export. 

[Kotresha B]

Hi @Mikael Sandberg  Is there any feature or tools in JIRA to get statistics and reports of administrative activities like users activities, what are all products enabled, add on's etc.

I am an JIRA admin and I want this reporting tool or feature for my administrative tasks to show or record and present to management.

[Mikael Sandberg]

Hi @Kotresha B,

This question should probably be moved to a new question, but there are several apps in the marketplace that can to with for you. I know Power dashboards reports & gadgets and if I remember correctly Scriptrunner also have reports that you can run. 

[Kotresha B]

@Mikael Sandberg Hay I want to get reports on administrative activities like users activities, billing , products enabled etc. so is there a way to get these data from any tool within JIRA or add-on?