List of Disabled Programs

SELECT  [AdvertisementID]
      ,[AdvertisementName]
,[ProgramFlags]
      ,[PackageID]
      ,[ProgramName]
      ,[CollectionID]
      ,[PresentTime]
      ,[TimeFlags]
      ,[ExpirationTime]
      ,[AdvertisementSourceSite]
      ,[PackageName]
      ,[PackageVersion]
      ,[PackageLanguage]
      ,[PackageManufacturer]
      ,[CollectionName]
     
FROM [dbo].[v_AdvertisementInfo]
where (0x00001000 & Programflags) != 0