→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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