Need assistance in reporting reassignment of records

[saint]

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.

[AndersBGS]

Hi @saint ,

You should utilize the OOTB metric definition for assignment group to understand old value and new value. 

[VinayN782679093]

Hi @saint,

you can do it via "Matric" feature in ServiceNow which we can use for reporting such kinda scenario.  

OOB its available of incident table. for sctask table you need to create new matric for reassignment. 

ServiceNow Navigation Path: Navigate search > Matric > Definitions > search Name "Assignment Group".

Let me know if this info is helpful.

[VinayN782679093]

Hi @saint 

Hope you are doing well.

Did my previous reply answer your question?

If it was helpful, please mark it as correct ✓ and close the thread . This will help other readers find the solution more easily.

Regards,

V

[Ankur Bawiskar · Accepted solution]

@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

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

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