→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-26-2010 06:06 PM
Solved! Go to Solution.
‎09-27-2010 11:36 AM
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
‎09-27-2010 11:36 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now