Hi,
Im am getting some duplicates rows returned for the following report I am using to display user and computer details where Adobe Acrobat is installed - any suggestions on how to fix this or otherwise improve the SQL code?
Thanks.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, Web40OSName.Compimage As icon, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Caption, Web40OSName.SP, tblComputers.Username, tblADusers.Lastname, tblADusers.Firstname, web40CorrectMemory.Memory As Memory, Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [Disk size], web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU, tblComputerSystemProduct.Name As Model, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP As [IP Address], web40AllIPLocations.IPLocation, tblComputers.Lastseen, tblOperatingsystem.SerialNumber, tblOperatingsystem.Version, tblSoftware.softwareName, tblSoftware.softwareVersion, tblSoftware.Installdate From tblComputers Inner Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Left Outer Join web40ProcessorCapacity On tblComputers.Computername = web40ProcessorCapacity.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblADusers On tblComputers.Username = tblADusers.Username Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Inner Join tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Where (tblSoftware.softwareName Like '%Adobe Acrobat%' And tblSoftware.softwareName Not Like '%Reader%' And tblSoftware.softwareName Not Like '%Connect%') And tblDiskdrives.Caption = 'c:' Order By dbo.tblComputers.Computername