Dynamic Asset/Report Wildcard Use?

[Excalibur]

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.

[Daniel_B · Accepted solution]

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