List of all field values of the task table and its extended table

Meloper · ‎10-12-2023

Hello,
I would like to search all task records for a specific field value. Basically I want to search all ServiceNow records for the value.
The value can appear in all fields.
I can get further with the global search, but unfortunately this is not enough.

I am looking for a specific url.
This can be in any field, whether short Description, URL Field etc.

is there something similar to question_answer.LIST?

With the global search I have the feeling that only the CMDB is searched.

SwathiSarang · ‎10-12-2023

Hi @Meloper ,

May be you can use sys_audit table where it stores all the old value and new value.

Hope this solves your question. if it does, please mark my response helpful and solution accepted.

Thank you
Swathi Sarang

Meloper · ‎10-13-2023

greate idea, thank you, i will let you know

SwathiSarang · ‎10-17-2023

@Meloper Hope this helped you ! Let me know if you need anything else or if not please mark the approppriate solution as correct and close the thread so that it will benifit future readers

Hope this solves your question. if it does, please mark my response helpful and solution accepted.

Thank you
Swathi Sarang

Ankur Bawiskar · ‎10-12-2023

@Meloper

what's the business requirement to find this?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader