Finding out what Intelligent Caps and BPMS are in use

[yelyah.nodrog]

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.

[SamS]

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.

[Bob Dickinson]

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

[yelyah.nodrog]

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

[Guest Paul Alexander]

Hi all

Just hijacking this as I need the same thing as @yelyah.nodrog

Is there a way to show which BPMs and ICs AREN'T assigned to a CI please?

 

thanks

[Met]

@Paul Alexander

Try this in database direct (remember to alter the default number of returned rows from 25 if you have a lot)

For active BPMs which are not associated to a catalog item, this should return the name of the active unused BPM.

SELECT 
  bpm.h_title, 
  bpm.h_name 
FROM 
  h_bpm_processes bpm 
  LEFT JOIN h_itsm_service_catalog services ON services.h_bpm = bpm.h_name 
where 
  services.h_bpm is null 
  and bpm.h_active 
GROUP BY 
  bpm.h_name

Then in a similar way for IC:

SELECT 
  bpm.h_name 
FROM 
  h_bpm_procapture bpm 
  LEFT JOIN h_itsm_service_catalog services on bpm.h_id = services.h_pro_capture 
WHERE 
  services.h_pro_capture is null 
  and bpm.h_status

Let me know if this isn't what you're looking for.

Met

[Met]

17 hours ago, Met said:

@Paul Alexander

Try this in database direct (remember to alter the default number of returned rows from 25 if you have a lot)

For active BPMs which are not associated to a catalog item, this should return the name of the active unused BPM.

SELECT 
  bpm.h_title, 
  bpm.h_name 
FROM 
  h_bpm_processes bpm 
  LEFT JOIN h_itsm_service_catalog services ON services.h_bpm = bpm.h_name 
where 
  services.h_bpm is null 
  and bpm.h_active 
GROUP BY 
  bpm.h_name

Then in a similar way for IC:

SELECT 
  bpm.h_name 
FROM 
  h_bpm_procapture bpm 
  LEFT JOIN h_itsm_service_catalog services on bpm.h_id = services.h_pro_capture 
WHERE 
  services.h_pro_capture is null 
  and bpm.h_status

Let me know if this isn't what you're looking for.

Met

Just realised auto-tasks are stored in the same table, so think the first SQL statement should be:

SELECT 
  bpm.h_title, 
  bpm.h_name 
FROM 
  h_bpm_processes bpm 
  LEFT JOIN h_itsm_service_catalog services ON services.h_bpm = bpm.h_name 
where 
  services.h_bpm is null 
  and bpm.h_active
  and bpm.h_type = 0
GROUP BY 
  bpm.h_name

[EWA]

What is the best practice to manage retired workflows? Is it safe to delete them?

And any of the reports doesn't give me an idea of when last time a request was used/ or how many times... Is there a shortcut to get this data?