Post reply

Scripting CMS

  • August 27, 2013 at 9:19 am

    #282550

    I've looked but perhaps my GoogleFu isn't good enough. Is there a way to script a CMS server group and script servers into it?

    Regards,

    Erin

  • August 27, 2013 at 12:03 pm

    #1645295

    *bump*

  • August 27, 2013 at 12:04 pm

    #1645296

    haven't tried this myself but you could just try inserting directly into the CMS tables.

    msdb.dbo.sysmanagement_shared_registered_servers_internal

    msdb.dbo.sysmanagement_shared_server_groups_internal

    use caution, usually not a good idea to insert into system tables

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • August 27, 2013 at 12:07 pm

    #1645297

    scripting via powershell[/url] is also an option and probably preferable.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • August 27, 2013 at 12:08 pm

    #1645298

    *runs for the production server to try this out...*

    Sounds like a plan!

    ~jk.. though I'll take a look at that option and see.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply