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.
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)
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?
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.
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:
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 ;-)
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!
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