‎03-30-2011 09:32 PM
Solved! Go to Solution.
‎04-01-2011 12:35 PM
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
Where dbo.tblComputers.Computer Like 'GRM%'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion
‎04-01-2011 12:35 PM
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
Where dbo.tblComputers.Computer Like 'GRM%'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion
‎04-04-2011 03:52 PM
Lansweeper wrote: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
Where dbo.tblComputers.Computer Like 'GRM%'
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