This project is read-only.
1
Vote

Referencing nested Management Server Group

description

How would you reference the correct Central Management Server Group when the structure is like this:

ROOT
 Test 
       SQLServer2000
                [instance 1]
                [instance 2]
       SQLServer2005
                [instance 1]
                [instance 2]
  Live
       SQLServer2000
                [instance 1]
                [instance 2]
       SQLServer2005
                [instance 1]
                [instance 2]
I cannot seem to get it to work when I input the script like this:
SL "D:\somepath\somefile\”
.\EPM_EnterpriseEvaluation_412.ps1 -ConfigurationGroup "Root\Live\SQLServer2005" -PolicyCategoryFilter "Microsoft Best Practices: Performance" –EvalMode “Check”

but in my test environment putting "SQLServer2005" works fine as I made sure I did not have a duplicate registerd server group in live and test in that CMS. I cannot change the names easily as we have other processes that utilize the CMS programatically.

Your help is greatly appreciated.
Have a great day!

comments

KeithCorser wrote Aug 6, 2015 at 12:24 AM

Change "Root\Live\SQLServer2005" to "". The Script will run the policy against all your registered servers and the Dropdown in the EPM Framework will mimic your CMS folder structure. We do this & ours is:

ALL
 2008
      App1
             registered server1
      App2
      App3
2012
     App4

IberiaDBA wrote Aug 6, 2015 at 8:40 PM

right but I do not want to evaluate against all nodes. I want to evaluate against a specific node that has the same name as another nested node in a different node of the tree.

IberiaDBA wrote Aug 17, 2015 at 5:31 PM

Luckily there is a typo in our tree and SQL2008R2 is referenced as that and SQL2008 R2 under the other tree so we are golden. Sometimes what seems like an 'error' was unintended pre-planning!