Ready to level-up your engineering skills? Join a Pulumi Workshop. Register Now

SqlPoolVulnerabilityAssessment

A Sql pool vulnerability assessment. Latest API Version: 2020-12-01.

Example Usage

Create a database's vulnerability assessment with all parameters

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolVulnerabilityAssessment = new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessmentArgs
        {
            RecurringScans = new AzureNextGen.Synapse.Latest.Inputs.VulnerabilityAssessmentRecurringScansPropertiesArgs
            {
                EmailSubscriptionAdmins = true,
                Emails = 
                {
                    "email1@mail.com",
                    "email2@mail.com",
                },
                IsEnabled = true,
            },
            ResourceGroupName = "vulnerabilityaseessmenttest-4799",
            SqlPoolName = "testdb",
            StorageAccountAccessKey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
            StorageContainerPath = "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
            StorageContainerSasKey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
            VulnerabilityAssessmentName = "default",
            WorkspaceName = "vulnerabilityaseessmenttest-6440",
        });
    }

}
package main

import (
    synapse "github.com/pulumi/pulumi-azure-nextgen/sdk/go/azure/synapse/latest"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolVulnerabilityAssessment(ctx, "sqlPoolVulnerabilityAssessment", &synapse.SqlPoolVulnerabilityAssessmentArgs{
            RecurringScans: &synapse.VulnerabilityAssessmentRecurringScansPropertiesArgs{
                EmailSubscriptionAdmins: pulumi.Bool(true),
                Emails: pulumi.StringArray{
                    pulumi.String("email1@mail.com"),
                    pulumi.String("email2@mail.com"),
                },
                IsEnabled: pulumi.Bool(true),
            },
            ResourceGroupName:           pulumi.String("vulnerabilityaseessmenttest-4799"),
            SqlPoolName:                 pulumi.String("testdb"),
            StorageAccountAccessKey:     pulumi.String("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"),
            StorageContainerPath:        pulumi.String("https://myStorage.blob.core.windows.net/vulnerability-assessment/"),
            StorageContainerSasKey:      pulumi.String("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"),
            VulnerabilityAssessmentName: pulumi.String("default"),
            WorkspaceName:               pulumi.String("vulnerabilityaseessmenttest-6440"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_vulnerability_assessment = azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment",
    recurring_scans=azure_nextgen.synapse.latest.VulnerabilityAssessmentRecurringScansPropertiesArgs(
        email_subscription_admins=True,
        emails=[
            "email1@mail.com",
            "email2@mail.com",
        ],
        is_enabled=True,
    ),
    resource_group_name="vulnerabilityaseessmenttest-4799",
    sql_pool_name="testdb",
    storage_account_access_key="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    storage_container_path="https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    storage_container_sas_key="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    vulnerability_assessment_name="default",
    workspace_name="vulnerabilityaseessmenttest-6440")
import * as pulumi from "@pulumi/pulumi";
import * as azure_nextgen from "@pulumi/azure-nextgen";

const sqlPoolVulnerabilityAssessment = new azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", {
    recurringScans: {
        emailSubscriptionAdmins: true,
        emails: [
            "email1@mail.com",
            "email2@mail.com",
        ],
        isEnabled: true,
    },
    resourceGroupName: "vulnerabilityaseessmenttest-4799",
    sqlPoolName: "testdb",
    storageAccountAccessKey: "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    storageContainerPath: "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    storageContainerSasKey: "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    vulnerabilityAssessmentName: "default",
    workspaceName: "vulnerabilityaseessmenttest-6440",
});

Create a database's vulnerability assessment with minimal parameters, when storageAccountAccessKey is specified

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolVulnerabilityAssessment = new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessmentArgs
        {
            ResourceGroupName = "vulnerabilityaseessmenttest-4799",
            SqlPoolName = "testdb",
            StorageAccountAccessKey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
            StorageContainerPath = "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
            VulnerabilityAssessmentName = "default",
            WorkspaceName = "vulnerabilityaseessmenttest-6440",
        });
    }

}
package main

