Can we run reports or global text search on the content in work notes?

jagannaths · ‎12-04-2014

We have a requirement to run reports on work notes content? Is that possible at all? I have tried using keywords. But that doesn't work on work notes. Also, can work notes be included in global text search searchable fields/tables?

Thanks,

Swathi

rgm276 · ‎12-04-2014

Are you trying to run it for a particular type of work note ?

For example if you want to run reports for work notes in Incidents, you can create a database view

and then run a report from using that new view

Step 1) Create New Database View, and link the tables

Step 2) Create your report using this new Table/Database View

View solution in original post

Snehal13 · ‎09-08-2024

Thanks for sharing this one. will try and let know.

Anurag Tripathi · ‎12-05-2014

Hi Swathi,

You will have to run a report on the sys_audit table.

Check this link for more detail on reporting on system tables .

https://community.servicenow.com/thread/173925

NOTE: THIS IS A BIG PERFORMANCE THREAT.

-Anurag