When i open the sys_audit table , it is going to transcation timeout

[Shiva Durga Pra]

hello folks, 

I need to download the incident audit CSV file, but not able to get, 

when I am trying to open the sys audit it gets timeout 

is there any way to download a CSV file for  incident events_ yyyymmdd-yyyymmdd.csv (2 years)

[Mark Manders]

Can you try this (replace 'instance' with your instance). It returns only the incident audits from this week. You can then change your filter to show what you need, but at least the table opens.

https://instance.service-now.com/sys_audit_list.do?sysparm_query=tablenameSTARTSWITHincident%5Esys_c...

Do know that, depending on the size of the log, ServiceNow has download limits, so you may need to do it in a couple of attempts.

[Shiva Durga Pra]

Thanks for response.

No luck  

still getting timed out.

[Tai Vu]

Hi @Shiva Durga Pra 

2 years might be containing a huge data within the Audit [sys_audit] table.

You can try to open the list with Filter only then breakdown your data using conditions with different time range until you get them all.

Try this sys_audit.FILTER to open the list with filter only.

 

You can also break up a large data while exporting by following the steps in the docs below.

Break up a large export

Cheers,

Tai Vu