Software Report Not Showing All Assets

[E-Dub]

Version: 5305. Updated to 5308 and same issue.

When I view a specific software via it's version or name I get the list of which assets have it installed.
This list is incomplete because when I go to a specific asset not listed in the software reports it shows that this software is installed. Same name, same version. I've rescanned but no luck. This is on multiple assets.
I use these reports often to determine who needs updating but this is a brand new software install.

[E-Dub]

The checkbox checked 'Automatically make non-active assets active when they are rescanned' wasn't set..oddly enough.

This should clear it up the issue.

[Daniel_B · Accepted solution]

Either you are looking only on a specific software version, but the other computers have another version of the software installed, or the other computers are not in Active state. Most web console pages and built-in reports will only list assets in State Active. The following report could help you to filter on a specific software name and listing all versions which are present in your network.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblSoftwareUni.softwareName,
  tblSoftwareUni.SoftwarePublisher,
  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 tblSoftwareUni.softwareName Like '%example software%' And
  tblAssetCustom.State = 1