How to setup a custom software report

[HAL9000]

Hello,

I just installed Lansweeper on a completely different network because my boss wants me to find all non-standard applications on this unknown WAN. My company merged with another company but their network is unknown and pretty chaotic looking. I have access to one of their servers, but it's pretty much a WAN that spans to five different plants. I setup Lansweeper and it has found over 2,500 installed applications on the WAN. Only thing is I do not see a column sorting the installed software by computer name or by network ID. I have to click on each application to get a list of computers that has a certain application installed. Getting the data this way will probably take me about 3 weeks with multitasking. Is there a way to setup a custom report that will give me a list of all installed software with a column that has the computer name or IP?

This would help me tremendously!

Thanks for any kind input.


HAL

[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 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 Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion