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
Community FAQ
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: 
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: 

Member Servers Report

Go to solution
kevinoie
Engaged Sweeper III

‎10-11-2010 07:16 PM

Hi. I have a problem with my report "all Member Servers" When I run the report I am getting ALL PC's and SERVERS on my network. Can anyone give me the original code for running this report. I would be very grateful for any assistance..

Labels:
0 Kudos
1 ACCEPTED SOLUTION
Go to solution
Hemoco
Lansweeper Alumni

‎10-11-2010 07:59 PM 

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole = '3' Order By dbo.tblComputers.Computer

View solution in original post

2 REPLIES 2
Go to solution
kevinoie
Engaged Sweeper III

‎10-12-2010 11:31 AM

Thats great.. Thanks a million..
0 Kudos
Go to solution
Hemoco
Lansweeper Alumni

‎10-11-2010 07:59 PM 

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole = '3' Order By dbo.tblComputers.Computer

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