Jeremy Posted October 15, 2018 Posted October 15, 2018 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 Posted November 1, 2018 Posted November 1, 2018 @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...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now