Identifying the previous assignment group of a given Case

[Deshan1]

Hi Guys,

Do you guys know whether it is possible to identify the previous assignment group of a given Case?

Does any table in the SNOW DB capture the immediate predecessor assignment group of a given Case?

Your help and support is much appreciated.

Thank you,
Kind Regards,
Deshan

[karthiknagaramu]

Hi,

This information can be fetched from "sys_history_line" table if audit is enabled for the table and the field.

In this table you can use the "set" field to identify the audit records related to the ticket. And then you can use the old and new value fields to get the previous value.

Regards,

Karthik

[Adam Stout]

What is your use case?  That will greatly influence how to go about this (in addition to the comments above).