import (
    synapse "github.com/pulumi/pulumi-azure-nextgen/sdk/go/azure/synapse/latest"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolVulnerabilityAssessment(ctx, "sqlPoolVulnerabilityAssessment", &synapse.SqlPoolVulnerabilityAssessmentArgs{
            ResourceGroupName:           pulumi.String("vulnerabilityaseessmenttest-4799"),
            SqlPoolName:                 pulumi.String("testdb"),
            StorageAccountAccessKey:     pulumi.String("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"),
            StorageContainerPath:        pulumi.String("https://myStorage.blob.core.windows.net/vulnerability-assessment/"),
            VulnerabilityAssessmentName: pulumi.String("default"),
            WorkspaceName:               pulumi.String("vulnerabilityaseessmenttest-6440"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_vulnerability_assessment = azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment",
    resource_group_name="vulnerabilityaseessmenttest-4799",
    sql_pool_name="testdb",
    storage_account_access_key="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    storage_container_path="https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    vulnerability_assessment_name="default",
    workspace_name="vulnerabilityaseessmenttest-6440")
import * as pulumi from "@pulumi/pulumi";
import * as azure_nextgen from "@pulumi/azure-nextgen";

const sqlPoolVulnerabilityAssessment = new azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", {
    resourceGroupName: "vulnerabilityaseessmenttest-4799",
    sqlPoolName: "testdb",
    storageAccountAccessKey: "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    storageContainerPath: "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    vulnerabilityAssessmentName: "default",
    workspaceName: "vulnerabilityaseessmenttest-6440",
});

Create a database's vulnerability assessment with minimal parameters, when storageContainerSasKey is specified

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolVulnerabilityAssessment = new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", new AzureNextGen.Synapse.Latest.SqlPoolVulnerabilityAssessmentArgs
        {
            ResourceGroupName = "vulnerabilityaseessmenttest-4799",
            SqlPoolName = "testdb",
            StorageContainerPath = "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
            StorageContainerSasKey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
            VulnerabilityAssessmentName = "default",
            WorkspaceName = "vulnerabilityaseessmenttest-6440",
        });
    }

}
package main

