SELECT
	vc.[Name]
	,vc.[User]
	,vc.[OS Name]
	,vc.[IP Address] As 'IP'
	,cd.[Comment] AS 'Comment'
	,hw.[System Manufacturer] AS 'Manufacturer'
	,hw.[Computer Model] AS 'Model'
	,mem.[Total Physical Memory (MB)] AS 'Memory'
	,hw.[Serial Number] AS 'Serial '
	,hw.[Asset Tag] AS 'Asset Tag' 
FROM [vComputer] vc
	INNER JOIN [Inv_AeX_Computer_Description] cd
		ON vc.[Guid] = cd.[_ResourceGuid] 
	INNER JOIN [Inv_AeX_HW_Serial_Number] hw
		ON vc.[Guid] = hw.[_ResourceGuid] 
	INNER JOIN [Inv_AeX_AC_Primary_User] pu
		ON vc.[Guid] = pu.[_ResourceGuid] 
	INNER JOIN [Inv_AeX_HW_Memory] mem
		ON vc.[Guid] = mem.[_ResourceGuid] 
WHERE vc.[Name] LIKE '%CompName%'
	AND cd.[Comment] LIKE '%CompComment%' 
	AND hw.[Computer Model] LIKE '%CompModel%' 
GROUP BY
	vc.[Name],
	vc.[User], 
	vc.[OS Name],
	vc.[IP Address],
	cd.[Comment], 
	hw.[System Manufacturer], 
	hw.[Computer Model], 
	mem.[Total Physical Memory (MB)], 
	hw.[Serial Number], 
	hw.[Asset Tag]
order by IP