Extract report based on a list of keywords present in short description /description from task table

[Adithya S Uday1]

We have a list of server names and need to generate a report from the task table that lists all tasks related to these servers. Specifically, we want to identify tasks where the server name appears in either the short description or description fields. Is this feasible?

[Dr Atul G- LNG]

Hi @Adithya S Uday1 

Feasible? Yes.
Will it give accurate results? No — because you need to search using the "contains" operator, and if the word or string matches as part of any other combination, ServiceNow will still include it in the results.

Example:

I want to search for the word "AM" in the Short Description field.

Short Description: I Atul and this is the example.

Results:

As you can see in the example, "AM" appears within the word example, so ServiceNow will include this record in the search results — even though "AM" isn’t a standalone word.

[Robert H]

Hello @Adithya S Uday1 ,

ServiceNow does not have a filter condition like "Short description contains {one string out of a list of strings}".

You can only search for one of these server names at a time:

Ideally these servers should be present in the CMDB, and then related to these tasks via the Configuration Item field, or the Affected CIs list. Then it would be very easy to do that kind of reporting.

Regards,

Robert