→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
NorthH
Engaged Sweeper III
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
NorthH
Engaged Sweeper III
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
Lansweeper Alumni
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