→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Excalibur
Engaged Sweeper
I was trying to create a dynamic asset group for all Mozilla Firefox version, and wanted to use some type of wild card instead of listing each out. What I am trying to accomplish is to list all computer with Firefox that do not have the most current version of Flash.


Thanks in advance for the help.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
With dynamic asset groups you can't list assets having a specific software but not a specific version installed. For this you need to use a custom report. The following example report lists assets having Firefox installed and Flash Player with a version below 18.x.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tFlash.softwareVersion As [Flash version]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select tblSoftware.AssetID,
tblSoftware.softwareVersion
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'adobe flash%') tFlash
On tFlash.AssetID = tblAssets.AssetID
Where tblAssets.AssetID In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Mozilla firefox%') And
tFlash.softwareVersion Not Like '18.%' And tblAssetCustom.State = 1

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
With dynamic asset groups you can't list assets having a specific software but not a specific version installed. For this you need to use a custom report. The following example report lists assets having Firefox installed and Flash Player with a version below 18.x.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tFlash.softwareVersion As [Flash version]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select tblSoftware.AssetID,
tblSoftware.softwareVersion
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'adobe flash%') tFlash
On tFlash.AssetID = tblAssets.AssetID
Where tblAssets.AssetID In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Mozilla firefox%') And
tFlash.softwareVersion Not Like '18.%' And tblAssetCustom.State = 1

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now