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

→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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: 

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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now