Report on Record Producer usage

[march]

Hi,

I would like to be able to report on the different Record producer usage. I miss the link between the task created (incident, Request, Change, ....) and the Record Producer used to create it. What i initially did was to add a worknotes entry in the task created in order to be able to track this back. But, this is good enough on a case by case basis, but not to be able to report on Record Producer usage.

Marc.

[Ivan Martez]

You could create a new field on the form that is hidden. The field could be a Boolean field that is changed from the script in the record producer. For example, if you created a field called "Created by RP" that was a boolean field, from the record producer script you could have that field set to "true" whenever a record is created using that producer. This way you can report on it.

[RobertBarnes · Accepted solution]

We had a similar need, and our solution was to add a reference field on the task table that links to the specific record producer. The script on the record producer updates this field when the record producer saves the record. This allows us to determine exactly which record producers produced which records. We can now get very detailed metrics on the use of our service catalog.

[march]

Thank you, that would indeed do the trick.

[Avi4]

I was unable to generate a report with the available tools, but I could generate a report from a script and copy and paste it to an excel spreadsheet. 
My solution was to create this DB View based on the assumption that for any incident that was created by a record producer, there must be at least 1 variable :

 Then run this fix script:

var grURPV = new GlideAggregate('u_record_producer_variables');
grURPV.addEncodedQuery("qa_sys_created_onONLast 12 months@javascript:gs.beginningOfLast12Months()@javascript:gs.endOfLast12Months()");
grURPV.addAggregate('COUNT(DISTINCT', 'qa_table_sys_id');
grURPV.groupBy('var_cat_item');
grURPV.query();
while (grURPV.next()) {
    gs.log(grURPV.var_cat_item.getDisplayValue()+","+grURPV.getAggregate('COUNT(DISTINCT', 'qa_table_sys_id'));
}

Copy and paste it to notepad++ and save it as CSV does the job.