how to add approvers record data with requested item table data csv import

[jituksingh]

Hi,

I am downloading all the records from requested item table (sc_req_item) in a CSV format but with data I also want to include all approver data record, like who were the approvers, when and who approved the request. I don't know how to achieve that. Can someone please help with my query, I see approval history but many items where we do have approvers data but approval history field is empty.

Please let me know if I need to provide some more data.

Regards,

Jitendra Singh

[jituksingh]

Please consider csv export instead of import.

[Alp Utku]

You can report on sysapproval_approver table to get approval / approver data.

[Ankur Bawiskar]

@jituksingh 

that's correct because RITM doesn't hold Approver data.

You can create custom fields on RITM table to store Approver, Who Approved and When Approved.

You can use after update BR on sysapproval_approver table to update these custom fields when Approval is Approved. 

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

[jituksingh]

Thank you for the reply! I am new to Snow. Can you please help me with steps to follow?