cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Andy_Sismey
Champion Sweeper III
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
2 REPLIES 2
Mister_Nobody
Honored Sweeper II

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
Engaged Sweeper

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