How to export activity log of the Incident into a Excel file?

[Gokulraj1]

Hi All,

I have to import a monthly data for activity log for all Incidents.

Is it possible?

Please,share your ideas.

Thanks in Advance,

Gokulraj

[Rajesh Mushke]

Hi Gokulraj,

You can export it from from the Journal Entries(sys_journal_field) table, for example you can search with Name & CI number in the value like in below screen shot & after that you can export them

Let me know if it doesn't works.

Thanks,

Rajashekhar Mushke

Community Leader-18

[Gokulraj1]

Hi,

That table contains only work_notes and additional comments.Not everything in the activities,

Please refer the below images

Image 1

Image 2

In the first image there is field changes value present ,which is not available in the "Journal Entries"  Table,please refer the second image.

[Rajesh Mushke]

Refer the below links may helpful to you.

Get the Activity Log of an Incident

Using activity information for reporting (w/r/t incident management)

Export the Activity log to Excel

http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/security/concept/c_Di...  

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/security/reference/r_...  

Let me know if you need more help

Thanks,

Rajashekhar Mushke

Community Leader-18

[Gokulraj1]

Hi Rajashekhar,

I had referred  those links previously but not able get my requirement properly.

I want to fetch the entire information in the activities based on the incident number.

Is there any alternate way?

[sabyasachi1983]

Have you got any solution? I have the same requirement but no suitable answer anywhere. Is it not at all doable?