Metric instance is not getting created for em_alert table

[rubesh_u]

I have created an metric definition for em_alert table like this for state tracking. 

Metric instance is not getting created for em_alert table when the state changes

[Ankur Bawiskar]

@rubesh_u 

for new records if state changes it should work

[rubesh_u]

Hi @Ankur Bawiskar 

Even for newly created records it is not working. But this same configuration works on Incident table I tried audit true on table collection eventhough it is not working

[Ankur Bawiskar]

@rubesh_u 

is auditing enabled on the table and state field?

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

[Tanushree Maiti · Accepted solution]

Hi @rubesh_u 

Refer: https://www.servicenow.com/community/platform-analytics-forum/metric-instance-is-not-getting-created...

"Resource table is not extended from Task. Metrics out of the box only work on task and extended tables, but you can use other tables.

Under Metrics application > Business Rules - there is a BR named: metrics events - copy the BR and change table to resource_plan, name can be anything. Then see if Metric gets created."