Update frequency report on Incident

[H M Aishwarya1]

Hi,

There is a requirement where we have to create a report for Update frequency of Incident tickets, In the incident table we have a custom string field which is used to update the ticket as BI-1 which is P1 for P1 tickets there is a rule to update it every 2 hours with work notes/ customer comments. So i am trying to create a report to track the update frequency of P1/BI-1 tickets. In the report i should be able to see Incident number, datetime stamp of the updation and work notes. 

Any help is much appreciated!

Thank you.

[Bert_c1]

You can use a database view for this. See:

for each table, select the View fields you want. for Incident use Number, State, Priority, (your custom field, others).  For the Journal entry table use element_id, element, value, created. Once you 'Try it' you can remove the element_id from the list of columns shown.

You can define a report on the database view, group by incident, etc.

By the way, no need to post the same problem twice.