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
- Re: Computer HostName Character Search With User N...
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-13-2011 08:51 PM
Hello Everyone -
We introduced LANSweeper on my company's domain a little over a month ago. We have found it to be a valuable tool.
Today, my manager asked me if it was possible to create a specific report. I had never made one before, but went to try and saw how in depth the process was.
The report which I was asked to create includes the following:
- Lists all indexed hostnames which match 4 specific characters (plus wildcards used)
- Lists not only the matching hostnames, but the primary users of the computers as well.
What would be the most efficient method to get this created? A report really wouldn't even have to be made if the search results could be set to give more detail (username) by default. Is there a way to do that perhaps?
Thanks!
We introduced LANSweeper on my company's domain a little over a month ago. We have found it to be a valuable tool.
Today, my manager asked me if it was possible to create a specific report. I had never made one before, but went to try and saw how in depth the process was.
The report which I was asked to create includes the following:
- Lists all indexed hostnames which match 4 specific characters (plus wildcards used)
- Lists not only the matching hostnames, but the primary users of the computers as well.
What would be the most efficient method to get this created? A report really wouldn't even have to be made if the search results could be set to give more detail (username) by default. Is there a way to do that perhaps?
Thanks!
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-13-2011 11:35 PM
Example:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username
From tblComputers
Where tblComputers.Computer Like 'abcd%'
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2011 11:35 PM
Example:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username
From tblComputers
Where tblComputers.Computer Like 'abcd%'
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
- Windows 10 O/S version for a specific list of hostnames? in Reports & Analytics
- How to manually import monitors from old database? in General Discussions
- Creating two WSUS/Installed Updates Reports with date issues in Reports & Analytics
- Computer HostName Character Search With User Names - Need Help Creating Report in Reports & Analytics
