How do you write a power script to show metadata about all the pages in a space?

[Michael Zhao]

Looking for help with writing a macro to audit the pages within a space in a Confluence instance, showing the following fields: 

• Page name
• Link to page
• Last updated/modified date
• Original Poster (creator) 

Previous implementation was deployed on a created page within the space being audited, and showed a table of all the pages within the space. 

[Dave Liao · Accepted solution]

@Michael Zhao - hi Michael!

Are you actually looking for a Power Scripts for Confluence script?*

If no, or  it's not imperative that we use PS, consider a custom user macro:

1. See this example: https://community.atlassian.com/t5/Confluence-questions/Macro-that-lists-all-pages-for-the-specified-space-with-their/qaq-p/1452170
2. ...and consider THIS example if you want to extend the first example: https://community.atlassian.com/t5/Confluence-articles/A-Child-Page-by-Label-User-Macro/ba-p/1502246

* today I learned that PS for Confluence is a thing! Awesome.

[Michael Zhao]

Definitely looks like it matches what I'm looking for. Talked to a former colleague who mentioned the previous iteration was built with Power Scripts, but more looking for a starting point to build it out in a different organizational context, so not a requirement.

Thanks again!

[Dave Liao]

@Michael Zhao - FYI if you have an existing PS script, you may be able to extend it using these variables: https://appfire.atlassian.net/wiki/spaces/PSCONF/pages/15306098/Standard+Variables

[Roma Bubyakin]

Hi @Dave Liao 

In case you are using Cloud

It might also be worth to take a look into our (Wombats Corp) app User Macro for Confluence Cloud

You can create numerous dynamic macros from the admin panel.

For your exact use case template would be the following:

{{#set name="spaceId"}}

  {{space.id}}

{{/set}}

<table class="aui aui-table-list aui-table-sortable">

    <thead>

        <tr>

            <th id="column-name">Page Name</th>

            <th id="column-link">Link to Page</th>

            <th id="column-updated">Last Last Update</th>

            <th id="column-creator">Original Poster</th>

        </tr>

    </thead>

    <tbody>

    {{#getPagesInSpace id=spaceId limit=250}}

        {{#each results}}

        {{#set name="url"}}https://wombats.atlassian.net/wiki{{_links.tinyui}}{{/set}}

        <tr>

            <td>{{title}}</td>

            <td><a href="{{url}}">{{url}}</a></td>

            <td>{{version.createdAt}}</td>

            <td>{{#getUser accountId=authorId}}

                {{publicName}}

            {{/getUser}}</td>

        </tr>

        {{/each}}

    {{/getPagesInSpace}}

    </tbody>

</table>

The result would be like this:

Regards, Roman