Is there a way to provide a list of Assignment Group and Assigned date from the Incident?

MWright1
Giga Guru

We have been switching assignment groups as necessary in our Incident records and would like to know if there is a way to know when the incident was assigned to which group in a table format with the following columns.

  1. Incident Number
  2. Assignment Group
  3. Assigned Date

We currently do not use the SLA Breakdown application.

 

Thanks,

 

M

2 ACCEPTED SOLUTIONS

AndersBGS
Tera Patron
Tera Patron

Hi @MWright1 ,

 

Yes, you can leverage the incident_metric database view:

 

AndersSkovbjer_0-1678830766239.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Hi @MWright1 ,

 

There is no dot-walk from incident table to incident_metric, due to it's not a reference but a database view. You should instead utilize the incident_metric as reporting table, and then add below columns:

 

AndersSkovbjer_0-1678884119833.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

5 REPLIES 5

You are the best!  Thank you!

 

M