Firefox and Flash Player plugin

[it-mg]

Good morning and a happy new year everyone,

I need a report that shows me all my PCs that have the Flash Plugin installed but no Firefox and vice versa. I tried the code that was posted in this thread but that doesn't seem to do the trick.

Anyone out there who can help me?

Thanks in advance
J.B.

[Daniel_B · Accepted solution]

Since Flash Player for Firefox will appear on the list of Programs and Features (this is not the case for Internet Explorer), you can filter on it using tblSoftware and tblSoftwareUni. The following report might give you the required result.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  Case When Coalesce(tFirefox.AssetID, '') = '' Then 'missing' Else 'installed'
  End As Firefox,
  Case When Coalesce(tFlash.AssetID, '') = '' Then 'missing' Else 'installed'
  End As Flash,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join (Select tblSoftware.AssetID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Where tblSoftwareUni.softwareName Like '%Firefox%') tFirefox
    On tFirefox.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Where tblSoftwareUni.softwareName Like 'Adobe Flash Player%') tFlash
    On tFlash.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And ((Coalesce(tFirefox.AssetID, '') = '' And
      Coalesce(tFlash.AssetID, '') <> '') Or (Coalesce(tFirefox.AssetID, '') <>
      '' And Coalesce(tFlash.AssetID, '') = '')) And tblAssets.Assettype = -1