Related command
az sql vm update --enable-assessment true -g <Resource Group Name> -n <SQL VM Name> --workspace-name <LA workspace's name> --workspace-rg <LA workspace's resource group name>

Description

• SQL VM offers ability to configure and run assessment via previous PR. This PR adds support for verifying and managing pre-requisites such as Log Analytics extension on VM and custom log definition on workspace.
  • Re-use az vm's code for managing Log Analytics extension. See src/azure-cli/azure/cli/command_modules/sqlvm/_util.py
  • Rename SQL Best Practice Assessment to SQL best practices assessment as per branding requirement
  • Move LogAnalyticsWorkspacePreparer to cli-test-sdk for use across modules
• Fix usage of is_r_services field when populating request object

Testing Guide

# Deploy pre-requisites for SQL best practices assessment using given LA workspace
az sql vm update --enable-assessment true -g <Resource Group Name> -n <SQL VM Name> --workspace-name <LA workspace's name> --workspace-rg <LA workspace's resource group name>

# Deploy pre-requisites for SQL best practices assessment using workspace already associated with VM, if not throw appropriate error
az sql vm update –assessment-weekly-interval 3 --assessment-day-of-week Sunday –assessment-start-time-local "23:00" -g <Resource Group Name> -n <SQL VM Name>

Scenarios:

1. No workspace attached to VM. User does not provide workspace arguments -> Throw error
2. No workspace attached to VM. User provides workspace arguments -> Deploy VM extension and custom log if not present.
3. Workspace attached to VM. User does not provide workspace arguments -> Determine workspace from extension. Verify workspace exists. Deploy custom log if necessary.
4. Workspace attached to VM. User provides workspace arguments -> Determine workspace from extension. Verify workspace exists and matches user arguments. Deploy custom log if necessary.
5. Configure assessment/workspace via CLI on 1 VM. Configure via Portal for another VM for same workspace -> Custom log definition created by CLI also recognized by Portal

This checklist is used to make sure that common guidelines for a pull request are followed.

• The PR title and description has followed the guideline in Submitting Pull Requests.

• I adhere to the Command Guidelines.

• I adhere to the Error Handling Guidelines.