How to search ticket attachments and/or worknotes by keyword

[brianthompson]

I am looking for a way to run a report that searches word/excel/etc. attachments that are added to tickets (Tasks mainly) by keyword.   Also need a report that searches the Worknotes of a ticket by keyword.

Is this possible?

Thanks,

Brian

[sandhya0682 · Accepted solution]

How about searching the list view of the incidents by searching the worknotes field

[brianthompson]

Thanks Sandhya,

I am able to search Work Notes successfully for Incidents/Tasks.   For some reason, my view I had saved which shows Tasks and Incidents all in one view does not give me the "Work Notes" option.   I only Get the "Work Notes List" option.   But I can get by with 2 views.

Do you or anyone else know of a way to search by keyword files attached to tickets?   We sometimes get excel lists attached to tickets and would be nice if that was searchable somehow without knowing the actual ticket#.

[sandhya0682]

I am afraid this is not possible (or) extremely difficult because the attachment docs are encoded while getting saved in ServiceNow Sys_Attachment_doc table.

Therefore searching a string in an encoded data is not possible.

Just my 2 cents