Altiris can have multiple organizational views. For example, let's say we have an Active Directory view (based on an AD synchronization), an Operating System view, and a Geographic view.
Within a view, a computer can exist in only one group. Therefore, the MRZ-EXCH server can exist in the 'Exchange 2010 Back-End Servers' group within the Active Directory view, within the 'Windows Server 2008 R2' group within the OS view, and within the 'Minneapolis' group in the Geographic view.
Would Thomas Baird's solution in this thread assist you?
https://www-secure.symantec.com/connect/forums/sql-query-organizational-group
Taking out some extra stuff, it would look like this if you wanted to report on a specific group:
SELECT v1.[Name],
v1.Guid as 'ResourceGuid'
v1.[OS Name]
FROM vComputer v1
WHERE v1.Guid in (SELECT ResourceGuid FROM ScopeMembership WHERE ScopeCollectionGuid='GUID-of-the-GROUP-goes-here')
ORDER BY v1.Name
Just drop there WHERE ScopeCollectionGuid='GUID' part if you don't want to report on a specific group. I'm not a SQL expert, but give this a try.