SELECT 
	   up.CI_ID
	  ,'KB' + up.ArticleID as 'KB Article'
	  ,up.BulletinID
	  ,Case when up.IsExpired = 0 then ''
	   Else 'Expired'
	   end as 'Expired'
	  ,Case when up.IsSuperseded = 0 then ''
	   else 'Superseeded'
	   end as 'Superseeded'
	  ,Case when up.CustomSeverity = 0 then ''
	   else 'Excluded'
	   end as 'Manual Exclusion'
	  ,up.DateRevised as Date
	  ,Comp.NumMissing as 'Required by Systems'
	  ,up.Title
	  ,up.InfoURL
	  ,up.Description
	  
  FROM v_UpdateInfo UP
  Left Join vUpdate_ComplianceSummary Comp on comp.CI_ID = UP.CI_ID
  
  where CIType_ID <> '9'
  
  order by up.DateRevised desc