Create a Report that shows a specific field has changed in the last hour

[Ben F_]

Hey all, 

I am attempting to schedule a report that shows a specific field "isManaged" has changed from true to false and vice versa within the last hour. 

I have tried reports but it only shows if the entire table was updated. I was told metric was the way to go. However, I am brand new to ServiceNow. I read the documentation, but I am afraid I didn't quite understand. 

Can anyone explain, in relatively simple terms, how to create a report that will send out hourly showing all the isManaged fields that have changed within the last hour. 

Thanks, 

Ben 

[Michael Fry1 · Accepted solution]

There's the problem. Out of the box Metrics work on Task or tables extended from Task. Go to module Business Rules under Metric app. Find the business rule - metrics events - on task table and create a copy of the rule on your custom table. Then try it again.

[Ben F_]

BOOM GOES THE DYNAMITE! 

Thank you so much Michael, it works. 🙂