Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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.