Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Custom view state does not return result

Answered Custom view state does not return result

  • Monday, May 21, 2012 1:13 PM
     
     
    Sign In to Vote
    0

    Hello,

    -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

    Eric

     

All Replies

  • Monday, May 21, 2012 2:03 PM
    Moderator
     
     
    Sign In to Vote
    0

    Do you have any windows computers in the group?

    Have you tried to scope - Show data related to : SQL Role

    Cheers

    Graham

    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

     
  • Monday, May 21, 2012 3:14 PM
    Moderator
     
     
    Sign In to Vote
    0
    When 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
     
     
    Sign In to Vote
    0

    -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 ?

    Eric

    Eric

     
  • Monday, May 21, 2012 4:05 PM
     
     Answered
    Sign In to Vote
    0

    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)))

    Roger

     
  • Friday, May 25, 2012 9:29 AM
     
     
    Sign In to Vote
    0

    Thank you for you help Roger.

    My state view is Ok now when I use your query to populate my Group.

    Eric

    Eric