Report with all software installed on servers

[NorthH]

I was wondering if you could help me with a report that gives me all software installed just on servers by domain.

Thanks in advance!

[NorthH]

That is exactly what I asked for. Thank you!

How could I get a Server Report of just certain Software titles? Could it be tied in to the license compliance somehow or...?

EDIT: Perhaps I could just use license compliance 🙂 - not sure if there is another way as the list that I have now includes software that I am not worried about tracking (like IE etc...)

[Hemoco · Accepted solution]

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