
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2015 09:14 AM
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.
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2015 01:54 PM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2015 01:54 PM
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
