Options
Pushing Tab Coloring to Lots of Servers
DonFerguson
Posts: 196 Silver 5
I like the tab coloring feature; however, it will be a chore to push it out individually to every instance for all DBAs. Is there an easier way to do this via script or other means?
Comments
The XML file resides here: %localappdata%\Red Gate\SQL Prompt 6
Hope this helps.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
In my case I was able to further take this information and query my Central Management server to generate the XML data needed.
Since I have a naming convention on the different environments, it was simply a matter of parsing the environment value from the name. I am providing it for the benefit of anyone else interested.
Obviously this query needs to be modified to meet the convention of a given organization's naming conventions, but here's a start. Modify as needed the output from this query below and paste results into the XML file following the <?xml version="1.0"?> line.
SELECT name
,category = CASE LEFT(name, 1)
WHEN 'D' THEN 'DEVELOPMENT'
WHEN 'S' THEN 'STAGING'
WHEN 'T' THEN 'TESTING'
WHEN 'P' THEN 'PRODUCTION'
ELSE 'PRODUCTION'
END
FROM msdb.dbo.sysmanagement_shared_registered_servers_internal
FOR XML PATH('server')
,ROOT('settings')