1) Identify what Name/Syntax is for the Application Objects you are using in you environment.
select ClassName from config_objects
2) List all Apache application objects with a certain classname not associated to a certificate:
select * from config_objects where GUID not in (select GUID from config_contains where Attribute = 'Certificate') and ClassName = 'Apache'
Oracle Query That should work but does not:
SELECT GUID, ParentDN || '\' || RDN FROM config_objects WHERE GUID IN ( SELECT GUID FROM ( SELECT GUID FROM config_objects WHERE ClassName IN ( SELECT ClassName FROM config_relations WHERE Properties='SuperClass' AND ReferenceName='Application Base' )) WHERE GUID NOT IN (
SELECT GUID FROM config_contains WHERE AttributeName='Certificate' ) )