File Scan Report shows no results

[apap]

We set up a new file scan, that works but the file scan report shows no results. Our other file scan reports seem to work fine.
Any ideas as to why and what we might do to fix this problem?

We currently have about 40 nodes that show that the file is found:
File 4
Found: True
Full Path: c:\o365\setup.exe
Version: 16.0.8311.3600
Company: Microsoft Corporation
Size: 4241096
CreationDate: 11/20/2017 10:43:13
LastAccessed: 11/20/2017 10:43:13
LastModified: 11/07/2017 18:23:00

But the report (Scanning->File and Registry Scanning -> Report) shows nothing:
This report has no results!

Thanks

[apap · Accepted solution]

Thanks for the info Bruce

We have fixed the problem.
The link to the report had a '+' in the name: @name=+C%3a%5co365%5csetup.exe

I deleted and reentered the name of the file we are scanning for and the '+' dissapeared and the report link works fine.

Not sure where the '+' came from, it did not appear in the text and the file scans were all working.

Thanks again for the help and your time.

~ Andrew

[Bruce_B]

The report that runs when clicking the Report button next to a file name is a report that has a Where clause auto-completed using a variable contained in the report url, containing the file name of the file in question. This dynamic report should in effect be identical to a manual file scanning report, the only difference being how the where clause is inserted.

I did some testing with the exact same file path as you're using in Lansweeper version 6.0.100.87 and found no issue calling up the automatically generated report. It's not entirely clear to me what could cause it to fail as it's pretty straight forward.

If you haven't yet, update your Lansweeper installation to the latest version. If the issue persists in the latest version, please contact us via email at support@lansweeper.com so we can investigate further. When contacting support please provide the following:

• A description of the issue.
  
• Errorlog.txt which can be found in the Service folder in the Lansweeper installation folder
  
• Screenshots of the entire browser window of the report output for both the automatically generated report and a custom report containing a filter for the specific file path

Select tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets.Domain,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged,
TsysLastscan.Lasttime As [Last scanned]
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysLastscan.CFGcode = TsysWaittime.CFGCode
Where tblFileVersions.FilePathfull Like @name And TsysWaittime.CFGname = 'FILES'
And tblFileVersions.Found = 1

[apap]

Using the built in report, Windows: File Scanning results, we can filter our report (showing the file installed on 146 nodes). Still nothing from the Scanning -> File and Registry Scanning report link.

Curious what the problem maybe but filtering on the built in report does give us the report we need.

~ Andrew

[apap]

I have tried that.
We do see the file has been scanned and the information shows when viewed in the LS display on individual nodes.
( Config -> Scanned Info -> File Info )
File 3
Found: True
Full Path: c:\minisoft\secure92\sessions\idocm.s92
Size: 6009
CreationDate: 05/15/2017 16:08:00
LastAccessed: 06/26/2017 10:35:30
LastModified: 05/15/2017 16:08:00
File 4
Found: True
Full Path: c:\o365\setup.exe
Version: 16.0.8311.3600
Company: Microsoft Corporation
Size: 4241096
CreationDate: 11/20/2017 10:43:13
LastAccessed: 11/20/2017 10:43:13
LastModified: 11/07/2017 18:23:00


Nothing ever shows in the report from the Scanning -> File and Registry Scanning tab.
Scan for file: C:\o365\setup.exe (0)
AssetName Domain FilePathfull FileVersion CompanyName Filesize CreationDate LastAccessed LastModified Lastchanged Last scanned

This report has no results!

[Bruce_B]

Depending on when you've set up scanning for this specific file, your Windows computer assets may yet not have been scanned for this information. I'd recommend calling up the asset page of a computer you're sure has this file and clicking the Rescan Asset button in the left-hand pane. Once the scan is complete check the Config\Scanned info\File info tab of the computer's asset page, the information should be there at that point.

To quickly rescan all your Windows computers to update this information you can go to the Assets\Windows tab and click the Rescan button on the left.