- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 03:06 AM
Hi Team,
I want to create a report on audit management. Client has shared us few fields which they have for audit, we have mapped those fields with the fields which we have in servicenow. Few fields belongs to engagement table and few fields belongs to audit task.
I need to create a report which shows all these fields together in a list type of report.
How to create this kind of report?
Do i need to use database views? If yes then how to do it?
Thanks
Solved! Go to Solution.
- Labels:
-
Audit Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2022 09:53 PM
Hello Poorva,
I just Implemented the same on My PDI,where I created a database view with 2 table.
1.sn_audit_m2m_engagement (contains Entity and Engagement table data).
2.Audit task ( contains Task data).
Also use where clause as mentioned in below image.
Please try this solutions and mark this answer as helpful and Correct,which also help Other who are searching for the same solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2022 12:20 AM
share your configuration screenshot here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2022 06:28 AM
These are the fields i have selected from engagement, entity and audit task tables.
I want to merge these tables fields and need to create report when type is a security access review. Type is field on engagement form.
I am not getting how will i get data using this.
When i am creating report on this database view table, and adding filter condition for type is security access review, its not showing me any records.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2022 06:34 AM
one more thing engagement and audit task is extending planned task table

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2022 09:53 PM
Hello Poorva,
I just Implemented the same on My PDI,where I created a database view with 2 table.
1.sn_audit_m2m_engagement (contains Entity and Engagement table data).
2.Audit task ( contains Task data).
Also use where clause as mentioned in below image.
Please try this solutions and mark this answer as helpful and Correct,which also help Other who are searching for the same solution.