Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BzowK
Engaged Sweeper
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Example:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username
From tblComputers
Where tblComputers.Computer Like 'abcd%'

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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