Get Activity Log Values

Omkar Joshi · ‎02-11-2021

Hello All,

How can I get whole activity log data of particular record?

Ankur Bawiskar · ‎02-11-2021

Hi,

Then you can use before insert BR on your child table

You will have to query this table with the parent record sys_id

table - sys_history_line

Query - set.id = <parentSysId>

Then get all the activities with old and new value and put in the string field

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎02-11-2021

Hi,

If the table is audited then you can check this from

1) History calendar

2) History List

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Omkar Joshi · ‎02-11-2021

Thanks for yor reply. But how can get this activity value in script. I want to add parent activity logs in child record in string field.Is there any method to get activity log data.

Ankur Bawiskar · ‎02-11-2021

Hi,

It won't happen OOB.

If you wish to store it in some custom field then you will have to build logic around this whenever parent is updated and update the change in the custom field on child record

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Omkar Joshi · ‎02-11-2021

Thanks Ankur for your quick reply. I don't want it at everytime.At the time of child creation I need to display just activity logs of parent fields in string field. (Only one time). So is there any way to get that whole activity log.