Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2022 06:06 PM
Hi all, New to LanSweeper.
I've created a Asset Identification Report, and would like to include BIOS age of computers to the report.
If I add/link tblBIOS to the report, the report now only shows PC (or assets that have a BIOS).
Is there a way to add the table, so that its not compulsory, and only show tblBIOS.ReleaseDate if it exists?
Thanks in Advance
I've created a Asset Identification Report, and would like to include BIOS age of computers to the report.
If I add/link tblBIOS to the report, the report now only shows PC (or assets that have a BIOS).
Is there a way to add the table, so that its not compulsory, and only show tblBIOS.ReleaseDate if it exists?
Thanks in Advance
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
‎02-07-2022 03:58 PM
More than likely you're INNER JOINing the table to your report; that's the default for the LANSweeper report editor. Change that to a LEFT JOIN.
W3Schools.com on SQL joins
Simplified version:
INNER JOIN: show me only records that have an entry in the joined table.
LEFT JOIN: show me all records. If there's entry in the joined table, show me that, too.
W3Schools.com on SQL joins
Simplified version:
INNER JOIN: show me only records that have an entry in the joined table.
LEFT JOIN: show me all records. If there's entry in the joined table, show me that, too.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2022 10:24 AM
Thanks you
That fixed my issue.
As you can guess, I only have very little db experience.
That fixed my issue.
As you can guess, I only have very little db experience.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2022 03:58 PM
More than likely you're INNER JOINing the table to your report; that's the default for the LANSweeper report editor. Change that to a LEFT JOIN.
W3Schools.com on SQL joins
Simplified version:
INNER JOIN: show me only records that have an entry in the joined table.
LEFT JOIN: show me all records. If there's entry in the joined table, show me that, too.
W3Schools.com on SQL joins
Simplified version:
INNER JOIN: show me only records that have an entry in the joined table.
LEFT JOIN: show me all records. If there's entry in the joined table, show me that, too.