How to find application objects that are not associated to any certificate objects

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

Was this article helpful?
0 out of 1 found this helpful