Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database view for Audit and Incident table is not working

H M Aishwarya1
Tera Guru

3 weeks ago

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.

 

Preview file
78 KB
0 Helpfuls
  • 360 Views
3 REPLIES 3

Kieran Anson
Kilo Patron

3 weeks ago

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.

0 Helpfuls

H M Aishwarya1
Tera Guru

3 weeks ago

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. 

0 Helpfuls

Kieran Anson
Kilo Patron
In response to H M Aishwarya1

3 weeks ago

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 

0 Helpfuls