SELECT  
ISNULL(b.DisplayName, 'Нет ответственного' )as 'Ответственный',count (i.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C) as 'ID' 

   FROM [ServiceManager].[dbo].[MT_System$WorkItem$Incident] i
  left outer join [ServiceManager].[dbo].[MT_ClassExtension_a14b1420_5332_4173_8e1f_1ec88ec590e0] m on m.BaseManagedEntityId=i.BaseManagedEntityId
  left outer join dbo.LocalizedText l on l.LTStringId=m.Enum_Mesto_3D2209C9_4347_B22D_1392_8E490DF66F48
  left outer join dbo.LocalizedText l1 on l1.LTStringId=i.TierQueue_1E9615C2_3386_2452_BA83_05B2169DF38C
  left outer join [ServiceManager].[dbo].[Relationship] ro on ro.SourceEntityId=i.BaseManagedEntityId and ro.RelationshiptypeId='15E577A3-6BF9-6713-4EAC-BA5A5B7C4722' and ro.IsDeleted=0
  left outer join [ServiceManager].[dbo].[Relationship] rc on rc.SourceEntityId=i.BaseManagedEntityId and rc.RelationshiptypeId='DF738111-C7A2-B450-5872-C5F3B927481A' and rc.IsDeleted=0
  left outer join [ServiceManager].[dbo].[BaseManagedEntity] b on b.BaseManagedEntityId=ro.TargetEntityId 
  left outer join [ServiceManager].[dbo].[BaseManagedEntity] bc on bc.BaseManagedEntityId=rc.TargetEntityId 

	
 where   

  ((l.LanguageCode='rus' and l.LTStringType='1') or (l.LTStringType is null and l.LanguageCode is null ))
  and ((l1.LanguageCode='rus' and l1.LTStringType='1') or (l1.LTStringType is null and l1.LanguageCode is null ))
  and i.CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688  >= Convert(DATE, DATEADD(dd,-30,GETDATE()))
 
  group by b.DisplayName