Westur999
Is this what you're looking for?
SELECT vc.Guid as '_ItemGuid',
vc.Name,
vc.[User],
oos.[Name],
oos.[Install Date],
vhw.Manufacturer,
vhw.Model
FROM vComputer vc
JOIN Inv_OS_Operating_System oos ON oos._ResourceGuid=vc.Guid
JOIN vHWComputerSystem vhw on vhw._ResourceGuid=vc.Guid