How to compare aem author env pages and AEM Publish Env page

Forum|Forum|3 years ago
January 5, 2023
3 replies
2345 views

Hi Team,

Please help fory below query.

How to compare aem author env pages and AEM Publish Env page like ''content/mysite/ under pages

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by user1576

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-blogs/how-to-find-or-count-all-pages-in-aem-project-aem-community-blog/ba-p/388479

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-results-count-using-query-builder-aem-community-blog-seeding/m-p/388786

Ritesh_Mittal

Community Advisor and Adobe Champion

Hi @sanjay91 ,

Do you mean visual comparison of HTML pages on author against publish?

Thanks,

Ritesh Mittal

S

sanjay91Author

Level 2

I want compare number of pages in author and publisher

H

Harishv31

Level 3

Hi ,

You can write sql query to find the number of pages in both environment.

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

And also try custom reports for your requirement.

https://aem.redquark.org/2019/06/create-custom-reports-in-aem-component.html

Thanks

S

sanjay91Author

Level 2

Hi Haris,

I am writing same code

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

But I can get all author page count but i did not count publish page and also when I was putting hole url in query got error message so how to connect url https and port number in query.

H

Harishv31

Level 3

Could you please share the example of code how to get data from publisher url like https://4503/content/path

Please try this sample code

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.Base64;


public class HttpBasicAuth {

    public static void main(String[] args) {

        try {
            URL url = new URL ("json url");
            String encoding = Base64.getEncoder().encodeToString(("test1:test1").getBytes(‌"UTF‌-8"));

            HttpURLConnection connection = (HttpURLConnection) url.openConnection();
            connection.setRequestMethod("POST");
            connection.setDoOutput(true);
            connection.setRequestProperty  ("Authorization", "Basic " + encoding);
            InputStream content = (InputStream)connection.getInputStream();
            BufferedReader in   = 
                new BufferedReader (new InputStreamReader (content));
            String line;
            while ((line = in.readLine()) != null) {
                System.out.println(line);
            }
        } catch(Exception e) {
            e.printStackTrace();
        }

    }

}