Notification

Icon
Error

Software Missing Report - Trying to run report that shows all machines missing software. Works fine when only Windows 10.

Posted: Friday, December 6, 2019 3:02:27 PM(UTC)
Dannnnooo

Dannnnooo

Member Original PosterPosts: 1
0
Like
Hi

I have the following query. It works fine when i change the query to show only Windows 10 (shows they are missing the software), but when i add Windows 7 machines, it shows machines that have the software installed on it! Any ideas? Thanks

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.OSname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Netskope%') And
tsysOS.OSname = 'win 10') Or
(tsysOS.OSname = 'win 7')
Order By tblAssets.AssetName
RC62N
#1RC62N Member Posts: 411  
posted: 12/6/2019 6:09:28 PM(UTC)
Check what you're saying in your WHERE clause.
Code:
Where
  ( tblAssets.AssetID Not In (Select Top 1000000
                                tblSoftware.AssetID
                              From
                                tblSoftware
                                Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
                              Where
                                tblSoftwareUni.softwareName Like '%Netskope%')
    And tsysOS.OSname = 'win 10'
  )
  Or (tsysOS.OSname = 'win 7')

(The computer is running Win10 and is missing the software)
OR (The computer is running Win7, don't care about whether or not the software is present)

Change it to
Code:
Where
  tblAssets.AssetID Not In (Select Top 1000000
                              tblSoftware.AssetID
                            From
                              tblSoftware
                              Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
                            Where
                              tblSoftwareUni.softwareName Like '%Netskope%')
  And (tsysOS.OSname = 'win 10' Or tsysOS.OSname = 'win 7')

(The computer is running either Win10 or Win7) and is missing the software.

Or, if you prefer
Code:
  And tsysOS.OSname IN ('win 10', 'win 7')

Active Discussions

Lansweeper Asset Out of Warranty & Asset Out of Warranty in 60 Days Reports
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 10:29:35 PM(UTC)
Lansweeper Voip Phone to Computer
by  lansend  
Go to last post Go to first unread
Last post: Yesterday at 1:27:10 AM(UTC)
Lansweeper Report Showing custom registry keys scanned
by  impagian   Go to last post Go to first unread
Last post: 1/23/2020 4:01:34 PM(UTC)
Lansweeper Dell Update v3.0
by  gmw158  
Go to last post Go to first unread
Last post: 1/22/2020 5:42:19 PM(UTC)
Lansweeper Report to compare softwareVersion
by  RC62N   Go to last post Go to first unread
Last post: 1/22/2020 4:57:16 PM(UTC)
Lansweeper Dublicate entries (multiple lines with assetname)
by  wkorrubel  
Go to last post Go to first unread
Last post: 1/22/2020 10:10:28 AM(UTC)
Lansweeper Only show string right of character N
by  RC62N   Go to last post Go to first unread
Last post: 1/20/2020 10:36:12 PM(UTC)
Lansweeper Report From Lansweeper For My Company
by  RC62N  
Go to last post Go to first unread
Last post: 1/17/2020 6:59:47 PM(UTC)