Report on Absence of Metric Creation

pbrandt328
Mega Contributor

‎10-13-2023 12:10 PM

Hello SN community,

 

My org has built out a metric that runs when a member of the assignment group of a given task updates it for the first time (and calculates duration from task creation). The manager of one of our teams is asking for a report on all tasks older than 24 hours that don't have any such update. 

 

My first thought was to use related list condition, point it towards the metrics table, and filter out all records that had an entry on that table under that specific metric definition. However, it appears as though ServiceNow reporting doesn't allow for that.

 

Is there another way around this-- any way to report on which entries on a specific task table *do not* have an entry on the metrics instance table for a specific definition?

0 Helpfuls
  • 351 Views
1 REPLY 1

Niklas Peterson
Mega Sage
Mega Sage

‎10-15-2023 05:01 AM

Hi,

Yes, that will not work since you don't have a reference on the metric table. You should be able to achieve what you want by creating a database view combining Task table and Metric table with a Left join to fetch all record from Task. That will be quite heavy for the report engine to process so you want to filter it. For example by using a before query business rule.

 

Regards,
Niklas

0 Helpfuls