Monday, May 21, 2012 1:13 PM
-I have created a group "SQL GROUP PROD" inside SCOM. It is populated by the query below:
(Object is SQL Role AND (Windows Computer.DNS Forest Name Equals domain1.local) OR (Windows Computer.DNS Forest Name Equals domain2.local))
This group contains several Members.
-But when I create view state below result is empty.
Show data related to : Windows Computer
Show Data contained in a specific group : "SQL GROUP PROD"
Have you any idea about this problem.
Thanks a lot
Monday, May 21, 2012 2:03 PMModerator
Monday, May 21, 2012 3:14 PMModeratorWhen you view group memebership of these groups, what objects are returned? I would assume windows.computer objects. Is that what you are seeing when you view group membership from the authoring tab?
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
Monday, May 21, 2012 4:02 PM
-In the group we have SQL Server object type (Engine, SSAS, SSIS...)
But I don't have any windows computers
-If I select in view state options: (Show data related to : "SQL DEB Engine") and (Show Data contained in a specific group : "SQL GROUP PROD")
I can see only "SQL Engine object" but with this option I can't access all objects of view explorer : hardware , OS, performance...
I have just health explorer about SQL Engine.
Is it possible to view health check of server hosting SQL Server Engine ?
Monday, May 21, 2012 4:05 PM
try to modify the group query by
(Object is SQLComputers AND ((Windows Computer.DNS Forest Name Equals domain1.local) OR (Windows Computer.DNS Forest Name Equals domain2.local)))
Friday, May 25, 2012 9:29 AM
Thank you for you help Roger.
My state view is Ok now when I use your query to populate my Group.