az security va sql results

View Sql Vulnerability Assessment scan results.

Commands

Name	Description	Type	Status
az security va sql results list	View all Sql Vulnerability Assessment scan results.	Core	GA
az security va sql results show	View Sql Vulnerability Assessment scan results.	Core	GA

az security va sql results list

View all Sql Vulnerability Assessment scan results.

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

Examples

View all Sql Vulnerability Assessment scan results on an Azure virtual machine.

az security va sql results 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 --scan-id MyScanId

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

az security va sql results 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 --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.

az security va sql results show

View Sql Vulnerability Assessment scan results.

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

Examples

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

az security va sql results 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 --rule-id VA9999

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

az security va sql results 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 --rule-id VA9999

Required Parameters

--database-name

The name of the scanned database.

--rule-id

The ID of the scanned rule. Format: "VAXXXX", where XXXX indicates the number of the rule.

--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.