Is there a query to see which resource classes are in use?

book

Article ID: 198171

calendar_today

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
)