Audit logs for reference tables in a form

[irfanshaik]

Hello,

We have a table that references 2-3 other tables.

We have constructed a form for that table that shows fields from the main table and from the reference tables by getting their fields through dot walking.

The question is about tracking the changes or actions performed on the form. I have enabled audit log for the main table and the reference tables, but in order to see what changes have taken place on the main form, i am having to go to the corresponding table and check the history view. 

Is it possible to see all the changes to a form(that has fields from the main and reference tables) in a single place ?

[Sumanth16]

HI @irfanshaik ,

You can create "Database Views" and merge all these tables by combining all these tables.

https://www.servicenow.com/community/developer-blog/what-is-servicenow-database-view-create-servicen...

Note: Creating reports on Audit tables is not recommended.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[irfanshaik]

Thank you.

If i have 2 tables 't1' and 't2'. There is a column in t1 called 'col1' that references the table 't2', what would be the where clause that i can use for the view

[Aman Kumar S]

Hi @irfanshaik 

No, you can't.

Audits are tracked only on the respective table and can't be done on the form where you have dot walked.

One thing that you can do, is to open the history logs in a new window and apply necessary filters so the records that you want to see, only those show up.

That will save you the effort of navigating mulitple forms.

[irfanshaik]

Thank you.

If we want to see what changes have taken place on a form is this the only way ? Are there any other ways that we can explore? We would ideally like to see all changes for a given form in a single place.