→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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%'

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now