/*************************************************************************************/
/*     Query of the SCOM OperationsManager database to query All Windows Computers   */
/*     Author: Stefan Stranger, Microsoft Services                                   */ 
/*                                                                                   */
/*************************************************************************************/
Select
vManagedEntity.Displayname
,vme2.DisplayName as "Windows Computer Group"
from vManagedEntity
join vRelationship on vRelationship.TargetManagedEntityRowId=vManagedEntity.ManagedEntityRowId
join vManagedEntity vme2 on vme2.ManagedEntityRowId=vRelationship.SourceManagedEntityRowId
where vme2.DisplayName='Windows Server 2000 Computer Group'
or vme2.DisplayName='Windows Server 2003 Computer Group'
or vme2.DisplayName='Windows Server 2008 Computer Group'
Order by vme2.DisplayName, vManagedEntity.DisplayName