How to tell how many spaces use Scroll Documents?

[Robin Powell]

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 solution]

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+(%22k15t-scroll-document-versions-for-confluence%3Adocument-family%22)&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

[Kristian Klima]

@David _K15t_ 

Perhaps there could be a screen similar to Scroll Viewport's overview screen that lists all Viewport sites from which you can look up source for individual sites.

Basically, list all Scroll Documents on the Confluence site and indicate spaces they cover.

Ideally, since it's a suite of products, I'd welcome a centralized suite management/overview hub :)

Available to Admins or Viewport Admins.

Scroll Document	Spaces	Variants	Variant labels	Viewports
Low Earth Orbit	LEO	Starter, Moon	starter, moon, all	Universal Imports

(+ versions and translations, of course).