How can I tell all incidents that a given assignment group touched

[johnfeist]

I've seen all the postings about using a metric, for this case it won't help because we don't have that metric set up and I need to look back in time.

Basically I need to be able to determine if a given team was ever assigned to an incident during a given time frame.  I suspect that absent a significant amount of coding getting an accurate answer is not possible.  Has anyone been able to do this?

All suggestions are gratefully accepted.

:{)

[Mohith Devatte]

hello @johnfeist ,

the only way is metric .

if you have a metric on assignment group field then you can find metric instances .

But the only catch here is you cant get the past data in specific time frames with metrics it only caotures the data from the time the metrics is created.

OR 

check if you have audit enabled for your table assignment group field .

you might get the history of changes 

please mark my answer correct if it helps you

[johnfeist]

Thank you Mohith.  We do have audit data for assignment group.  However, integrating the data for incidents with the data from audit is not a simple task.  I'm hoping that someone has already come up with an efficient way to get the two data sets synchronized.

:{)

[Mohith Devatte]

@johnfeist i se, totally agreed playing with audit table is a risky thing .

but i think then its only possible with metric but unfortunately you cant get the old data!

[Daniel Oderbolz]

Are you sure you do not have these Metrics (its OOTB since a looong time).

Check Metrics -> Definitions and look for the table "Incident".

If they are really not there, you may want to have a look at the HistoryWalker  (https://docs.servicenow.com/bundle/washingtondc-api-reference/page/app-store/dev_portal/API_referenc...) or manally query the Audit Table (see https://docs.servicenow.com/bundle/washingtondc-platform-security/page/administer/time/concept/explo...)