I would like to see which resource classes are not assigned to any resources in the environment. What query can I run to determine this?
Release : 15.4.1
Component : CA PPM APPLICATION
The following query should return a list of all Resource Classes that are not associated to any Resources.
SELECT l.*
FROM PAC_FOS_RESOURCE_CLASS l
WHERE NOT EXISTS
(
SELECT NULL
FROM PAC_MNT_RESOURCES r
WHERE r.RESOURCE_CLASS = l.RESOURCE_CLASS
)