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

[jagannaths]

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

[Michael Ritchie]

I just entered an obscure word in a worknote and waited a minute.   I then did a keywords search and the record was found.   You may want to make sure text indexing is on and working.   Support may be able to help.

http://wiki.servicenow.com/index.php?title=Administering_Zing_Text_Search

[rgm276 · Accepted solution]

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

[jagannaths]

This works. Thank you!

[Don Tanner]

Hi,

This is an old article but it seems to give me what I want.......mostly.   This now works for me in my admin role, but I need the itil role to be able to view this report as well.   The user is getting Security constraints prevent access to requested page.   I am sure I just need to grant the itil role read access to the view, but I am unsure how to pull that off.

Thanx in advance.

Don