→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
03-24-2022 03:48 PM
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
06-09-2023 06:50 AM - edited 06-09-2023 06:50 AM
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
06-09-2023 04:47 AM
Note that "Primera Technology" sells label printers, so your Prime% match isn't ideal.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now