This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!
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
- Re: All assets report?
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
‎01-08-2016 03:03 PM
Looking through the reports I don't see one that will list everything captured in Lansweeper. Is there a report that will display all assets with their installed software etc?
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
‎01-13-2016 09:24 PM
To create a basic report that lists all (active) assets, open the report builder under Reports\Create New Report, give the default report that is generated a title and hit Save & Run. For software, there are some built-in reports in the Reports tab.
Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.
Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-13-2016 09:24 PM
To create a basic report that lists all (active) assets, open the report builder under Reports\Create New Report, give the default report that is generated a title and hit Save & Run. For software, there are some built-in reports in the Reports tab.
Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.
Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.
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
- New Year = New Discoveries Discussion! 🚀 in General Discussions
- LS on-prem asset filtering options in General Discussions
- Delete assets with "NEW" IT/OT sensor in Product Discussions
- Report for trendmicro instaleld assets in Reports & Analytics
- Asset model differences between Classic and Sites in General Discussions
