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

Gokulraj1
Kilo Contributor

‎04-27-2018 01:12 AM

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

0 Helpfuls
  • 5,060 Views
9 REPLIES 9

Snow12
Kilo Contributor

‎04-27-2018 02:02 AM

Hello,

 

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

0 Helpfuls

Gokulraj1
Kilo Contributor

‎04-27-2018 02:21 AM

Hi,

 

After filter condition below snap I am getting,

 

find_real_file.png

Preview file
55 KB
0 Helpfuls

Gokulraj1
Kilo Contributor

‎04-27-2018 02:51 AM

The below image shows the activities,

find_real_file.png

 

I want this one to export into Excel file.

Preview file
35 KB
0 Helpfuls

Snow12
Kilo Contributor
In response to Gokulraj1

‎04-27-2018 04:45 AM

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.

0 Helpfuls