Where can I find this in Enterprise Insights Table?

Joe

I have dependencies that are cross portoflio.  I want to find them easily, rather than building a view of program to portfolio on requestor and depends on.

 

I get this warning sign in said dependency but for the life of me I can't find that error/alert in any table in Enterprise Insights.

 

Anyone know where it's hiding?

This is the warning:
 Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments

Allan Maxwell

I don't believe there is a table that caches Planning Increment Conflicts.  The follow SQL will find those in error, although I didn't take into consideration Kanban Teams:

Dependency ID	Dependency Title	Dependency Type	Status	Work PI	Dependent Work PI	Planning Error MSG
2892	Clarity on security and privacy laws to be implemented in consumer goods industry	Epic External Dependency	Committed	R5	R4	Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments
2893	Server updates	Program Dependency	Committed	R5	R4	Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments

 

 

SELECT D.[Dependency ID], D.[Dependency Title], D.[Dependency Type], D.[Status], PI_REQUEST.[PI Name] AS [Work PI], PI_PLANNED.[PI Name] AS [Dependent Work PI], 
   'Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments' AS [Planning Error MSG]
FROM [current_dw].[Dependency] AS D
LEFT OUTER JOIN [current_dw].[Program Increment] AS PI_REQUEST ON PI_REQUEST.[Program Increment ID] = D.[FK Program Increment ID]
LEFT OUTER JOIN [current_dw].[MAP Dependency to Story] AS D2S ON [FK Dependency ID] = D.[FK Epic ID]
LEFT OUTER JOIN [current_dw].[Story] AS DEPENDENT_STORY ON DEPENDENT_STORY.[Story ID] = D2S.[FK Story ID]
LEFT OUTER JOIN [current_dw].[Program Increment] AS PI_PLANNED ON PI_PLANNED.[Program Increment ID] = DEPENDENT_STORY.[FK Program Increment ID]
WHERE D.[Delivered Flag] = 'No'
   AND D.[No Work Required Flag] = 'No'
   AND D.[Commited Flag] = 'Yes'
   AND PI_REQUEST.[PI Name] != PI_PLANNED.[PI Name]