Report does not have a file in all Windows 7

[danielk]

Hi,
I have create a custom scan for a file (eg. C:\Support\Data\UCustomData.dat) but how do I generate a report on those Windows 7 that "does not" have this file? please advise. Thanks.

[danielk]

Thanks Susan. It works.

[Susan_A · Accepted solution]

We received and answered this question via email as well. Below is a copy of the response we sent via email, for anyone else interested.

There is a sample file report in our report center, here. Instructions for adding this report to your Lansweeper installation can be found here. You'll need to:

• Insert your own file path into the query.
  
• Add the OS to the report by double-clicking on tblOperatingsystem in the table list on the right and, in the visual representation of the report in the upper section of the report builder, ticking the Caption field in tblOperatingsystem.
  
• Filter the report within the report results. You can specify the OS and specify that you want the machines where the file was not found.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.