How to get the report based on Assigned Date

[shaik_irfan]

Hello,

I need to pull a report based the assigned date to any Assignment Group, we need a report where tickets are not updated since last 5 days these 5 days should be based on assigned date.

Can anyone please help me out

[SanjivMeher]

You may create a report on metric instance table. There is a metric defined on assignment. If you create a database view from it and then get the date assigned and last updated, you should get your desired report.

[shaik_irfan]

Thanks for the reply Sanjiv, Can you please help me out with the screenshot ???

[shaik_irfan]

Sanjiv,

I got that but I unable to keep the condition like we need only for Assignement Group Software & assigned to should be empty

[SanjivMeher]

Navigate to incident_metric.do and you can add your required filter. Filter by Definition = Assignment Group.

Then you can apply filter such as assigned to is empty and Assignment Group is Software