Jump to content

Recommended Posts

Posted

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.

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

@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...

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
×
×
  • Create New...