AEM Reporting - Page Reports

[#1]

Hi,

I have a requirement to create a report of all pages published.by AEM.

I noted that there is an OOB report "Page Activity Report", under Tools --> Reports.

Its column "Type" lists the type of activity for that page and "Page modified", "New version created" are the only values I see, when I run this report.

If there is an activity value "Published", I could filter the list by this activity and achieve my goal.

Some of these pages were published, but still this is the behavior.

Please suggest how I could get the list of published pages, as much as possible, as an OOB feature.

Appreciate your responses.

Thanks,

Rama.

[#2 · Accepted solution]

Well,

Published status of the page does appear on many consoles and adding in this report isn't that big deal. However, it is something never came up and probably never asked for. All I can say, Raise a day care ticket to get this fix.

We suggest AEM to clients, saying that it has so much of OOB functionality, and so we could avoid customization efforts!

On a lighter note: This is the sales team line. We as a developer should not suggest so.

Jitendra

[#3]

Hi,

AEM is a WCM solution and page publishing is its heart.

In this context, when we are talking about a page activity report, published status not being present in it is a big news!

Probably, Adobe should suggest a solution to this problem and make it a feature request in its upcoming releases.

What is the use of offering an out of box functionality, that is unusable?

We suggest AEM to clients, saying that it has so much of OOB functionality, and so we could avoid customization efforts!

Thanks,

Rama.

[#4]

You can fire the following SQL2 query to get the list of all active pages in AEM. 

select * from [cq:PageContent] AS s where s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])

[#5]

@Rama,

There isn't a way to add another column in existing Grid columns & populate data accordingly. Though, There is a configuration (com.day.cq.reporting.impl.ConfigServiceImpl) for this functionality, But it is only for those fields which are already there.

So, All I can say, you might have to extend it or create your own reporting UI.

---

Jitendra