AEM Reporting - Page Reports

Avatar

Avatar

nsvsrk

Avatar

nsvsrk

nsvsrk

11-01-2016

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jitendra_S_Toma

Avatar

Jitendra_S_Toma

Jitendra_S_Toma

12-01-2016

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.smiley

Jitendra

Answers (3)

Answers (3)

Avatar

Avatar

nsvsrk

Avatar

nsvsrk

nsvsrk

12-01-2016

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.

Avatar

Avatar

kunal23

MVP

Avatar

kunal23

MVP

kunal23
MVP

11-01-2016

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

Avatar

Avatar

Jitendra_S_Toma

Avatar

Jitendra_S_Toma

Jitendra_S_Toma

11-01-2016

@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