PRO: Filtering

PRO: Filtering #

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

While in beta, you can enable the Professional Edition by creating an account and downloading a license from

The PRO edition will become a paid version. Until then, PRO features expire 60 days after the build date. Please see for updated builds or run sqldsc update.

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.