Report - incident table by referring activities

Jagat
Tera Contributor

Hi Team,
I want a report in incident table, where we can see all activities in column value for closed incident for audit purpose.
Please suggest how to do it.

 

Jagat_0-1718001596197.png

 

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Jagat 

 

I doubt we can build a report on activity changes. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG ,
Even I have checked few and tried building one by referring sys_audit field but unable to get 1000+ inc records in a column value.
There is a requirement from client like this to get all logs incident wise in column to check.
an we say no directly or any way to achieve this.. Please help if any luck.. would be a great help..

No mate, really tough bcz every record has number of change and not a feasible way to consolidate.

 

Did you try Group by on incident, but I am sure it will come in separate row only.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sure , let me check with client on this .. Will get back tomorrow..
Thank you!!