Database view for Audit and Incident table is not working

[H M Aishwarya1]

Hi,

I have created the Database view for Audit and Incident table, I am trying to join these 2 tables but its not working.

Any help is much appreciated.

Thank you.

[Kieran Anson]

Hi,

your database view doesn't currently have a join query specified to connect the two tables. Also, what are you trying to do? Whenever someone posts about reporting on the audit table, it raises alarm bells as the table isn't intended to be reported on directly.

[H M Aishwarya1]

Hi,

Basically i was trying to fetch the details of update frequency on Incident table where i should be able to see created timestamp, INC number and work notes/comments. 

[Kieran Anson]

sys_journal_field would capture comments and work notes, rather than needing to query the audit table. However, it would be beneficial to create a metric definition and/or SLA if you're need to report/manage on update frequency