Here is my code, so you can take a look at it. I'm getting multipe entries on the servers. And is there a way on the hard drive information to make them there own columns? Appreciate your help.
Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Domain, tblCompCustom.Custom2 As [Tech Contact], tblADComputers.OperatingSystem, tblComputersystem.Model, dbo.tblDiskdrives.Caption As Drive, Cast(Cast(dbo.tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As [Free Space], Cast(Cast(dbo.tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As [Total size], tblComputersystem.TotalPhysicalMemory As [Total Physical Memory], tblComputersystem1.NumberOfProcessors As [# of Processors], tblPROCESSOR.Name As [Processor Name], web40usedsoftware.softwareVersion As [Symantec Version], web40usedsoftware1.softwareVersion As [TSM Version], tblADComputers1.OU, tblCompCustom1.LastPatched From dbo.tblComputers Inner Join dbo.tblDiskdrives On dbo.tblComputers.Computername = dbo.tblDiskdrives.Computername Inner Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join tblComputersystem On dbo.tblComputers.Computername = tblComputersystem.Computername Inner Join tblCompCustom On dbo.tblComputers.Computername = tblCompCustom.Computername Inner Join tblADComputers On dbo.tblComputers.Computername = tblADComputers.Computername Inner Join tblComputersystem tblComputersystem1 On dbo.tblComputers.Computername = tblComputersystem1.Computername Inner Join tblPROCESSOR On dbo.tblComputers.Computername = tblPROCESSOR.Computername Inner Join tblADComputers tblADComputers1 On dbo.tblComputers.Computername = tblADComputers1.Computername Inner Join tblCompCustom tblCompCustom1 On dbo.tblComputers.Computername = tblCompCustom1.Computername, web40usedsoftware, web40usedsoftware web40usedsoftware1 Where Cast(Cast(dbo.tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0 And dbo.tblDiskdrives.DriveType = '3' And web40usedsoftware.softwareName = 'Symantec Endpoint Protection' And web40usedsoftware1.softwareName = 'IBM Tivoli Storage Manager Client' Order By dbo.tblComputers.Computer, Cast(Cast(dbo.tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric), dbo.tblDiskdrives.Caption
