Need to create report showing approver and when the approval was given

[Armin Heinlein1]

I need to create a PDF document showing the approver and when the approval was given.

No problem with getting the approver (sysapproval_approver) and the comments but from where do I get the actual date and time of the approval from? I can see it under activities but I not getting that info with the getJournalEntry(-1) method.

This is what I get if there is a comment. No state changes

[Armin Heinlein1]

Abhishek,

You are right that is the easiest.

[Nicole_k]

Hey,

I was fumbling around with this one myself. I am new to ServiceNow so this may be completely wrong but I have done the following DB view. This then gives you plenty of information to use.  Hope it helps