How to tell how many spaces use Scroll Documents?

Question

We are working with Confluence Data Center 9.2.3. I would like to come up with a list of spaces that are using the Scroll Documents add-on. I have access to the database (Postgres) and have figured out how many spaces are using each of the macros that come with the add-on, but what I would like is a list of Spaces that have created Scroll Documents in general. Does anyone here have some SQL that might get me close? We have over 2,200 active spaces and I'd rather not go through them one-by-one. Thanks :)

David (K15t) · Accepted Answer

Hi Robin,

This is David from K15t, the team behind Scroll Documents.

We don’t have a built-in report that lists all spaces using Scroll Documents, mainly because a single document can technically span multiple spaces. However, the best indicator is to search for the custom content objects that are created for each document. These have the type:

scroll-document-versions-for-confluence:document-family.

For example, you can run a CQL search like this to find all of those objects.

http://localhost:8092/dosearchsite.action?cql=type+in+("k15t-scroll-document-versions-for-confluence:document-family")&startIndex=0

If you have direct access to the database, you could probably also search for spaces that contain at least one of these objects. That should give you a fairly accurate approximation of how many spaces contain documents.

Hope that helps.

Cheers,

David