Report On Gaming Applications Installed On Corporate Devices (v1)

[Andy_Sismey]

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblassets.Username,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  Games.softwareName As [software Name],
  Games.SoftwarePublisher As [Software Publisher]
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Right Join (Select tblSoftware.AssetID,
      tblSoftwareUni.softwareName,
      tblSoftwareUni.SoftwarePublisher
    From lansweeperdb.dbo.tblSoftware
      Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
    Where (tblSoftwareUni.SoftwarePublisher Like 'Instant Gaming%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Firestorm%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Epic%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Bluestack%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Electronic%Arts' Or
        tblSoftwareUni.SoftwarePublisher Like 'Mojang%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Tencent%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Activision%' Or
        tblSoftwareUni.SoftwarePublisher Like 'King%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nintendo%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Ubisoft%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Sega%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Zynga%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Square%Enix' Or
        tblSoftwareUni.SoftwarePublisher Like 'Android%' Or
        tblSoftwareUni.SoftwarePublisher Like 'LD%Player%' Or
        tblSoftwareUni.SoftwarePublisher Like 'archon%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Bliss%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Gameloop%' Or
        tblSoftwareUni.SoftwarePublisher Like 'GenyMotion%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Memu%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nox%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Phoenix Fire%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Prime%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Remix%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Xamarin%' Or
        tblSoftwareUni.SoftwarePublisher Like 'VirtualBox%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Razer%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Galaxy%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Activision%' Or
        tblSoftwareUni.SoftwarePublisher Like 'ZeptoLab%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Rovio%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Playlab%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Microsoft%Studios%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Disney%' Or
        tblSoftwareUni.SoftwarePublisher Like 'GameHouse%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Chillingo%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Ketchapp%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nanovation%Labs%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Appsolute%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Ayopa%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Gameloft%' Or
        tblSoftwareUni.SoftwarePublisher Like 'PlayPlayFun%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Miniclip%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Hipster%Whale%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Digital Tribe%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Big%Fish%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Tamatem%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Double%Fine%Presents%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Fellow%Traveler%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Game%Insight%' Or
        tblSoftwareUni.SoftwarePublisher Like 'NetEase%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nkidu%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Galactic%Thumb%' Or
        tblSoftwareUni.SoftwarePublisher Like 'tinyBuild%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Wadjet%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Headup%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Storm8%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Square%' Or
        tblSoftwareUni.SoftwarePublisher Like 'FunPlus%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Publishing%Plus%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Team%17%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Finji%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Versus%Evil%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Reverb%Communications%'
        Or tblSoftwareUni.SoftwarePublisher Like 'SteakSteak%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Wargaming%Labs%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nekki%' Or
        tblSoftwareUni.SoftwarePublisher Like 'HeroCraft%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Creative%Mobile%' Or
        tblSoftwareUni.SoftwarePublisher Like 'FDG%Entertainment%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Crystal%Clear%Soft%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Devolver%Digital%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Zillion%Whales%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nevosoft%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Garden%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Gameevil%' Or
        tblSoftwareUni.SoftwarePublisher Like 'PikPok%' Or
        tblSoftwareUni.SoftwarePublisher Like 'G5%Entertainment%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Renatus%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Yodo1%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Armor%' Or
        tblSoftwareUni.SoftwarePublisher Like '6Waves%' Or
        tblSoftwareUni.SoftwarePublisher Like 'TabTale%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Crescent%Moon%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Alawar%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Kongregate%' Or
        tblSoftwareUni.SoftwarePublisher Like 'GamesInFlames%' Or
        tblSoftwareUni.SoftwarePublisher Like 'FGL%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Nova Games%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Mail.Ru%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Kizi%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Indie%Fund%' Or
        tblSoftwareUni.SoftwarePublisher Like 'Blizzard Entertainment%' Or
        tblSoftwareUni.SoftwarePublisher Like '%interactive%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Namco%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Nexon%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Netmarble%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Konami%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Capcom%' Or
        tblSoftwareUni.SoftwarePublisher Like '%Embracer%')) Games On
      Games.AssetID = tblassets.AssetID
Where tblassetcustom.State = 1