Hi @developer18,
To achieve the KPI that shows the list of Service Offerings without Incidents or Requests in the last 6 months, you can use the Reporting module in ServiceNow. Below are the step-by-step instructions:
1. Navigate to Reports > Create New
2. Set Up the Report Source:
- Report Name: List of Service Offerings Without Tickets (6 Months)
- Source Type: Table
- Table: Offering [service_offering]
3. Set the Related List Conditions:
In the Related List Conditions section, configure as follows:
- Set the filter to: Equal to 0 selected table records are related to a record on Offering
- Related List Table: Task → Service offering
- Filter Conditions on Task:
- Task type is Incident OR Task type is Request
- AND Created on Last 6 months
This ensures that only Service Offerings with zero related Incidents or Requests in the last 6 months are returned.
4. Select the Report Type:
- Go to the Type tab
- Choose List as the report format
5. Configure Config tab:
- Go to the Configure tab
- Set Group By: None
Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
The related list displays all tasks associated with a Service Offering.
I applied a filter on Task Type to include only Incidents and Requests, ensuring the list only shows relevant task types linked to the Service Offering.
Additionally, I filtered by Created on (Last 6 Months) to display only those Incidents and Requests that were created within the past 6 months.
To identify Service Offerings without any related Incidents or Requests created in the last 6 months, I used the condition:
"Equal to 0 selected table records are related to a record on Offering"
This setup ensures that the filtered result shows only those Service Offerings with no associated Incidents or Requests within the last 6 months.
Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
