Notification

Icon
Error

Report that shows two pieces of software

Posted: Wednesday, May 23, 2018 9:15:42 PM(UTC)
TylerO

TylerO

Member Original PosterPosts: 4
0
Like
This issue has been solved! Click here to view the solution
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'
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 5/28/2018 3:58:42 PM(UTC)
Code:
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.c...-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.

Code:
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
#2TylerO Member Original PosterPosts: 4  
posted: 5/28/2018 6:34:38 PM(UTC)
Thanks Charles.X! That makes perfect sense about it returning all software. This solution works perfectly.
Jeyabal
#3Jeyabal Member Posts: 1  
posted: 10/18/2019 1:14:52 AM(UTC)
Originally Posted by: TylerO Go to Quoted Post
Thanks Charles.X! That makes perfect sense about it returning all software. This solution works perfectly.



How to exclude language packs?

Active Discussions

Lansweeper NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)