Kristin Lyons Expert

Post about your favorite app or integration. Include the following: * How did you find the app? * What did you use it for? * Which team used it? * What would happen if you didn’t have it? My favorite app currently is Configuration Manager. A bit of a background - I'm an Atlassian Administrator that contracts out to various…

I have this automation set up to open all on hold issues each weekend. A bit of a back story, each day I have a filter sent to me to display all my open issues (open or in progress) that are due during this sprint. If an issue is resolved or on hold it won't be sent in the filter. Each weekend I have all on hold issues…

We are in the process of merging two Jira instances together. The instances have different user bases. We would like to find a database query that will list all of the active users who have data associated with their account (issues assigned to them, issues they created, issues they are the reporter on, issues they…

We are merging 2 Jira instances, one is already on cloud and the other is on server. The server instance is by Company B and uses Company B's email domain. Company A has it's own email domain. All users in Company B have both a Company B and a Company A email domain, but all their Jira data is linked to Company B's email…

How to Validate An Attachment is Excel Tested and Documented in Jira Cloud What is the Business Need? Jira allows for any type of attachment to be added to an issue. If you have an issue type that requires an attachment and the attachment needs to be an Excel file, you will want to use this validator. One use case is if…

We have a JSD project where customers can create their own accounts, but after a certain period of time we need to delete the customer account. What is the best way to automate this?

Is it possible to migrate Portfolio plans and teams from one server Jira instance to another? We are in the process of combining two Jira instances together.

Is there a way to disable the Start a New Team feature in Jira Cloud? We do not want users to invite other users to our Jira instance.

We have migrated Confluence spaces from one instance to another but the attachments did not migrate (they were in the database, I have since pulled out the attachments from the database). Is there a tool of any sort to help me easily find the attachments for the spaces? I have these sites bookmarked:…

We have a Confluence instance running the embedded H2 database but need to reset the admin password. I am following these steps: https://confluence.atlassian.com/conf510/restore-passwords-to-recover-admin-user-rights-829077919.html but cwd_users is not a valid table. 

Is it possible to migrate from Confluence using the built in database to Cloud using the Migration Assistant or will we need to migrate onto an external database first?

Is there a plugin that will allow us to markup attachments on Jira issues without having to download and re-upload the attachment? We would prefer something like this in Jira but Confluence would also work.

We have Portfolio installed in Jira Cloud and have created a custom hierarchy. We are now looking to have a roll up of completion % (using story points) of the top level and be able to drill down. Once we have that information we want to create some easy to read diagrams of the overall completion %. The closest I can come…

We are having a problem with Azure only syncing some groups to Atlassian Access but not all the groups are syncing. So we can see all the groups in Atlassian Access but then they're not visible in Jira Cloud. Meaning that their permissions are not being configured. We are having problems troubleshooting this.

I have Confluence 6.15.2 installed on a server with Postgres. I have a backup of a Confluence Cloud instance that I am trying to restore into the server instance. During the restore (less than five minutes in) I get an error message: Then if I try to do anything in Confluence I am just brought to an error screen: In the…

We migrated Jira to a new database and manually moved the priorities, attachments and avatars folders. All the images show up except for the priorities. How can I resolve this problem?

Does Jira support SP1 or SP2 for Microsoft SQL 2016 installation?

Getting this error when trying to create a Confluence Status Report page "Status report is not available for your version of JIRA. Upgrade to JIRA 6.1.1 or later to use this report." We are currently using Cloud JIRA & Cloud Confluence. What we are trying to do is get a weekly Sprint Report imported in Confluence…

Is there a way to anonymize input in a custom field in JIRA after a ticket is closed? I am looking to have a field where a name is entered after the ticket is closed I want that name to be anonymized. This would be in the cloud instance of JIRA.

I found this article: https://web.archive.org/web/20130501165708/http://wiki.customware.net/repository/display/ATLASSIAN/How+to+delete+filters+and+subscriptions+added+by+other+users which allows me to delete individual filters in the database, is there another way to go about this? Or a way to automatically delete filters…

I am looking to hide the comment field altoghether (not limit who can use it) on transition screens in the Cloud instance of JIRA. I have tried utilizing various codes in the "Message Custom Field (for edit)" but none of them seem to work. (Referencing these:…