Notification

Icon
Error

PCs not appearing in report when searching for software - Asset shows installed software, but does not appear in report when searching for the software

Posted: Friday, November 1, 2019 9:04:15 PM(UTC)
t_edwards

t_edwards

Member Original PosterPosts: 1
0
Like
We're trying to track down which PCs have a particular piece of software installed on them. The scanned asset, when clicked on and browsing the software menu, will show the software is installed, version number, publisher, etc. When running a software report and searching the publisher or software name field for the software it does not show the workstation.

The report shows the asset with the software installed and a report run being narrowed down by "Toad", the software we're looking for. What is missing in the report that's causing it to only show certain devices?

Here is the report:

Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Username,
  tblSoftwareUni.SoftID,
  tblSoftwareUni.softwareName,
  tblSoftwareUni.SoftwarePublisher,
  tblSoftware.Installdate,
  tblSoftware.softwareVersion
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 tblAssetCustom.State = 1


JacobH
#1JacobH Member Posts: 175  
posted: 11/3/2019 11:16:49 PM(UTC)
Try running the query without the WHERE clause - perhaps the asset you are looking for is not set to 'active' state.

Active Discussions

Lansweeper HPE SAS Solid State Drives failure report
by  Tommy75   Go to last post Go to first unread
Last post: Today at 8:04:05 AM(UTC)
Lansweeper Software Missing Report
by  RC62N  
Go to last post Go to first unread
Last post: 12/6/2019 6:09:28 PM(UTC)
Lansweeper Assets without Asset Location
by  JLangthaler   Go to last post Go to first unread
Last post: 12/5/2019 12:44:19 PM(UTC)
Lansweeper Installed Memory report
by  lansend  
Go to last post Go to first unread
Last post: 12/2/2019 8:15:53 PM(UTC)
Lansweeper Custom OID Report
by  bramassendorp   Go to last post Go to first unread
Last post: 12/2/2019 4:42:48 PM(UTC)
Lansweeper Report thats showing Windows machines when AV is not like =
by  RC62N  
Go to last post Go to first unread
Last post: 11/28/2019 5:56:51 PM(UTC)
Lansweeper dhcp addresses available
by  Cesco93  
Go to last post Go to first unread
Last post: 11/28/2019 2:56:02 PM(UTC)