Installed Windows Features

List all Installed Windows Features

Get an overview of all installed Windows features within your environment. When Lansweeper scans a Windows machine, the installed features are also retrieved. This overview report lists all the installed features per computer. By using the sorting options you sort each column to find computers with specific features installed. Additionally, you can use the filtering to find specific computers or services.

Installed Windows features

Installed Windows Features Query

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When Chrome.softID Is Null Then '-'
    Else 'Installed'
  End As Chrome,
  Case
    When Edge.AssetID Is Null Then '-'
    Else 'Installed'
  End As Edge,
  Case
    When FireFox.softID Is Null Then '-'
    Else 'Installed'
  End As Firefox,
  Case
    When InternetExplorer.softID Is Null Then '-'
    Else 'Installed'
  End As InternetExplorer,
  Case
    When Opera.softID Is Null Then '-'
    Else 'Installed'
  End As Opera,
  Case
    When Safari.softID Is Null Then '-'
    Else 'Installed'
  End As Safari
From tblAssets
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join (Select tblSoftware.AssetID,
        tblSoftware.softID
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like 'Windows Internet Explorer%') As
  InternetExplorer On InternetExplorer.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
        tblSoftware.softID
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Mozilla Firefox%') As FireFox On
    FireFox.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
        tblSoftware.softID
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Google Chrome%') As Chrome On
    Chrome.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
        tblSoftware.softID
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Safari%') As Safari On
    Safari.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
        tblSoftware.softID
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like 'Opera%') As Opera On
    Opera.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblFileVersions.AssetID
      From tblFileVersions
      Where
        tblFileVersions.FilePathfull Like
        '%\SystemApps\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\MicrosoftEdge.exe'
        And Case tblFileVersions.Found
          When 0 Then 'No'
          When 1 Then 'Yes'
        End = 'Yes') Edge On Edge.AssetID = tblAssets.AssetID
Where tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename In
  ('Windows', 'Windows CE')
Order By tblAssets.Domain,
  tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting