→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TylerO
Engaged Sweeper II
We are deploying an Outlook plug-in to our users. I would like to deploy it to all computers using Office 365, that don't already have the plug-in. The report that I've built below only returns computers with Office365, but doesn't filter out the computers that already have the plug-in. Where am I going wrong?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Microsoft Office 365%' And
tblSoftwareUni.softwareName Not Like 'EMS for Outlook'
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
tblSoftwareUni.softwareName Not Like 'EMS for Outlook'
Will return all software which does not match that string. This means that it will pretty much return all software you have on the asset.

I would the report in this topic: https://www.lansweeper.com/Forum/yaf_postst10306_Windows-computers-that-do-not-have-a-specific-software-installed.aspx

I You can then add the software which you do want to have installed to it. I think the query below should work.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%EMS for Outlook%') And
tblSoftwareUni.softwareName Like 'Microsoft Office 365%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

View solution in original post

3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee
tblSoftwareUni.softwareName Not Like 'EMS for Outlook'
Will return all software which does not match that string. This means that it will pretty much return all software you have on the asset.

I would the report in this topic: https://www.lansweeper.com/Forum/yaf_postst10306_Windows-computers-that-do-not-have-a-specific-software-installed.aspx

I You can then add the software which you do want to have installed to it. I think the query below should work.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%EMS for Outlook%') And
tblSoftwareUni.softwareName Like 'Microsoft Office 365%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
TylerO
Engaged Sweeper II
Thanks Charles.X! That makes perfect sense about it returning all software. This solution works perfectly.
Jeyabal
Engaged Sweeper
TylerO wrote:
Thanks Charles.X! That makes perfect sense about it returning all software. This solution works perfectly.



How to exclude language packs?