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]

FYI after creation of Metric, then data will start to get captured for reporting.

Create a field value metric, selecting the table and field. Has the field changes entries will show below.

Then build a report on the instance_metric table with conditions Definition - is - [name of your metric], and created on relative [last hour]

The value field in the metric should contain true or false to indicate the change.

[Ben F_]

This was very helpful. You mentioned above that the data will begin being captured for reporting. Is there a delay (every hour, day, etc.) or should it be instantaneous? 

I have the following metric set up. I went into the table and began changing the isManaged fields to test. Nothing is populating in the metrics. 

[Michael Fry1]

Every change it should capture a metric instance. You changed it and then saved the ticket? Does history show it changed?

What table are you using in your metric? something extended from task?

[Ben F_]

The table I am using is an extension of the cmdb_ci table. It is called "u_cmdb_ci_custom". 

I changed the value and saved the ticket. The value stays changed after the save. 

I'm not sure where to check history beyond that. 

Also this may be worth mentioning, it is a check box.