Audit Management Report

Poorva Bhawsar2 · ‎06-07-2022

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

Yash Agrawal1 · ‎06-17-2022

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.

View solution in original post

Community Alums · ‎06-07-2022

Hi @Poorva Bhawsar ,

Here the answer given by Michael should help you :

https://community.servicenow.com/community?id=community_question&sys_id=fda903e5db5cdbc01dcaf3231f96...

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

Poorva Bhawsar2 · ‎06-07-2022

I have created database views to map these 3 tables fields together. I have created report as well but i am not able to fetch data into this table.

Community Alums · ‎06-07-2022

Do you have data in these tables? Have you checked the underlying ACLs configured on these tables which you are calling? do you have enough roles to view the data ?

These answers of my questions asked above should help you.

Poorva Bhawsar · ‎06-08-2022

yes data is there in these tables. I am not able to build logic for where clause. Can you please guide me for the same?