Report of all servers with AD Description

[NorthH]

I am looking to modify this report so that we can see the Active Directory Description. Thank you for your time in advance. Also I would like 1 report per domain please..thanks!

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 Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblComputerSystemProduct tblComputerSystemProduct1 On
    dbo.tblComputers.Computername = tblComputerSystemProduct1.Computername
Where dbo.tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Computer

[Hemoco]

replace 'yourdomain' by the domain you want

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
  tblADComputers.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 Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblComputerSystemProduct tblComputerSystemProduct1 On
    dbo.tblComputers.Computername = tblComputerSystemProduct1.Computername
  Left Join
  tblADComputers On dbo.tblComputers.Computername = tblADComputers.Computername
Where dbo.tblComputers.Domain = 'yourdomain' And
  dbo.tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Domain, dbo.tblComputers.Computer

[NorthH]

I have this so far (I am not a sql guy)

Select Top 1000000 dbo.tblComputers.Computername,     dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,     dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon,     tblADComputers.Description 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 Inner Join     tblComputerSystemProduct On dbo.tblComputers.Computername =       tblComputerSystemProduct.Computername Inner Join   tblComputerSystemProduct   tblComputerSystemProduct1 On     dbo.tblComputers.Computername =   tblComputerSystemProduct1.Computername   Inner Join   tblADComputers On   dbo.tblComputers.Computername = tblADComputers.Computername Where   dbo.tblComputers.Domain = 'TEST' And dbo.tblComputersystem.Domainrole > 1   Order By dbo.tblComputers.Computer

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon, tblADComputers.Description 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 Inner Join tblComputerSystemProduct On dbo.tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblComputerSystemProduct tblComputerSystemProduct1 On dbo.tblComputers.Computername = tblComputerSystemProduct1.Computername Inner Join tblADComputers On dbo.tblComputers.Computername = tblADComputers.Computername Where dbo.tblComputers.Domain = 'TEST' And dbo.tblComputersystem.Domainrole > 1 Order By dbo.tblComputers.Computer

[NorthH]

Could you let me know how to isolate the domains..I realize that I will need to fill in the criteria in ach sql script

[Hemoco]

Try this, it's sorted by domain

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
  tblADComputers.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 Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblComputerSystemProduct tblComputerSystemProduct1 On
    dbo.tblComputers.Computername = tblComputerSystemProduct1.Computername
  Left Join
  tblADComputers On dbo.tblComputers.Computername = tblADComputers.Computername
Where dbo.tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Domain, dbo.tblComputers.Computer