Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,312
Community Members
 
Community Events
165
Community Groups

Usage of Addon/App

Hi there,

I am looking to find out if there is a way to query what spaces is using a specific Add-on/App in Confluence.

Eg.: I want to a list of spaces that is using the App: "Forms for Confluence".

I know the query to run for each macro. I don't want to know by each macro. Rather I would like to know the usage of Add-on/App as a whole.

Any help on this is greatly appreciated.

Thanks!

1 answer

1 accepted

0 votes
Answer accepted

There is no way to do this.  You need to analyze every possible way an App might be used and then look for each usage.  As they could be very different, you could be looking for all sorts of things to confirm usage (and a lot of Apps work outside spaces, so your question does not work for them either)

Hi Nic,

Confluence' migration assistent is showing a statistic about the usage of each installed app per page and per user.

Hence there must be a way for the assistent to create that statistic which should be capable for a database query either way.

 

What do you think?

 

Best regards,

Ulrich

The usage per page is when a page uses a macro provided by an app.  That's actually available as a report in the UI, as well as the migration assistant.

Usage per user is partly done by analytics, which is stored in the database, but is absolutely not complete, as it doesn't track all the ways apps can be used.

Hi Nic,

is there a way to create a query similar to that which ist used by the migration assistent?

You say the information sits in the database so there should be a way to get it out there ;o)

 

Thanks

Ulrich

In SQL, you could get most of it, but not all.  Some of the analytics and other data you see is being calculated by the apps, or drawn from the index, not the database.

So if you do do it with SQL, you're going to be doing it the hard way:

  • There's some data you'll need really ugly queries for (macros means searching and parsing all the content, plus working out what content is currently active)
  • There's a lot of data you'll have to calculate from the raw data
  • There's a lot of data you'll have to work out how to extract by looking at what each app does and identifying how it works so you can dig the data out

Thanks for the elaborate explanation, Nic!

I was afraid you were saying that but even more I'm surprised that the migration assistent is able to compile the information in no time after clicking on "Assess and install apps".

 

Your cross-link towards raw data prevents me from trying it on my own. I did that once and went almost crazy ;-)

 

Cheers,

Ulrich

It's able to work fast because it's reading a lot from the index, not the database, and the other calculations on top of that aren't too complex to execute!  The index actually contains a lot more useful data, because it's effectively part-calculated for us automatically.  But it's even harder to read the index!

Got it!

Thanks again for your effort!!

 

Bye,

Ulrich

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

427 views 2 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you