import (
    synapse "github.com/pulumi/pulumi-azure-nextgen/sdk/go/azure/synapse/latest"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolVulnerabilityAssessment(ctx, "sqlPoolVulnerabilityAssessment", &synapse.SqlPoolVulnerabilityAssessmentArgs{
            ResourceGroupName:           pulumi.String("vulnerabilityaseessmenttest-4799"),
            SqlPoolName:                 pulumi.String("testdb"),
            StorageContainerPath:        pulumi.String("https://myStorage.blob.core.windows.net/vulnerability-assessment/"),
            StorageContainerSasKey:      pulumi.String("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"),
            VulnerabilityAssessmentName: pulumi.String("default"),
            WorkspaceName:               pulumi.String("vulnerabilityaseessmenttest-6440"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_vulnerability_assessment = azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment",
    resource_group_name="vulnerabilityaseessmenttest-4799",
    sql_pool_name="testdb",
    storage_container_path="https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    storage_container_sas_key="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    vulnerability_assessment_name="default",
    workspace_name="vulnerabilityaseessmenttest-6440")
import * as pulumi from "@pulumi/pulumi";
import * as azure_nextgen from "@pulumi/azure-nextgen";

const sqlPoolVulnerabilityAssessment = new azure_nextgen.synapse.latest.SqlPoolVulnerabilityAssessment("sqlPoolVulnerabilityAssessment", {
    resourceGroupName: "vulnerabilityaseessmenttest-4799",
    sqlPoolName: "testdb",
    storageContainerPath: "https://myStorage.blob.core.windows.net/vulnerability-assessment/",
    storageContainerSasKey: "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    vulnerabilityAssessmentName: "default",
    workspaceName: "vulnerabilityaseessmenttest-6440",
});

Create a SqlPoolVulnerabilityAssessment Resource

new SqlPoolVulnerabilityAssessment(name: string, args: SqlPoolVulnerabilityAssessmentArgs, opts?: CustomResourceOptions);
def SqlPoolVulnerabilityAssessment(resource_name: str, opts: Optional[ResourceOptions] = None, recurring_scans: Optional[VulnerabilityAssessmentRecurringScansPropertiesArgs] = None, resource_group_name: Optional[str] = None, sql_pool_name: Optional[str] = None, storage_account_access_key: Optional[str] = None, storage_container_path: Optional[str] = None, storage_container_sas_key: Optional[str] = None, vulnerability_assessment_name: Optional[str] = None, workspace_name: Optional[str] = None)
func NewSqlPoolVulnerabilityAssessment(ctx *Context, name string, args SqlPoolVulnerabilityAssessmentArgs, opts ...ResourceOption) (*SqlPoolVulnerabilityAssessment, error)
public SqlPoolVulnerabilityAssessment(string name, SqlPoolVulnerabilityAssessmentArgs args, CustomResourceOptions? opts = null)
name string
The unique name of the resource.
args SqlPoolVulnerabilityAssessmentArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
opts ResourceOptions
A bag of options that control this resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args SqlPoolVulnerabilityAssessmentArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args SqlPoolVulnerabilityAssessmentArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.

SqlPoolVulnerabilityAssessment Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Programming Model docs.

Inputs

The SqlPoolVulnerabilityAssessment resource accepts the following input properties:

ResourceGroupName string
The name of the resource group. The name is case insensitive.
SqlPoolName string
SQL pool name
VulnerabilityAssessmentName string
The name of the vulnerability assessment.
WorkspaceName string
The name of the workspace
RecurringScans Pulumi.AzureNextGen.Synapse.Inputs.VulnerabilityAssessmentRecurringScansPropertiesArgs
The recurring scans settings
StorageAccountAccessKey string
Specifies the identifier key of the storage account for vulnerability assessment scan results. If ‘StorageContainerSasKey’ isn’t specified, storageAccountAccessKey is required.
StorageContainerPath string
A blob storage container path to hold the scan results (e.g. https://myStorage.blob.core.windows.net/VaScans/). It is required if server level vulnerability assessment policy doesn’t set
StorageContainerSasKey string
A shared access signature (SAS Key) that has write access to the blob container specified in ‘storageContainerPath’ parameter. If ‘storageAccountAccessKey’ isn’t specified, StorageContainerSasKey is required.
ResourceGroupName string
The name of the resource group. The name is case insensitive.
SqlPoolName string
SQL pool name
VulnerabilityAssessmentName string
The name of the vulnerability assessment.
WorkspaceName string
The name of the workspace
RecurringScans VulnerabilityAssessmentRecurringScansProperties
The recurring scans settings
StorageAccountAccessKey string
Specifies the identifier key of the storage account for vulnerability assessment scan results. If ‘StorageContainerSasKey’ isn’t specified, storageAccountAccessKey is required.
StorageContainerPath string
A blob storage container path to hold the scan results (e.g. https://myStorage.blob.core.windows.net/VaScans/). It is required if server level vulnerability assessment policy doesn’t set
StorageContainerSasKey string
A shared access signature (SAS Key) that has write access to the blob container specified in ‘storageContainerPath’ parameter. If ‘storageAccountAccessKey’ isn’t specified, StorageContainerSasKey is required.
resourceGroupName string
The name of the resource group. The name is case insensitive.
sqlPoolName string
SQL pool name
vulnerabilityAssessmentName string
The name of the vulnerability assessment.
workspaceName string
The name of the workspace
recurringScans VulnerabilityAssessmentRecurringScansProperties
The recurring scans settings
storageAccountAccessKey string
Specifies the identifier key of the storage account for vulnerability assessment scan results. If ‘StorageContainerSasKey’ isn’t specified, storageAccountAccessKey is required.
storageContainerPath string
A blob storage container path to hold the scan results (e.g. https://myStorage.blob.core.windows.net/VaScans/). It is required if server level vulnerability assessment policy doesn’t set
storageContainerSasKey string
A shared access signature (SAS Key) that has write access to the blob container specified in ‘storageContainerPath’ parameter. If ‘storageAccountAccessKey’ isn’t specified, StorageContainerSasKey is required.
resource_group_name str
The name of the resource group. The name is case insensitive.
sql_pool_name str
SQL pool name
vulnerability_assessment_name str
The name of the vulnerability assessment.
workspace_name str
The name of the workspace
recurring_scans VulnerabilityAssessmentRecurringScansPropertiesArgs
The recurring scans settings
storage_account_access_key str
Specifies the identifier key of the storage account for vulnerability assessment scan results. If ‘StorageContainerSasKey’ isn’t specified, storageAccountAccessKey is required.
storage_container_path str
A blob storage container path to hold the scan results (e.g. https://myStorage.blob.core.windows.net/VaScans/). It is required if server level vulnerability assessment policy doesn’t set
storage_container_sas_key str
A shared access signature (SAS Key) that has write access to the blob container specified in ‘storageContainerPath’ parameter. If ‘storageAccountAccessKey’ isn’t specified, StorageContainerSasKey is required.

Outputs

All input properties are implicitly available as output properties. Additionally, the SqlPoolVulnerabilityAssessment resource produces the following output properties:

Id string
The provider-assigned unique ID for this managed resource.
Name string
The name of the resource
Type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
Id string
The provider-assigned unique ID for this managed resource.
Name string
The name of the resource
Type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
id string
The provider-assigned unique ID for this managed resource.
name string
The name of the resource
type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
id str
The provider-assigned unique ID for this managed resource.
name str
The name of the resource
type str
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”

Supporting Types

VulnerabilityAssessmentRecurringScansProperties

EmailSubscriptionAdmins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
Emails List<string>
Specifies an array of e-mail addresses to which the scan notification is sent.
IsEnabled bool
Recurring scans state.
EmailSubscriptionAdmins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
Emails []string
Specifies an array of e-mail addresses to which the scan notification is sent.
IsEnabled bool
Recurring scans state.
emailSubscriptionAdmins boolean
Specifies that the schedule scan notification will be is sent to the subscription administrators.
emails string[]
Specifies an array of e-mail addresses to which the scan notification is sent.
isEnabled boolean
Recurring scans state.
email_subscription_admins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
emails Sequence[str]
Specifies an array of e-mail addresses to which the scan notification is sent.
is_enabled bool
Recurring scans state.

VulnerabilityAssessmentRecurringScansPropertiesResponse

EmailSubscriptionAdmins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
Emails List<string>
Specifies an array of e-mail addresses to which the scan notification is sent.
IsEnabled bool
Recurring scans state.
EmailSubscriptionAdmins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
Emails []string
Specifies an array of e-mail addresses to which the scan notification is sent.
IsEnabled bool
Recurring scans state.
emailSubscriptionAdmins boolean
Specifies that the schedule scan notification will be is sent to the subscription administrators.
emails string[]
Specifies an array of e-mail addresses to which the scan notification is sent.
isEnabled boolean
Recurring scans state.
email_subscription_admins bool
Specifies that the schedule scan notification will be is sent to the subscription administrators.
emails Sequence[str]
Specifies an array of e-mail addresses to which the scan notification is sent.
is_enabled bool
Recurring scans state.

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-nextgen:synapse/latest:SqlPoolVulnerabilityAssessment default /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/vulnerabilityaseessmenttest-4799/providers/Microsoft.Synapse/workspaces/vulnerabilityaseessmenttest-6440/sqlPools/testdb/vulnerabilityAssessments/default 

Package Details

Repository
https://github.com/pulumi/pulumi-azure-nextgen
License
Apache-2.0