Share via


az security va sql scans

View Sql Vulnerability Assessment scan summaries.

Commands

Name Description Type Status
az security va sql scans list

List all Sql Vulnerability Assessment scan summaries.

Core GA
az security va sql scans show

View Sql Vulnerability Assessment scan summaries.

Core GA

az security va sql scans list

List all Sql Vulnerability Assessment scan summaries.

az security va sql scans list --database-name
                              --server-name
                              --vm-resource-id
                              --workspace-id
                              [--agent-id]
                              [--vm-name]
                              [--vm-uuid]

Examples

List all Sql Vulnerability Assessment scan summaries on an Azure virtual machine.

az security va sql scans list --vm-resource-id subscriptions/MySubscription/ResourceGroups/MyResourceGroup/Providers/Microsoft.Compute/VirtualMachines/MyVmName --workspace-id 00000000-0000-0000-0000-000000000000 --server-name MyServerName --database-name MyDbName

List all Sql Vulnerability Assessment scan summaries on an On-Premise machine.

az security va sql scans list --vm-resource-id subscriptions/MySubscription/ResourceGroups/MyResourceGroup/Providers/Microsoft.OperationalInsights/Workspaces/MyWorkspaceName --workspace-id 00000000-0000-0000-0000-000000000000 --server-name MyServerName --database-name MyDbName --vm-name MyVmName --agent-id MyAgentId --vm-uuid MyVmUUID

Required Parameters

--database-name

The name of the scanned database.

--server-name

The name of the scanned server.

--vm-resource-id

Resource ID of the scanned machine. For On-Premise machines, please provide your workspace resource ID.

--workspace-id

The ID of the workspace connected to the scanned machine.

Optional Parameters

--agent-id

Provide the ID of the agent on the scanned machine, for On-Premise resources only.

--vm-name

Provide the name of the machine, for On-Premise resources only.

--vm-uuid

Provide the UUID of the scanned machine, for On-Premise resources only.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az security va sql scans show

View Sql Vulnerability Assessment scan summaries.

az security va sql scans show --database-name
                              --scan-id
                              --server-name
                              --vm-resource-id
                              --workspace-id
                              [--agent-id]
                              [--vm-name]
                              [--vm-uuid]

Examples

View Sql Vulnerability Assessment scan summary on an Azure virtual machine.

az security va sql scans show --vm-resource-id subscriptions/MySubscription/ResourceGroups/MyResourceGroup/Providers/Microsoft.Compute/VirtualMachines/MyVmName --workspace-id 00000000-0000-0000-0000-000000000000 --server-name MyServerName --database-name MyDbName --scan-id MyScanId

View Sql Vulnerability Assessment scan summary on an On-Premise machine.

az security va sql scans show --vm-resource-id subscriptions/MySubscription/ResourceGroups/MyResourceGroup/Providers/Microsoft.OperationalInsights/Workspaces/MyWorkspaceName --workspace-id 00000000-0000-0000-0000-000000000000 --server-name MyServerName --database-name MyDbName --vm-name MyVmName --agent-id MyAgentId --vm-uuid MyVmUUID --scan-id MyScanId

Required Parameters

--database-name

The name of the scanned database.

--scan-id

The ID of the scan.

--server-name

The name of the scanned server.

--vm-resource-id

Resource ID of the scanned machine. For On-Premise machines, please provide your workspace resource ID.

--workspace-id

The ID of the workspace connected to the scanned machine.

Optional Parameters

--agent-id

Provide the ID of the agent on the scanned machine, for On-Premise resources only.

--vm-name

Provide the name of the machine, for On-Premise resources only.

--vm-uuid

Provide the UUID of the scanned machine, for On-Premise resources only.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.