Inactivity Monitor Report/Dashboard

bcole
Tera Contributor

Hello Community,

I'm trying to figure out how to create a dashboard for the Incident Inactivity Monitors. I thought I would start with a report but can't figure how to create a report to show that event either.  Any ideas?

1 ACCEPTED SOLUTION

@bcole 

 

As mentioned earlier, system events table do not retain history for a longer timeframe and it will be rotated. If you go to System Events Dashboard -> Event name - Incident Inactivity, it would have limited history as well and would not show historical data.

 

Please check with ServiceNow support if the incident inactivity data is stored in any other table with longer retention. If not, you can create a new automated indicator and define daily data collection job and use it for reports or dashboards.

 

If my responses helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

View solution in original post

13 REPLIES 13

bcole
Tera Contributor

Right. My problem is I'm not sure what I should be pulling to add to a report.  I don't see a way to reference Incident.Inactivity in report building.

 

bcole
Tera Contributor

Right. My problem is I'm not sure what I should be pulling to add to a report.  I don't see a way to reference Incident.Inactivity in report building.

@bcole 

 

Table name is 'sysevent' and field name is 'incident.inactivity'

Bhuvan_0-1757003233184.png

You can create a report or data visualization using this data source and share it with users/groups/email IDs for notifications.

 

There is a property glide.ui.permitted_tables that prevents reports & dashboards creation on system tables. Go to system properties and allow sysevent table to be allowed for reports & dashboards and save it

Bhuvan_1-1757003562697.png

Bhuvan_2-1757003668783.png

Bhuvan_3-1757003698585.png

You can go to more actions -> Schedule and send the report to users/groups/email IDs.

Bhuvan_4-1757003774858.png

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

@bcole 

 

Please note system events table do not retain data for a longer time and you can use this report to be shared on weekly basis so that you can have necessary data for reference.

 

As per community guidelines, you can accept more than one answer as accepted solution. If my responses helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

@bcole 

 

Did you get a chance to review this ?

 

If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan