Reports on sys_audit table

shivaadapa
Tera Expert

Hi 

Is it good practice to report on sys_audit table? or is there any alternative ways to do reports?

5 REPLIES 5

AndersBGS
Tera Patron
Tera Patron

Hi @shivaadapa ,

 

Basic no - the table will hold so much data and take long time to query. According to your question "or is there any alternative ways to do reports?" - please elaborate some further on the reporting requirement. What is needed, what would you/the business like to see etc.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards
Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS 

shall I do PA on sys_audit table? or is there any alternative way ?

Hi @shivaadapa ,

 

As stated in earlier post, please elaborate some further on the reporting requirement. What is needed, what would you/the business like to see etc. Which table(s), what information, etc.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards
Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS 

I am creating a check for best practice. so, I need write resolution details, so provide me that is there any alternative way instead of reports on sys_audit table?