Support Center
Knowledgebase Contact Support
Search our knowledgebase

How to create a report based on scanned file information

Last updated on December 02 2014

In the example below we want to retrieve the file version of iexplore.exe, an Internet Explorer executable, across our various Windows computers. We already know that the executable’s file path is the one below, but want to retrieve the file’s properties across our entire network.

PROGRAM FILES (X86)\INTERNET EXPLORER\IEXPLORE.EXE

 

To scan for this specific file, do the following:

  • Browse to the following section of the Lansweeper web console: Configuration\Scanning Setup\Item Wait Time

  • Make sure that the Enabled checkbox is ticked for the FILES item, indicating that file scanning is enabled.

  • Browse to the following section of the Lansweeper web console: Configuration\Scanning Setup\Custom Scanning

  • Hit the Add files to scan button in the File Scanning section of the page.
  • Enter the file path of the file you want to scan into the popup window and hit Ok

  • Rescan your assets by clicking the Assets link at the top of the web console, ticking the checkboxes in front of the assets and hitting the Rescan button on the left.

  • To view the scan results for a single asset, browse to the following section of the asset’s webpage: Config\Scanned info\File info

  • To view the scan results for all of your assets, run the report below and replace iexplore.exe with the name of any file you’ve submitted for scanning.

    Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblFileVersions.Found, tblFileVersions.FilePathfull, tblFileVersions.FileVersion, tblFileVersions.CompanyName, tblFileVersions.Filesize, tblFileVersions.CreationDate, tblFileVersions.LastAccessed, tblFileVersions.LastModified, tblFileVersions.Lastchanged From tblAssets Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Where tblFileVersions.FilePathfull Like '%iexplore.exe' And tblAssetCustom.State = 1 Order By tblAssets.AssetUnique, tblFileVersions.FilePathfull