Additional Comments empty on filter condition

[Abdul]

Hi 

i am trying to create a report in servicenow where in for incidents which are on hold and additional comments are not updated for the past 2 days.

I am trying to filter for "additional comments" in the condition field i am unable to do so can someone help me please

Thanks 

[Ankur Bawiskar]

@Abdul 

that's because comments are stored in sys_journal_field table

check this

Report to show tickets where additional comments not updates in x number of days

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Abdul 
check this as well

Reporting on "time since last comment added" or "tickets with no comments" 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