Need assistance in reporting reassignment of records

saint
Tera Expert

Need assistance in creating a report on task table (for sctask and inc) to know the old value and new value of a assignment group for the record, so it can be reported.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@saint 

already incident_metric database view is there to know the old and new value

create report on that database view table

-> see metric definitions on incident, create similar for sc_task

55.png

55.png

on similar lines you can create database view for sc_task by joining the tables

55.png

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

@saint 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur, thank you! I was able to create a database view. I’m still working on the best approach for building the report, but your screenshots were very helpful.