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

[Snow12]

Hello,

Did you try using the sys_audit table and filter on incident then export the data you want ? 

[Gokulraj1]

Hi,

After filter condition below snap I am getting,

[Gokulraj1]

The below image shows the activities,

I want this one to export into Excel file.

[Snow12]

Hello,

the changes in the snap were  created on 2017-12-01 maybe you should add date filter of this date to show the data, and if necessary add also filter on field name, for example : 

created date should be 2017-12-01.

You can also import data from sys_history_set and sys_history_line tables using the same filter (incident number + date).

Hope it could help.