→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now