How to get a list of all catalog items that does not have an SLA attached to it

[Thereza Van der]

Morning all 🙂

Please tell me what is the easiest way to get a list of all catalog items that does not have an SLA attached to it? I think it might be the sc_cat_item table, but I don't see a field like 'SLA' or something to 'show matching'.

Regards

Thereza

[Robbie]

Hi @Thereza Van der,

The easiest way to determine this would be to check the list of 'SLA definitions' and to see if any have been applied to the 'sc_req_item' table.

(As a guideline, SLA's are not defined out of the box for Request Items. Additionally, SLA's where possible are written generically to capture groups of SLA's by the service/category for example rather than individual items)

From the list of SLA Definitions, you'd need to check more granular detail and configuration as to whether an SLA (or SLA's) has been defined against a particular item or category which would capture multiple items.

Type 'SLA definitions' into the Navigation menu and select the option under 'SLA'.

Within the list, filter where table = sc_req_item.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Thereza Van der]

Thanks Robbie, I tried that. the sc_cat_item table has 543 entries. If I filter on SLA definitions I get 113 entries where table name is sc_cat_item.

What I want to figure out is how to see which catalog items DOES NOT have an SLA attached to it.

Any ideas?

[AndersBGS]

Hi @Thereza Van der ,

You could create a report based on the sc_req_item table with related list condition as below:

Please also ensure to create a report that have the aggregation possibility:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

 Anders