Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Central Management Server left out in the cold Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 8:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 3:32 PM
Points: 27, Visits: 193
I just set up a Central Management Server and can now check my policies against a whole group of SQL Server instances. This is great! However, it seems the instance that is designated as the Central Management Server is not checked when policies are evaluated. Is there any way to include this instance or do all policies need to be checked twice: once for the central server, and again on the target group?
Post #1475258
Posted Friday, July 19, 2013 3:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:43 AM
Points: 54, Visits: 230
hello,

just add the @@SERVERNAME
SELECT
s.server_name as ServerName,
ssg.name as GroupName
FROM [msdb].[dbo].[sysmanagement_shared_registered_servers_internal] s
INNER JOIN [msdb].[dbo].[sysmanagement_shared_server_groups] ssg
ON s.server_group_id = ssg.server_group_id
UNION
SELECT @@SERVERNAME, 'Sql Server'

Post #1475332
Posted Friday, July 19, 2013 9:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 3:32 PM
Points: 27, Visits: 193
Chauchs,

I am not sure if I understand your reply. Are you suggesting I add the central management server to the sysmanagement_shared_server_groups table? I tried adding it via the Registered Servers GUI but get the error: "You cannot add a shared registered server with the same name as the Configuration Server."
Post #1475545
Posted Friday, July 19, 2013 10:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:43 AM
Points: 54, Visits: 230
No,
How are you run the check of your policies?

Post #1475599
Posted Friday, July 19, 2013 10:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 3:32 PM
Points: 27, Visits: 193
Just like shown here:
http://www.mssqltips.com/sqlservertip/2859/evaluating-policies-on-multiple-sql-server-instances-using-central-management-server/
Post #1475602
Posted Monday, July 22, 2013 3:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:43 AM
Points: 54, Visits: 230
ok so, for me, it's "manually" and I don't know how is it possible manually.

Otherwise you can do this with a script (PowerShell).
Take a look here : http://epmframework.codeplex.com/
And see the Dowloads page : http://epmframework.codeplex.com/releases/view/28621
(you dont need to create reports)
Post #1475914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse