SCSM (System Center Service Manager) Custom Reports 101 with...
getdate()), incident.CreatedDate) as [CreatedDate],AffectedUserInfo.DisplayName AS [Affected User],Coalesce(AssignedToInfo.DisplayName, 'Unassigned') AS [Assigned To User],Incident.Title, IncidentQueue.IncidentTierQueuesValue