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

[Mister_Nobody]

My daily report (you must enable process scnannig):

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tsysOS.OSname,
  tblAssets.Domain,
  tblAssets.Username,
  tblADusers.Displayname,
  tblADusers.Department,
  tblADusers.Title,
  tblADusers.Company,
  tblProcesses.ExecutablePath,
  tblProcesses.Caption,
  tblProcesses.Lastchanged
From tblAssets
  Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetID And
      (Lower(tblProcesses.Caption) In ('sol.exe', 'mlines24.exe', 'hwd3.exe',
        'bs4.exe', 'elka.exe', 'lines.exe', 'king3.exe', 'click.exe',
        'mosaic.exe', 'durbetsel.exe', 'cards.exe', 'semechki.exe',
        'nardy20.exe') Or Lower(tblProcesses.ExecutablePath) Like '%cradle%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%шар%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%дурак%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%кубик%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%пазл%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%косынк%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%кинг%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%преферанс%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%маджонг%' Or
        Lower(tblProcesses.ExecutablePath) Like '%mahjon%' Or
        Lower(tblProcesses.ExecutablePath) Like '%uzzl%' Or
        Lower(tblProcesses.ExecutablePath) Like '%cubes%' Or
        Lower(tblProcesses.ExecutablePath) Like '%pinball%' Or
        Lower(tblProcesses.ExecutablePath) Like '%fight%' Or
        Lower(tblProcesses.ExecutablePath) Like '%chicken%' Or
        Lower(tblProcesses.ExecutablePath) Like '%blocks%' Or
        Lower(tblProcesses.ExecutablePath) Like '%1000.exe' Or
        Lower(tblProcesses.ExecutablePath) Like '%durak.exe' Or
        Lower(tblProcesses.ExecutablePath) Like '%toydef%' Or
        Lower(tblProcesses.ExecutablePath) Like '%bugs%' Or
        Lower(tblProcesses.ExecutablePath) Like '%desyatka%' Or
        Lower(tblProcesses.ExecutablePath) Like '%tetris%' Or
        Lower(tblProcesses.ExecutablePath) Like '%balls%' Or
        Lower(tblProcesses.ExecutablePath) Like '%domino%' Or
        Lower(tblProcesses.ExecutablePath) Like '%craft%' Or
        Lower(tblProcesses.ExecutablePath) Like '%marriage%' Or
        Lower(tblProcesses.ExecutablePath) Like '%kyodai%' Or
        Lower(tblProcesses.ExecutablePath) Like '%hearts%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%игр%' Or
        Lower(tblProcesses.ExecutablePath) Like '%game%' Or
        Lower(tblProcesses.ExecutablePath) Like '%alawar%' Or
        Lower(tblProcesses.ExecutablePath) Like '%farm%' Or
        Lower(tblProcesses.ExecutablePath) Like '%moorhuhn%' Or
        Lower(tblProcesses.ExecutablePath) Like '%happy%' Or
        Lower(tblProcesses.ExecutablePath) Like '%zuma%' Or
        Lower(tblProcesses.ExecutablePath) Like 'spider%' Or
        Lower(tblProcesses.ExecutablePath) Like '%solitaire%' Or
        Lower(tblProcesses.ExecutablePath) Like '%monopoly%' Or
        Lower(tblProcesses.ExecutablePath) Like '%tanks%' Or
        Lower(tblProcesses.ExecutablePath) Like '%tanki%' Or
        Lower(tblProcesses.ExecutablePath) Like '%yeti%' Or
        Lower(tblProcesses.ExecutablePath) Like '%craft%' Or
        Lower(tblProcesses.ExecutablePath) Like '%lineage%' Or
        Lower(tblProcesses.ExecutablePath) Like '%prince%' Or
        Lower(tblProcesses.ExecutablePath) Like N'%янс%' Or
        Lower(tblProcesses.ExecutablePath) Like 'N%уголки%')
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode And
      tblAssets.OScode Not Like '%s'
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
      tblADusers.Userdomain = tblAssets.Domain
Where tblProcesses.Lastchanged > GetDate() - 1

[KrisjohnTwin]

Note that "Primera Technology" sells label printers, so your Prime% match isn't ideal.