Software inventory detail report by server needed

[ghopkins58]

I am new to the lansweeper, but I am trying to make a report that is to give me a detailed inventory by server of all the software that is installed on each server.

[ghopkins58]

Thanks very much! Exactly what I needed.

[Hemoco · Accepted solution]

try this:

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
  dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As
  Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Web40OSName.Compimage
  As icon, tblComputersystem.Domainrole
From dbo.tblSoftware Inner Join
  dbo.tblComputers On dbo.tblSoftware.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
  tblComputersystem On dbo.tblComputers.Computername =
    tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
  dbo.tblSoftware.softwareVersion