Regarding Report Creation

[venkyk1309]

Hello,

I am new to this report creations, I want to create a report to provide a comprehensive overview of all incidents/RITMS historically assigned to the Service Desk queue (SD). The report will include timestamps for each instance a ticket was assigned to the SD queue

Fields to Include:

Incident Number
Assignment Group (SD)

Assignment Count
Timestamp of each Assigned to SD
Current Status of Incident

Filters:
Only incidents/RITMS assigned to SD.
Historical data (all past incidents).

[Mark Manders]

You can only create these kinds of reports if you have that data stored anywhere. That means that you either need PA that has collected the data in the past, including the assigning, or metrics that did the same. So you first need to check if you have the data. Then you need to create database views or dotwalk to the needed fields to show them on the list.
OOB there is a Metric Definition for assignment group on incident, so if that's not inactivated, you have that data, but for RITMs there aren't any OOB. If they have not been created on your instance, you can only start reporting on them from the moment you do create them (and same goes for PA indicators, if you have the PA license).