yelyah.nodrog Posted May 20 Share Posted May 20 Morning, Is there a way (potentially report?) to determine what Intelligent Captures and BPMS are currently assigned to a active catalog item and service, Or the last time they were run? We have a lot of old items in the system and i would like to do a bit of a cleanout. Hayley. Link to comment Share on other sites More sharing options...
SamS Posted May 20 Share Posted May 20 Hi @yelyah.nodrog, The data is stored in the h_itsm_service_catalog table - you will want to add a few filters as there are duplications for different languages/translations. Link to comment Share on other sites More sharing options...
Bob Dickinson Posted May 20 Share Posted May 20 Hi @yelyah.nodrog I have attached a report I have you can upload that should give you this info. The one thing it doesn't have is the "Active" part - i.e. when you say active services, do you mean you have Services that are set to a state of Draft or Retired that you don't want to be in the report? This shows everything - so you may want to add some additional filtering to it based on what you define as being active. Hope it helps Bob utility---hornbill-service-portfolio-report.report.txt 2 Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted June 21 Author Share Posted June 21 @Bob Dickinson Thanks for this Bob, Sorry I have only just had time to look at it. This gives me everything assigned to a service and catalogue item which is fab. (really helpful actually) Is there a way I can flip it to see everything that isn't assigned to a service and catalogue item? 1 Link to comment Share on other sites More sharing options...
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