ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Is there a query to see which resource classes are in use?
Article ID: 198171
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
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?
Environment
Release : 15.4.1
Component : CA PPM APPLICATION
Resolution
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
)
Feedback
Yes
No
Powered by
