SELECT DISTINCT
Incident.ID, DateAdd(HOUR,
-8,Incident.ResolvedDate) AS ResolvedDate,
DATEADD(hh, DATEDIFF(hh, getutcdate(), getdate()),
incident.CreatedDate) AS CreatedDate,
AffectedUserInfo.DisplayName AS [Affected USER],
Incident.Title,
COALESCE(IncidentQueue.IncidentTierQueuesValue,'Unassigned') AS [Support GROUP],
AssignedUserInfo.DisplayName

FROM IncidentDimvw Incident
LEFT OUTER JOIN IncidentTierQueuesvw IncidentQueue ON IncidentQueue.IncidentTierQueuesId = Incident.TierQueue_IncidentTierQueuesId
INNER JOIN WorkItemDimvw WI ON WI.EntityDimKey = Incident.EntityDimKey
LEFT OUTER JOIN WorkItemAffectedUserFactvw AffectedUserFact ON AffectedUserFact.WorkItemDimKey = WI.WorkItemDimKey
LEFT OUTER JOIN UserDimvw AffectedUserInfo ON AffectedUserInfo.UserDimKey = AffectedUserFact.WorkItemAffectedUser_UserDimKey

LEFT OUTER JOIN WorkItemAssignedToUserFactvw AssignedToUser ON WI.WorkItemDimKey = AssignedToUser.WorkItemDimKey
LEFT OUTER JOIN UserDim AssignedUserInfo ON AssignedUserInfo.UserDimKey = AssignedToUser.WorkItemAssignedToUser_UserDimKey

WHERE
Incident.CreatedDate < GetDate()
AND Incident.CreatedDate > DateAdd(DAY,-4,Getdate())