Notification

Icon
Error

Unauthorized Software Query how to add Whatsapp? - How to add a Software which isnt in the "Unauthorized" list

Posted: Thursday, April 22, 2021 8:18:47 PM(UTC)
QueryLSTech

QueryLSTech

Member Original PosterPosts: 4
0
Like
Hello, I do have this query which is quite good, to check unauthorized apps in our machines, but I can see there is a few apps missing like "Whatsapp" for example. How can we add a software to this table tblSoftwareUni.softwareName?

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.Added,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Right Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tblSoftwareHist On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Not Like '%Power Automate Desktop%' And
tblSoftwareUni.softwareName Not Like '%Dell Optimizer Service%' And
tblSoftwareUni.softwareName Not Like '%Adobe Genuine Service%' And
tblSoftwareUni.softwareName Not Like
'%Aplikacje Microsoft 365 dla przedsiębiorstw - pl-pl.proof%' And
tblSoftwareUni.softwareName Not Like
'%Aplicaciones de Microsoft 365 para empresas - es-es.proof%' And
tblSoftwareUni.softwareName Not Like
'%Aplikacje Microsoft 365 dla przedsiębiorstw - pl-pl%' And
tblSoftwareUni.softwareName Not Like
'%Dell Update - SupportAssist Update Plugin%' And
tblSoftwareUni.softwareName Not Like
'%Aplicaciones de Microsoft 365 para empresas - es-es%' And
tblSoftwareUni.softwareName Not Like
'%Nagyvállalati Microsoft 365-alkalmazások - hu-hu%' And
tblSoftwareUni.softwareName Not Like
'%Εφαρμογές Microsoft 365 για μεγάλες επιχειρήσεις - el-gr%' And
tblSoftwareUni.softwareName Not Like
'%Приложения на Microsoft 365 за предприятия - bg-bg%' And
tblSoftwareUni.softwareName Not Like
'%Microsoft 365“ programos įmonėms - lt-lt%' And
tblSoftwareUni.softwareName Not Like
'%Programi Microsoft 365 za podjetja - sl-si%' And
tblSoftwareUni.softwareName Not Like
'%Aplikácie Microsoft 365 pre veľké organizácie - sk-sk%' And
tblSoftwareUni.softwareName Not Like
'%Aplicații Microsoft 365 pentru întreprindere - ro-ro%' And
tblSoftwareUni.softwareName Not Like
'%Aplicații Microsoft 365 pentru întreprindere - ro-ro%' And
tblSoftwareUni.softwareName Not Like
'%Εφαρμογές Microsoft 365 για μεγάλες επιχειρήσεις - el-gr%' And
tblSoftwareUni.softwareName Not Like
'%Приложения на Microsoft 365 за предприятия - bg-bg%' And
tblSoftwareUni.softwareName Not Like '%Aplicații%' And
tblSoftwareUni.softwareName Not Like '%Εφαρμογές%' And
tblSoftwareUni.softwareName Not Like '%Приложения%' And tblSoftwareUni.Added >
GetDate() - 365 And SubString(tblSoftwareUni.softwareName, 1, 10) Not In
(Select SubString(tblSoftwareUni.softwareName, 1, 10) From tblSoftwareUni
Where tblSoftwareUni.Added < GetDate() - 365) And
tblSoftwareUni.SoftwarePublisher Is Not Null And tblState.Statename = 'Active'
Order By tblSoftwareUni.Added Desc,
tblAssets.AssetName

Also I've tried do run this https://www.lansweeper.c...thorized-software-audit/ but nothing comes up.

Thanks

Active Discussions

Lansweeper Ticket Content Default Value
by  CPG   Go to last post Go to first unread
Last post: Yesterday at 8:45:12 PM(UTC)
Lansweeper New status to mimic Closed
by  chris.anderson  
Go to last post Go to first unread
Last post: Yesterday at 7:14:27 PM(UTC)
Lansweeper Active Directory Groups not scanned properly
by  cross_eur   Go to last post Go to first unread
Last post: Yesterday at 5:45:00 PM(UTC)
Lansweeper Change Management - Voting and Tracking
by  brodiemac-too  
Go to last post Go to first unread
Last post: Yesterday at 2:48:01 PM(UTC)
Lansweeper No incoming Mails after update 8.4.100.9
by  EDELL   Go to last post Go to first unread
Last post: Yesterday at 2:38:50 PM(UTC)
Lansweeper Anti-Virus on Mac
by  Ian.Prentice  
Go to last post Go to first unread
Last post: Yesterday at 9:30:32 AM(UTC)
Lansweeper how to scan intune managed win10 clients?
by  brodiemac-too   Go to last post Go to first unread
Last post: 7/27/2021 9:17:07 PM(UTC)
Lansweeper Sort by in Helpdesk
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/27/2021 9:15:05 PM(UTC)