Select d.Manufacturer, d.Model, vc.Name as 'Workstation', rd.login_name as 'User', b.BuildNumber as 'Bios Version', hd.DeviceID, hd.Model as 'Hard Drive Model', hd.Partitions, hd.MediaType, hd.totalPhysicalSize, rd.Equip_status
from Inv_OMCA_Discovery d
Join Inv_OMCA_BIOS_Element b  on b._ResourceGuid = d._ResourceGuid	
Join Inv_OMCA_Disk_Drive hd on hd._ResourceGuid = d._ResourceGuid
Join vcomputer vc on vc.Guid = d._ResourceGuid
	

     

Order by d.Model, vc.Name