MIM Portal Groups whose displayedOwner isn't among the Owners
In the MIM Portal it will create issues if you have a group whose displayedOwner isn’t among the objects in the multivalued reference attribute Owner. Querying this through XPath is just about impossible so here is the SQL query to do it. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO USE FIMService GO SELECT DOwn.* FROM ( SELECT groupObjID = G.[objectID] , GroupDisplayName = GAOVS.ValueString , userDisplayName= UAOVS.ValueString