Identify which Catalog Items have Integration or Automation Involved

[Janelle Solsona]

Hi,

1. Is there a way to easily identify catalog items that involve integration or automation?

2. What are the potential methods for displaying when a catalog item includes integration or automation within the catalog item record (sc_cat_item), along with brief details about the integration or automation?

Thank you so much in advance!

[Vrushali Kolte]

Hello @Janelle Solsona ,

I am not sure about the integration but one way to identify if a catalog item has automation or not is to check the workflow & flow fields at catalog item.

If you want to find out the details through scripting, you would write a script similar to the one below:

var gr = new GlideRecord('sc_cat_item');
gr.addEncodedQuery('workflowISNOTEMPTY^ORflow_designer_flowISNOTEMPTY');
gr.query();
//gs.info(gr.getRowCount());
while(gr.next()){
 if(gr.workflow){
   gs.info(gr.workflow.name);
 } else {
   gs.info(gr.flow_designer_flow.name);
 }
}

If my answer helps you, please mark it as Accepted✔️ & Helpful👍!

[Amit Verma]

Hi @Janelle Solsona 

1. Assuming the Request Fulfillment Automation Level is defined, you can filter out for Semi-Automated and Fully Automated automation levels as shown below :

OR

You can query for items mapped to a flow or a workflow :

2. To report these catalog items, you can make use of the Export functionality and export it in a CSV or an excel or a PDF by right clicking on column header and selecting Export as shown below :

Thanks and Regards

Amit Verma