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.com/report/unauthorized-software-audit/ but nothing comes up.
Thanks
