Need help in retrieving the Organization Info

[Aayush Vishnoi]

Hey, I want to retrieve the common name from this output:
https://crt.sh/?O=Dell&showSQL=Y&exclude=expired 


How can I use psql, anyone can help ?

[r...@sectigo.com]

Hi Aayush.  Since you've already got "showSQL=Y" in the URL, you can scroll to the bottom of the page to find the SQL query that produced the result set.

For details of how to connect to the crt.sh DB using psql, see this post:
https://groups.google.com/g/crtsh/c/sUmV0mBz8bQ/m/K-6Vymd_AAAJ