Hi Team,

I have a requirement to find count and list of incidents which were reassigned from one tier-queue to a different tier-queue.

Any help would be appreciated.

Thanks  

You can find that data in the Data Warehouse: dbo.IncidentTierQueueDurationFactvw.

• Proposed as answer by Andreas BaumgartenMVP, Moderator 11 hours 46 minutes ago

You can find that data in the Data Warehouse: dbo.IncidentTierQueueDurationFactvw.

• Proposed as answer by Andreas BaumgartenMVP, Moderator Thursday, August 20, 2015 7:32 PM

You can find that data in the Data Warehouse: dbo.IncidentTierQueueDurationFactvw.

• Proposed as answer by Andreas BaumgartenMVP, Moderator Thursday, August 20, 2015 7:32 PM
• Marked as answer by Xin GuoMicrosoft contingent staff, Moderator 19 hours 55 minutes ago

You can find that data in the Data Warehouse: dbo.IncidentTierQueueDurationFactvw.

• Proposed as answer by Andreas BaumgartenMVP, Moderator Thursday, August 20, 2015 7:32 PM
• Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:20 AM

You can find that data in the Data Warehouse: dbo.IncidentTierQueueDurationFactvw.

• Proposed as answer by Andreas BaumgartenMVP, Moderator Thursday, August 20, 2015 7:32 PM
• Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:20 AM

Hi Foothill,

thanks for your time to look into this... however the view dbo.IncidentTierQueueDurationFactvw does not have any reference to the Incident numbers :(

That table has a link back to dbo.IncidentDim which stores all incidents.

SELECT * FROM dbo.IncidentDim AS IR
JOIN dbo.IncidentTierQueueDurationFactvw AS IR_DUR
ON IR.IncidentDimKey = IR_DUR.IncidentDimKey

Just filter down to what particular incident you are looking for.