Here is the query with Mfgr / Model added.
I'm not sure what you mean about a Windows 7 partition. Assuming you mean dual booting or running Win 7 as a virtual like under Parrallels, you would need to install the Altiris agent separatly within Windows 7, you wouldn't be able to inventory any Win 7 information from the Mac agent. If you are dual-booting (using the same NIC with the same MAC address), I would imagine you might have some resource merging issues as well where Altiris goes back and forth reporting whether the machine is Windows or Mac OS. If you are running Windows as a VM, Altiris will see it as a separate resource.
SELECT vc.Name [Computer Name]
, vc.[User]
, vc.[Os Name]
, vc.[OS Version]
, vc.[OS Revision]
, vc.[IP Address]
, bios.[Version] [Bios Ver]
, sn1.[Manufacturer]
, sn1.[Model]
, id.[Hardware Serial Number]
, vc.IsManaged
FROM vComputer vc
LEFT JOIN Inv_AeX_AC_Identification ID on ID._ResourceGuid = vc.Guid
LEFT JOIN Inv_SW_BIOS_Element bios on bios._ResourceGuid = vc.Guid
LEFT JOIN vHWComputerSystem sn1 ON sn1.[_ResourceGuid] = vc.Guid
WHERE
vc.[OS Name] like 'Mac OS%'
ORDER BY
vc.Name
Joe