cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
manelnas
Engaged Sweeper II
Hello,
from the button "Software" I can see all software found in my Assets list.
Is it possible have a report of Software that lasweeper found only in a specific Asset Group?

Regards
2 REPLIES 2
Argon0
Champion Sweeper
Hi, great, been using this for a little while against a couple of Static Asset groups. Have just started using Dynamic Asset groups, and it doesn't work with them.

If you add the Dynamic and Builtin (bit) fields, you can see that it shows just the Static groups (i.e. Dynamic is always False).

Is there another table which stores Dynamic Group info? Can you help me create a report to show Software installed by Dynamic Group?

Thanks in advance.
Esben_D
Lansweeper Employee
Lansweeper Employee
If you have a dynamic asset group, you can add software installed as a filter. If that doesn't work for you, you can always use the built in report "Windows: Installed software by computer" and add tblAssetGroups to the report, you can then specify which asset group you want the report to filter on.

Basically change the highlighter SQL code below with the name of your asset group and you should be all set.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetGroups.AssetGroup,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftware.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'myassetgroup' And tblState.Statename =
'Active'
Order By tblAssets.Domain,
tblAssets.AssetName,
Software