0

Like looking for all of my DEX servers? As opposed to looking/scrolling thru them all.

0

SSMS doesn't offer search capabilities in the Registered Servers.

If you're using a Central Management Server (CMS), my open source DBA Database includes a view to expose registered servers to be easily queried via T-SQL.

After installing the DBA Database (or the solitary view), you can simply connect to the CMS using a query window and do a search like:

SELECT * 
FROM dbo.CmsServers
WHERE ServerName LIKE '%DEX%';

The view also exposes group membership and the full hierarchy at a path so you can do something like:

SELECT * 
FROM dbo.CmsServers
WHERE ServerName LIKE '%DEX%'
AND ServerPath LIKE '%Production%';

If you're using locally registered servers, you would have to migrate those connections to a CMS to use the view. Thankfully, even Express Edition can be used as a CMS to save on licensing costs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.