
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-27-2017 02:35 PM
Hi Lansweeper Community,
I am creating a report to show a scanned file that has not been found on a computer. However, I am not able to get a valid report because Lansweeper stores previously scanned items in different rows, and tags them with a VersionID.
The report returns two rows for an AssetName. One row has the Found column returning True, and the other one returning False. The only differences would be the time and VersionID fields. This makes it very difficult to know whether or not an item actually exists or doesn't exist on a computer.
Is there any workaround to this that I may be overlooking?
Thanks in advance,
Daniel
I am creating a report to show a scanned file that has not been found on a computer. However, I am not able to get a valid report because Lansweeper stores previously scanned items in different rows, and tags them with a VersionID.
The report returns two rows for an AssetName. One row has the Found column returning True, and the other one returning False. The only differences would be the time and VersionID fields. This makes it very difficult to know whether or not an item actually exists or doesn't exist on a computer.
Is there any workaround to this that I may be overlooking?
Thanks in advance,
Daniel
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2017 05:19 PM
any chance the properties of the file contain a consistent item you can filter against? For example we have an adobe config file with a specific modified date. Filtering by this date allows us to know if the correct cfg file is in place or not-
Where tblFileVersions.FilePathfull Like '%syswow64\macromed\flash\mms.cfg' And
tblFileVersions.LastModified <> '04/20/2016 09:46:19'
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2017 07:08 PM
Hi esr, thank you! Your response sparked an idea, and I realized that, I was querying on a many to many relationship. So I added the following WHERE clause to resolve the issue.
Best,
Daniel
Where tblAssets.AssetID = tblFileVersions.AssetID
Best,
Daniel

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2017 05:19 PM
any chance the properties of the file contain a consistent item you can filter against? For example we have an adobe config file with a specific modified date. Filtering by this date allows us to know if the correct cfg file is in place or not-
Where tblFileVersions.FilePathfull Like '%syswow64\macromed\flash\mms.cfg' And
tblFileVersions.LastModified <> '04/20/2016 09:46:19'

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2017 05:04 PM
Just wanted to bump this.
Thank you! 🙂
Daniel
Thank you! 🙂
Daniel
