Add-on usage

Issue #75 new
Chris Hofbauer created an issue

We need to determine add-on usage in our instance. We are sure this add-on is in use; however, we are unsure where. Can you please provide the best method to determine where or if it is being used? Thank you!

Comments (6)

  1. Chris Hofbauer reporter

    We need to determine add-on usage in our instance. We are sure this add-on is in use; however, we are unsure where. Can you please provide the best method to determine where or if it is being used? Thank you!

  2. Danut M [StonikByte] repo owner

    Hi Chris,

    Thanks for posting.
    Do you have Jira Server or Jira Cloud? Also, do you have Confluence?

    Danut

  3. Chris Hofbauer reporter

    Hi Danut,

    We are on JIRA Server. And, yes we do have Confluence as well.

    Thank you,

    Chris Hofbauer hofbauercr@praecipio.com praecipio.com

  4. Danut M [StonikByte] repo owner

    On Jira Server you can find this out by running a SQL query like this on the Jira database:

    SELECT portletconfiguration.gadget_xml, portalpage.pagename, portalpage.id, portalpage.username
    FROM portletconfiguration INNER JOIN portalpage
    ON portletconfiguration.portalpage = portalpage.id
    WHERE portletconfiguration.gadget_xml LIKE '%com.stonikbyte.great.gadgets%'

    This returns a list with the gadget identifier (gadget_xml), the name (pagename) and the identifier (id) of the dashboard where the gadget is located, and the user who added the gadget to dashboard (username). 
    See this example.

    We are still searching for a solution on Jira Cloud.

    Danut

  5. Log in to comment