AM
Size: a a a
AM
P
AM
AM
AM
D
P
AM
AM
AM
P
P
AM
AM
D
D
D
AM
SELECT distinct BaseManagedEntity.DisplayName, State.HealthState FROM State INNER JOIN BaseManagedEntity ON State.BaseManagedEntityId = BaseManagedEntity.BaseManagedEntityId
where (BaseManagedEntity.FullName like 'Service_%'
or BaseManagedEntity.DisplayName = 'Active Directory Topology Root'
or BaseManagedEntity.DisplayName = 'NAP Service'
)and BaseManagedEntity.Name is NULL
AM