PRO: Filtering

PRO: Filtering #

All features described on this page are part of the Professional Edition.

You can purchase licenses for the Professional Edition on the Portal: https://portal.sqldsc.com.

Filtering #

The sqldsc.exe command has a filter for tag. When specified, it will only process nodes in that tag. This parameter is available for test and apply. Some sample command lines are:

  • sqldsc.exe test --tag ag-one - Test the configuration on all servers assigned the ag-one tag. Assigning all the nodes in an AG to a specific tag is a good way to process them all together.
  • sqldsc.exe apply --tag dev - Apply changes do all servers assigned the dev tag.

Please be aware, the filtering for tags decides which computers to target based on the tag membership. It will still process all the settings for all the tags for those computers.