This website uses cookies. By clicking Accept, you consent to the use of cookies.
Click Here
to learn more about how we use cookies.
Accept
Reject
Browse
Welcome Center
Community Blog
Community Resources
Contests and Giveaways
Lansweeper Excellence Awards
Cybersecurity Challenge
Lansweeper SysAdmin Day 2024 Giveaway
Lansweeper Integration Challenge
Asset Discovery Challenge
The Lounge (for New Users)
Forum
Blog
Events
Forums
General Discussions
Open Office Hours Q&A
Reports & Analytics
Product Discussions
Deployment Packages
Product Announcements
Archive
Knowledge Center
Knowledge Base
Requirements
Installation
Troubleshooting your installation
Scanning your network
Troubleshooting Scanning Issues
Customizing the Web Console
Managing Assets
Lansweeper Maintenance
Troubleshooting
Deploying Software & Other Changes
Configuring & Using the Helpdesk
Managing Software
Managing Licenses
Managing Users
Actions
Reporting
Billing-related Questions
Lansweeper OT
Sites
Diagrams
Cyber Security and Risk Insights
Integrations
Pro Tips
Quick Tech Solutions
Support Portal
Training
Installing Lansweeper
Lansweeper Fundamentals Course
Resources
Vulnerability Audit Reports
End of Life Updates
Patch Tuesday Updates
Events and Webinars
Events
Virtual Office Hours
Participate in Product Research
About the Programs
Open Programs
Lansweeper.com
Developer Portal
Lansweeper Community
Lansweeper.com
Developer Portal
Community FAQ
Register | Log In
Welcome Center
Community Blog
Community Resources
Contests and Giveaways
Lansweeper Excellence Awards
Cybersecurity Challenge
Lansweeper SysAdmin Day 2024 Giveaway
Lansweeper Integration Challenge
Asset Discovery Challenge
The Lounge (for New Users)
Forum
Blog
Events
Forums
General Discussions
Open Office Hours Q&A
Reports & Analytics
Product Discussions
Deployment Packages
Product Announcements
Archive
Knowledge Center
Knowledge Base
Requirements
Installation
Troubleshooting your installation
Scanning your network
Troubleshooting Scanning Issues
Customizing the Web Console
Managing Assets
Lansweeper Maintenance
Troubleshooting
Deploying Software & Other Changes
Configuring & Using the Helpdesk
Managing Software
Managing Licenses
Managing Users
Actions
Reporting
Billing-related Questions
Lansweeper OT
Sites
Diagrams
Cyber Security and Risk Insights
Integrations
Pro Tips
Quick Tech Solutions
Support Portal
Training
Installing Lansweeper
Lansweeper Fundamentals Course
Resources
Vulnerability Audit Reports
End of Life Updates
Patch Tuesday Updates
Events and Webinars
Events
Virtual Office Hours
Participate in Product Research
About the Programs
Open Programs
All community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Lansweeper Community
Forums
Archive
Report for assets not assigned to users
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
Report for assets not assigned to users
bcaulkins
Engaged Sweeper
Options
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
08-07-2017
11:04 PM
I need some help with creating this. My SQL is not that great.
I am trying to get a report to see which assets have not been assigned a user yet.
I found a report on the site to show which have been, but I need the opposite.
Thanks in advance.
Labels:
Labels:
Report Center
All forum topics
Previous Topic
Next Topic
0 REPLIES
0
Post Reply
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
Auto-assigning assets to LSAgent groups based on attributes like IP – is it planned?
in
Open Office Hours Q&A
Tuesday
Report for Local Administrator accounts on All Assets
in
Reports & Analytics
a week ago
Lansweeper Community Highlights - November 2024
in
General Discussions
a week ago
Enhance Employee Experience with Lansweeper + Jira
in
General Discussions
2 weeks ago
Understanding how cloud syncing works
in
General Discussions
11-18-2024