Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

does sys_audit table captures the records from database view?

Aasrita
Tera Contributor

Hello team,

 

 I want to know if my database view records are getting captured in sys_audit table. can anyone please let me know how to check it. 

i also want to know what are all the tables are being captured in sys_audit table.


thank you in advance.

1 REPLY 1

Ravi Chandra_K
Kilo Patron

Hi @Aasrita 

I don't think database view records get captured in the audit as it is is not an actual table on the database.

there will be audit checkbox on the dictionary entry of the table. (type = collection)

in general, system tables (starts with sys) are not audited.

 

Please refer below docs:

https://docs.servicenow.com/bundle/washingtondc-platform-security/page/administer/security/task/t_En...

https://docs.servicenow.com/bundle/washingtondc-platform-security/page/administer/security/task/enab...

 

Please mark my answer as helpful and correct if helped.

 

Kind Regards,

Ravi Chandra