cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
E-Dub
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
E-Dub
Engaged Sweeper
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
Lansweeper Alumni
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