This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Workstation reports inconsistencies
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-19-2016 03:01 PM
Hello all. So I made a copy of the built in "All Workstations" report, and added and rearranged some fields. It seems to be all okay except for one thing. I compared the results of my report to the built in report, and it shows about 10 less workstations. I searched these workstations in lansweeper and they are active and online.
Why would my report be so much different than the built in one? All I did was add fields and moved them around, that shouldn't change the results... right?
Why would my report be so much different than the built in one? All I did was add fields and moved them around, that shouldn't change the results... right?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2016 01:10 AM
If you add tables, this can reduce the result count, even if you didn't add filters. By default, SQL only displays a record in the report output if there is a record in both linked tables. This is standard SQL behavior, not specific to Lansweeper. If you link a table that a computer doesn't have a record in, that computer will no longer be listed. You can right-click on all links between tblAssets and other tables and tick "select all rows from tblAssets" to force all assets in tblAssets to be displayed.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2016 01:10 AM
If you add tables, this can reduce the result count, even if you didn't add filters. By default, SQL only displays a record in the report output if there is a record in both linked tables. This is standard SQL behavior, not specific to Lansweeper. If you link a table that a computer doesn't have a record in, that computer will no longer be listed. You can right-click on all links between tblAssets and other tables and tick "select all rows from tblAssets" to force all assets in tblAssets to be displayed.
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Need Report for LS Cloud: All Workstations with users, e-mail address, department etc. in Reports & Analytics
- Workstations with No Biometric Hardware Report in Reports & Analytics
- ‌‌‌‌Enhancing Software Management: Introducing Data Enrichment in Product Discussions
- Report on all Workstations & Servers without Windows Defender enabled/installed in Reports & Analytics
- Unified Write Filter Status in Deployment Packages
