Database Reference
In-Depth Information
LEFT OUTER JOIN UserDimvw AS AffectedUser ON
WorkItemAffectedUserFactvw.WorkItemAffectedUser_UserDimKey
= AffectedUser.UserDimKey
LEFT OUTER JOIN WorkItemAssignedToUserFactvw ON
WI.WorkItemDimKey =
WorkItemAssignedToUserFactvw.WorkItemDimKey
AND WorkItemAssignedToUserFactvw.DeletedDate IS NULL
LEFT OUTER JOIN UserDimvw AssignedTo ON
WorkItemAssignedToUserFactvw.WorkItemAssignedToUser_UserDimKey
= AssignedTo.UserDimKey
LEFT OUTER JOIN WorkItemCreatedByUserFactvw ON
WI.WorkItemDimKey =
WorkItemCreatedByUserFactvw.WorkItemDimKey
AND WorkItemCreatedByUserFactvw.DeletedDate IS NULL
LEFT OUTER JOIN UserDimvw CreatedBy ON
WorkItemCreatedByUserFactvw.WorkItemCreatedByUser_UserDimKey
= CreatedBy.UserDimKey
LEFT OUTER JOIN IncidentResolvedByUserFactvw ON
I.IncidentDimKey =
IncidentResolvedByUserFactvw.IncidentDimKey
AND IncidentResolvedByUserFactvw.DeletedDate IS NULL
LEFT OUTER JOIN UserDimvw ResolvedBy ON
IncidentResolvedByUserFactvw.TroubleTicketResolvedByUser_UserDimKey
= ResolvedBy.UserDimKey
LEFT OUTER JOIN IncidentStatusvw IStatus ON
I.Status_IncidentStatusId = IStatus.IncidentStatusId
LEFT OUTER JOIN DisplayStringDimvw IStatusDS ON
IStatus.EnumTypeId = IStatusDS.BaseManagedEntityId
AND IStatusDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentImpactvw IImpact ON
