Servicenow - Return of incident latest comments from worklog

Dashboard Server
1

Hi Folks

Has anyone linked through to Servicenow and looked to pull back the latest update on an incident? I am pulling back all of the comments/worklogs but it obviously is just text wrapping. I only need the latest update status. Any ideas?

Thanks as always

Barney

2

Hi,

you can pull from the sys_journal_field table where element_id = sys_id of the task you are looking at

this will give you the worklog/comments as separate items with there own properties such as value and date (which can be sorted to get the latest)

1 Like
3

Thanks David