Get Activity Log Values

Omkar Joshi
Giga Guru

Hello All,

 

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

 

find_real_file.png

1 ACCEPTED SOLUTION

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

6 REPLIES 6

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

Thanks you its work for me. 🙂