Is there a way report on incident activities data? We don't see how to access these fields in Service Now reporting

[Myron Smith]

We have built custom flows to alarm on problems in our system. Whenever we alarm we create an incident. If we leave the incident open it adds a note to the activity section of the incident. Is there a way to show these counts in the servicenow reports so we can show management how often these alarms are firing?

[Tony Chatfield1]

Hi, I assume the 'notes' are the addition of a 'comment' to the comment or work_note journals?
in which case the best solution might be to add an integer field to your incident table and index this every time you get a new alarm and update the 'activities'.
If you need to do set this value for legacy tasks then you could run a fix script outside of business hours to check your audit\historical data and update the new incident field, but I would not query audit\historical data as part of a BAU report as this may result in degraded platform performance.