Jump to content

Closure categories that are not in use


Jeremy
 Share

Recommended Posts

Hi

I am trying to find out which closure categories have not been used so that we can remove some of the older ones that we are not logging requests against.

What is the best way of achieving this? I would guess a report but am not sure where to begin, I created a view to show me the ones in use but as there are so many it's difficult to work it out.

Link to comment
Share on other sites

  • Victor changed the title to Closure categories that are not in use

@Jeremy 

Closure categories/profiles configuration is stored in h_sys_profiles table. You need to look for all records where h_pid = 2. This is the SQL query used to retrieve all these:

SELECT ... FROM h_sys_profiles WHERE h_pid = 2

To retrieve a list of unused categories you would need a report that JOINs this table with h_itsm_requests table and to return records from profiles table that do not match a record in requests table...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...