Create a Report using Field Changes on the Notes tab

[DataSlayer]

I would like to create a report that captures the date that a Demand moved from each state. I am trying to capture metrics to report time periods per state.... HELP! I can see the Field Changes on the Notes tab within the Activities, however I am unable to locate the Choose Columns in the Reports builder, please help? 

[David Hepburn]

Fear not, @DataSlayer , for a solution is but a few short steps away.

1. All > Metrics > Definitions
2. New
3. Complete the form as shown
   1. Number is automatically assigned
   2. Name -- my name means Demand Time In State from the dmn_demand table
   3. Table -- dmn_demand
   4. Field -- state
   5. Application -- global
   6. Type -- field value duration
   7. Timeline -- check this box if you want to enable a graphical, timeline view
   8. Active -- check this box
   9. Description -- something meaningful
   10. Script -- don't mess with this part
   11. Click Submit

For a demand time-in-state report, requirements are likely to include presentation of the metrics themselves as well as data from the demands.  To build a report containing this data, a Database View is necessary.

The ServiceNow doc Database Views in the Base System does a good job of explaining some of the OOTB views; however, there is no OOTB view for Demands. You'll need to create one. 

For your view, you'll need the [metric_definition] table, the [metric_instance] table, and the [dmn_demand] table. 

Consider using OOTB view [sc_task_metric] as a model.

• [metric_definition] -- stores the setup for the metrics you want to capture
• [metric_instance] -- stores the metrics... all of the metrics.  The database view helps to whittle the metric records down to the ones in which you're interested.

Since it sounds like you may be new-ish to Metrics, it's important to note that it's not possible to capture historical metrics.  The metric calculations begin when you click the "Submit" button in Step 11 above.

Metrics are fun.  Lemme know if I can help further.  Now go forth and slay some data ⚔

David

[DataSlayer]

David, thanks for the response.... I am sure it is the solution I need, sadly my access/ version of ServiceNow doesn't allow for those capabilities/ option. So, I am back to manually extracting the field notes as able. THANK YOU!!!