Report to provide Tickets where user has put comments or has requested for.

[sbeginner]

Hi All,

User wants to have ticket where he has put comments on or has requested for. Requested for part I can work out but not sure on  how to get the comments part. Please help.

[asifnoor · Accepted solution]

Hi,

For comments, you need to script. you cannot directly get that in reports. Refer to this link to check how to script in reports.

https://community.servicenow.com/community?id=community_article&sys_id=039f65f61b495010a59033f2cd4bc...

Mark the comment as a correct answer and helpful if this has helped to solve the probelm.

[sbeginner]

Hi Asif,

Thanks for your reply. Can't we achieve this be achieved with Database views.

[asifnoor]

I think you can but you need to cpature the comments and also the  created by for the comments from a diff. table. Work notes are not stored in incident column. The entries are stored in sys_journal or sys_journal_entry, something like that. Chekc once, if you can able to get the data, then yes it will work. 

Mark the comment as a correct answer and helpful if this has helped to solve the problem.