Incident Excel report

Divya Akula · ‎02-08-2023

Hi Everyone,

Please help me that,when i export report of Excel on incidensts pending time should be reflect in the Excel sheet please help me on this high priority

shyamkumar VK · ‎02-09-2023

that is what my solution was , I didn't provided resolved or completed state ,

1. go to incident_metric table

2. under filter add condition as "State is Pending"

3. Records get appears and export them to Excel

can you also show the filter which you have used in metrics table

Please mark this as helpful and accept as a solution if this resolves your Ask.
Regards,

Shyamkumar

View solution in original post

Divya Akula · ‎02-09-2023

Hi Shyam,

No it didn't help for me,it's for resolved and closed incidents we are looking for.

Divya Akula · ‎02-09-2023

Is there any way kindly help me.

shyamkumar VK · ‎02-09-2023

In metrics we can calculate pending state duration as well , can you please eloborate your requirement , what i have understood is your want the duration of Incidents which are put under pending right?

Please mark this as helpful and accept as a solution if this resolves your Ask.
Regards,

Shyamkumar

Divya Akula · ‎02-09-2023

We need time and date when incident state moved to pending not duration for resolved or closed tickets.

shyamkumar VK · ‎02-09-2023

that is what my solution was , I didn't provided resolved or completed state ,

1. go to incident_metric table

2. under filter add condition as "State is Pending"

3. Records get appears and export them to Excel

can you also show the filter which you have used in metrics table

Please mark this as helpful and accept as a solution if this resolves your Ask.
Regards,

Shyamkumar