Loading
How to assign sql licenses and exclude development environment from compliance report

We have a large SQL server estate which consists of Development and production servers.

We know how to assign the licenses to the production servers, but we need to be able to exclude the development servers from the compliance report as they do not count towards our licensable estate.

Has anyone else come up with a solution for this?


  • Hi, sounds like you just need to create a separate OU within SNOW (you'll need to use the smacc to do this). then assign all your development servers into this separate OU. You can then apply a separate site license to cover these and they won't be included within your calculations
    • Thanks for the reply. May be difficult to create an auto detection rule for the OU as the naming standards ....aren't standard!! Wonderful legacy naming, but it gives me a starting point. Mike
      • For Windows systems you could, at system setup/creation, also add an Environment Variable which holds the environment like e.g. ServerEnvironment=Prd and use this Environment Variable in your AutoConnect rule. The only issue could be that when a server might get promoted from e.g. TST to PRD this Environment Variable needs to be changed on the system too.
        Expand Post
      • can you import data from your cmdb into custom fields in snow? that way you can identify by environment 
      • You can also use IP ranges as long as it's a class A, B or C, i.e. 10.10.100.%. Works great for segregated dev environments.
  • Use Compliance Exclusion rules ... but you will need to select the excluded systems manually if you have no way to select them based on a common feature like the naming standard.

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
How to assign sql licenses and exclude development environment from compliance report