Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native
  3. API Docs
  4. sqlvirtualmachine
  5. getSqlVirtualMachine
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native.sqlvirtualmachine.getSqlVirtualMachine

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

    Gets a SQL virtual machine. Azure REST API version: 2022-02-01.

    Other available API versions: 2023-01-01-preview, 2023-10-01.

    Using getSqlVirtualMachine

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getSqlVirtualMachine(args: GetSqlVirtualMachineArgs, opts?: InvokeOptions): Promise<GetSqlVirtualMachineResult>
function getSqlVirtualMachineOutput(args: GetSqlVirtualMachineOutputArgs, opts?: InvokeOptions): Output<GetSqlVirtualMachineResult>
    def get_sql_virtual_machine(expand: Optional[str] = None,
                            resource_group_name: Optional[str] = None,
                            sql_virtual_machine_name: Optional[str] = None,
                            opts: Optional[InvokeOptions] = None) -> GetSqlVirtualMachineResult
def get_sql_virtual_machine_output(expand: Optional[pulumi.Input[str]] = None,
                            resource_group_name: Optional[pulumi.Input[str]] = None,
                            sql_virtual_machine_name: Optional[pulumi.Input[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetSqlVirtualMachineResult]
    func LookupSqlVirtualMachine(ctx *Context, args *LookupSqlVirtualMachineArgs, opts ...InvokeOption) (*LookupSqlVirtualMachineResult, error)
func LookupSqlVirtualMachineOutput(ctx *Context, args *LookupSqlVirtualMachineOutputArgs, opts ...InvokeOption) LookupSqlVirtualMachineResultOutput

    > Note: This function is named LookupSqlVirtualMachine in the Go SDK.

    public static class GetSqlVirtualMachine 
{
    public static Task<GetSqlVirtualMachineResult> InvokeAsync(GetSqlVirtualMachineArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlVirtualMachineResult> Invoke(GetSqlVirtualMachineInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlVirtualMachineResult> getSqlVirtualMachine(GetSqlVirtualMachineArgs args, InvokeOptions options)
public static Output<GetSqlVirtualMachineResult> getSqlVirtualMachine(GetSqlVirtualMachineArgs args, InvokeOptions options)

    fn::invoke:
  function: azure-native:sqlvirtualmachine:getSqlVirtualMachine
  arguments:
    # arguments dictionary

    The following arguments are supported:

    ResourceGroupName string
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    SqlVirtualMachineName string
    Name of the SQL virtual machine.
    Expand string
    The child resources to include in the response.
    ResourceGroupName string
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    SqlVirtualMachineName string
    Name of the SQL virtual machine.
    Expand string
    The child resources to include in the response.
    resourceGroupName String
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    sqlVirtualMachineName String
    Name of the SQL virtual machine.
    expand String
    The child resources to include in the response.
    resourceGroupName string
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    sqlVirtualMachineName string
    Name of the SQL virtual machine.
    expand string
    The child resources to include in the response.
    resource_group_name str
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    sql_virtual_machine_name str
    Name of the SQL virtual machine.
    expand str
    The child resources to include in the response.
    resourceGroupName String
    Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    sqlVirtualMachineName String
    Name of the SQL virtual machine.
    expand String
    The child resources to include in the response.

    getSqlVirtualMachine Result

    The following output properties are available:

    Id string
    Resource ID.
    Location string
    Resource location.
    Name string
    Resource name.
    ProvisioningState string
    Provisioning state to track the async operation status.
    SystemData Pulumi.AzureNative.SqlVirtualMachine.Outputs.SystemDataResponse
    Metadata pertaining to creation and last modification of the resource.
    Type string
    Resource type.
    AssessmentSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.AssessmentSettingsResponse
    Assessment Settings.
    AutoBackupSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.AutoBackupSettingsResponse
    Auto backup settings for SQL Server.
    AutoPatchingSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.AutoPatchingSettingsResponse
    Auto patching settings for applying critical security updates to SQL virtual machine.
    Identity Pulumi.AzureNative.SqlVirtualMachine.Outputs.ResourceIdentityResponse
    Azure Active Directory identity of the server.
    KeyVaultCredentialSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.KeyVaultCredentialSettingsResponse
    Key vault credential settings.
    ServerConfigurationsManagementSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.ServerConfigurationsManagementSettingsResponse
    SQL Server configuration management settings.
    SqlImageOffer string
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    SqlImageSku string
    SQL Server edition type.
    SqlManagement string
    SQL Server Management type.
    SqlServerLicenseType string
    SQL Server license type.
    SqlVirtualMachineGroupResourceId string
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    StorageConfigurationSettings Pulumi.AzureNative.SqlVirtualMachine.Outputs.StorageConfigurationSettingsResponse
    Storage Configuration Settings.
    Tags Dictionary<string, string>
    Resource tags.
    VirtualMachineResourceId string
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    WsfcDomainCredentials Pulumi.AzureNative.SqlVirtualMachine.Outputs.WsfcDomainCredentialsResponse
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    WsfcStaticIp string
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    Id string
    Resource ID.
    Location string
    Resource location.
    Name string
    Resource name.
    ProvisioningState string
    Provisioning state to track the async operation status.
    SystemData SystemDataResponse
    Metadata pertaining to creation and last modification of the resource.
    Type string
    Resource type.
    AssessmentSettings AssessmentSettingsResponse
    Assessment Settings.
    AutoBackupSettings AutoBackupSettingsResponse
    Auto backup settings for SQL Server.
    AutoPatchingSettings AutoPatchingSettingsResponse
    Auto patching settings for applying critical security updates to SQL virtual machine.
    Identity ResourceIdentityResponse
    Azure Active Directory identity of the server.
    KeyVaultCredentialSettings KeyVaultCredentialSettingsResponse
    Key vault credential settings.
    ServerConfigurationsManagementSettings ServerConfigurationsManagementSettingsResponse
    SQL Server configuration management settings.
    SqlImageOffer string
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    SqlImageSku string
    SQL Server edition type.
    SqlManagement string
    SQL Server Management type.
    SqlServerLicenseType string
    SQL Server license type.
    SqlVirtualMachineGroupResourceId string
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    StorageConfigurationSettings StorageConfigurationSettingsResponse
    Storage Configuration Settings.
    Tags map[string]string
    Resource tags.
    VirtualMachineResourceId string
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    WsfcDomainCredentials WsfcDomainCredentialsResponse
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    WsfcStaticIp string
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    id String
    Resource ID.
    location String
    Resource location.
    name String
    Resource name.
    provisioningState String
    Provisioning state to track the async operation status.
    systemData SystemDataResponse
    Metadata pertaining to creation and last modification of the resource.
    type String
    Resource type.
    assessmentSettings AssessmentSettingsResponse
    Assessment Settings.
    autoBackupSettings AutoBackupSettingsResponse
    Auto backup settings for SQL Server.
    autoPatchingSettings AutoPatchingSettingsResponse
    Auto patching settings for applying critical security updates to SQL virtual machine.
    identity ResourceIdentityResponse
    Azure Active Directory identity of the server.
    keyVaultCredentialSettings KeyVaultCredentialSettingsResponse
    Key vault credential settings.
    serverConfigurationsManagementSettings ServerConfigurationsManagementSettingsResponse
    SQL Server configuration management settings.
    sqlImageOffer String
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    sqlImageSku String
    SQL Server edition type.
    sqlManagement String
    SQL Server Management type.
    sqlServerLicenseType String
    SQL Server license type.
    sqlVirtualMachineGroupResourceId String
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    storageConfigurationSettings StorageConfigurationSettingsResponse
    Storage Configuration Settings.
    tags Map<String,String>
    Resource tags.
    virtualMachineResourceId String
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    wsfcDomainCredentials WsfcDomainCredentialsResponse
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    wsfcStaticIp String
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    id string
    Resource ID.
    location string
    Resource location.
    name string
    Resource name.
    provisioningState string
    Provisioning state to track the async operation status.
    systemData SystemDataResponse
    Metadata pertaining to creation and last modification of the resource.
    type string
    Resource type.
    assessmentSettings AssessmentSettingsResponse
    Assessment Settings.
    autoBackupSettings AutoBackupSettingsResponse
    Auto backup settings for SQL Server.
    autoPatchingSettings AutoPatchingSettingsResponse
    Auto patching settings for applying critical security updates to SQL virtual machine.
    identity ResourceIdentityResponse
    Azure Active Directory identity of the server.
    keyVaultCredentialSettings KeyVaultCredentialSettingsResponse
    Key vault credential settings.
    serverConfigurationsManagementSettings ServerConfigurationsManagementSettingsResponse
    SQL Server configuration management settings.
    sqlImageOffer string
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    sqlImageSku string
    SQL Server edition type.
    sqlManagement string
    SQL Server Management type.
    sqlServerLicenseType string
    SQL Server license type.
    sqlVirtualMachineGroupResourceId string
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    storageConfigurationSettings StorageConfigurationSettingsResponse
    Storage Configuration Settings.
    tags {[key: string]: string}
    Resource tags.
    virtualMachineResourceId string
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    wsfcDomainCredentials WsfcDomainCredentialsResponse
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    wsfcStaticIp string
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    id str
    Resource ID.
    location str
    Resource location.
    name str
    Resource name.
    provisioning_state str
    Provisioning state to track the async operation status.
    system_data SystemDataResponse
    Metadata pertaining to creation and last modification of the resource.
    type str
    Resource type.
    assessment_settings AssessmentSettingsResponse
    Assessment Settings.
    auto_backup_settings AutoBackupSettingsResponse
    Auto backup settings for SQL Server.
    auto_patching_settings AutoPatchingSettingsResponse
    Auto patching settings for applying critical security updates to SQL virtual machine.
    identity ResourceIdentityResponse
    Azure Active Directory identity of the server.
    key_vault_credential_settings KeyVaultCredentialSettingsResponse
    Key vault credential settings.
    server_configurations_management_settings ServerConfigurationsManagementSettingsResponse
    SQL Server configuration management settings.
    sql_image_offer str
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    sql_image_sku str
    SQL Server edition type.
    sql_management str
    SQL Server Management type.
    sql_server_license_type str
    SQL Server license type.
    sql_virtual_machine_group_resource_id str
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    storage_configuration_settings StorageConfigurationSettingsResponse
    Storage Configuration Settings.
    tags Mapping[str, str]
    Resource tags.
    virtual_machine_resource_id str
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    wsfc_domain_credentials WsfcDomainCredentialsResponse
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    wsfc_static_ip str
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    id String
    Resource ID.
    location String
    Resource location.
    name String
    Resource name.
    provisioningState String
    Provisioning state to track the async operation status.
    systemData Property Map
    Metadata pertaining to creation and last modification of the resource.
    type String
    Resource type.
    assessmentSettings Property Map
    Assessment Settings.
    autoBackupSettings Property Map
    Auto backup settings for SQL Server.
    autoPatchingSettings Property Map
    Auto patching settings for applying critical security updates to SQL virtual machine.
    identity Property Map
    Azure Active Directory identity of the server.
    keyVaultCredentialSettings Property Map
    Key vault credential settings.
    serverConfigurationsManagementSettings Property Map
    SQL Server configuration management settings.
    sqlImageOffer String
    SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
    sqlImageSku String
    SQL Server edition type.
    sqlManagement String
    SQL Server Management type.
    sqlServerLicenseType String
    SQL Server license type.
    sqlVirtualMachineGroupResourceId String
    ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
    storageConfigurationSettings Property Map
    Storage Configuration Settings.
    tags Map<String>
    Resource tags.
    virtualMachineResourceId String
    ARM Resource id of underlying virtual machine created from SQL marketplace image.
    wsfcDomainCredentials Property Map
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
    wsfcStaticIp String
    Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

    Supporting Types

    AdditionalFeaturesServerConfigurationsResponse

    IsRServicesEnabled bool
    Enable or disable R services (SQL 2016 onwards).
    IsRServicesEnabled bool
    Enable or disable R services (SQL 2016 onwards).
    isRServicesEnabled Boolean
    Enable or disable R services (SQL 2016 onwards).
    isRServicesEnabled boolean
    Enable or disable R services (SQL 2016 onwards).
    is_r_services_enabled bool
    Enable or disable R services (SQL 2016 onwards).
    isRServicesEnabled Boolean
    Enable or disable R services (SQL 2016 onwards).

    AssessmentSettingsResponse

    Enable bool
    Enable or disable assessment feature on SQL virtual machine.
    RunImmediately bool
    Run assessment immediately on SQL virtual machine.
    Schedule Pulumi.AzureNative.SqlVirtualMachine.Inputs.ScheduleResponse
    Schedule for Assessment.
    Enable bool
    Enable or disable assessment feature on SQL virtual machine.
    RunImmediately bool
    Run assessment immediately on SQL virtual machine.
    Schedule ScheduleResponse
    Schedule for Assessment.
    enable Boolean
    Enable or disable assessment feature on SQL virtual machine.
    runImmediately Boolean
    Run assessment immediately on SQL virtual machine.
    schedule ScheduleResponse
    Schedule for Assessment.
    enable boolean
    Enable or disable assessment feature on SQL virtual machine.
    runImmediately boolean
    Run assessment immediately on SQL virtual machine.
    schedule ScheduleResponse
    Schedule for Assessment.
    enable bool
    Enable or disable assessment feature on SQL virtual machine.
    run_immediately bool
    Run assessment immediately on SQL virtual machine.
    schedule ScheduleResponse
    Schedule for Assessment.
    enable Boolean
    Enable or disable assessment feature on SQL virtual machine.
    runImmediately Boolean
    Run assessment immediately on SQL virtual machine.
    schedule Property Map
    Schedule for Assessment.

    AutoBackupSettingsResponse

    BackupScheduleType string
    Backup schedule type.
    BackupSystemDbs bool
    Include or exclude system databases from auto backup.
    DaysOfWeek List<string>
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    Enable bool
    Enable or disable autobackup on SQL virtual machine.
    EnableEncryption bool
    Enable or disable encryption for backup on SQL virtual machine.
    FullBackupFrequency string
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    FullBackupStartTime int
    Start time of a given day during which full backups can take place. 0-23 hours.
    FullBackupWindowHours int
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    LogBackupFrequency int
    Frequency of log backups. 5-60 minutes.
    RetentionPeriod int
    Retention period of backup: 1-90 days.
    StorageAccountUrl string
    Storage account url where backup will be taken to.
    StorageContainerName string
    Storage container name where backup will be taken to.
    BackupScheduleType string
    Backup schedule type.
    BackupSystemDbs bool
    Include or exclude system databases from auto backup.
    DaysOfWeek []string
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    Enable bool
    Enable or disable autobackup on SQL virtual machine.
    EnableEncryption bool
    Enable or disable encryption for backup on SQL virtual machine.
    FullBackupFrequency string
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    FullBackupStartTime int
    Start time of a given day during which full backups can take place. 0-23 hours.
    FullBackupWindowHours int
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    LogBackupFrequency int
    Frequency of log backups. 5-60 minutes.
    RetentionPeriod int
    Retention period of backup: 1-90 days.
    StorageAccountUrl string
    Storage account url where backup will be taken to.
    StorageContainerName string
    Storage container name where backup will be taken to.
    backupScheduleType String
    Backup schedule type.
    backupSystemDbs Boolean
    Include or exclude system databases from auto backup.
    daysOfWeek List<String>
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    enable Boolean
    Enable or disable autobackup on SQL virtual machine.
    enableEncryption Boolean
    Enable or disable encryption for backup on SQL virtual machine.
    fullBackupFrequency String
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    fullBackupStartTime Integer
    Start time of a given day during which full backups can take place. 0-23 hours.
    fullBackupWindowHours Integer
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    logBackupFrequency Integer
    Frequency of log backups. 5-60 minutes.
    retentionPeriod Integer
    Retention period of backup: 1-90 days.
    storageAccountUrl String
    Storage account url where backup will be taken to.
    storageContainerName String
    Storage container name where backup will be taken to.
    backupScheduleType string
    Backup schedule type.
    backupSystemDbs boolean
    Include or exclude system databases from auto backup.
    daysOfWeek string[]
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    enable boolean
    Enable or disable autobackup on SQL virtual machine.
    enableEncryption boolean
    Enable or disable encryption for backup on SQL virtual machine.
    fullBackupFrequency string
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    fullBackupStartTime number
    Start time of a given day during which full backups can take place. 0-23 hours.
    fullBackupWindowHours number
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    logBackupFrequency number
    Frequency of log backups. 5-60 minutes.
    retentionPeriod number
    Retention period of backup: 1-90 days.
    storageAccountUrl string
    Storage account url where backup will be taken to.
    storageContainerName string
    Storage container name where backup will be taken to.
    backup_schedule_type str
    Backup schedule type.
    backup_system_dbs bool
    Include or exclude system databases from auto backup.
    days_of_week Sequence[str]
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    enable bool
    Enable or disable autobackup on SQL virtual machine.
    enable_encryption bool
    Enable or disable encryption for backup on SQL virtual machine.
    full_backup_frequency str
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    full_backup_start_time int
    Start time of a given day during which full backups can take place. 0-23 hours.
    full_backup_window_hours int
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    log_backup_frequency int
    Frequency of log backups. 5-60 minutes.
    retention_period int
    Retention period of backup: 1-90 days.
    storage_account_url str
    Storage account url where backup will be taken to.
    storage_container_name str
    Storage container name where backup will be taken to.
    backupScheduleType String
    Backup schedule type.
    backupSystemDbs Boolean
    Include or exclude system databases from auto backup.
    daysOfWeek List<String>
    Days of the week for the backups when FullBackupFrequency is set to Weekly.
    enable Boolean
    Enable or disable autobackup on SQL virtual machine.
    enableEncryption Boolean
    Enable or disable encryption for backup on SQL virtual machine.
    fullBackupFrequency String
    Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
    fullBackupStartTime Number
    Start time of a given day during which full backups can take place. 0-23 hours.
    fullBackupWindowHours Number
    Duration of the time window of a given day during which full backups can take place. 1-23 hours.
    logBackupFrequency Number
    Frequency of log backups. 5-60 minutes.
    retentionPeriod Number
    Retention period of backup: 1-90 days.
    storageAccountUrl String
    Storage account url where backup will be taken to.
    storageContainerName String
    Storage container name where backup will be taken to.

    AutoPatchingSettingsResponse

    DayOfWeek string
    Day of week to apply the patch on.
    Enable bool
    Enable or disable autopatching on SQL virtual machine.
    MaintenanceWindowDuration int
    Duration of patching.
    MaintenanceWindowStartingHour int
    Hour of the day when patching is initiated. Local VM time.
    DayOfWeek string
    Day of week to apply the patch on.
    Enable bool
    Enable or disable autopatching on SQL virtual machine.
    MaintenanceWindowDuration int
    Duration of patching.
    MaintenanceWindowStartingHour int
    Hour of the day when patching is initiated. Local VM time.
    dayOfWeek String
    Day of week to apply the patch on.
    enable Boolean
    Enable or disable autopatching on SQL virtual machine.
    maintenanceWindowDuration Integer
    Duration of patching.
    maintenanceWindowStartingHour Integer
    Hour of the day when patching is initiated. Local VM time.
    dayOfWeek string
    Day of week to apply the patch on.
    enable boolean
    Enable or disable autopatching on SQL virtual machine.
    maintenanceWindowDuration number
    Duration of patching.
    maintenanceWindowStartingHour number
    Hour of the day when patching is initiated. Local VM time.
    day_of_week str
    Day of week to apply the patch on.
    enable bool
    Enable or disable autopatching on SQL virtual machine.
    maintenance_window_duration int
    Duration of patching.
    maintenance_window_starting_hour int
    Hour of the day when patching is initiated. Local VM time.
    dayOfWeek String
    Day of week to apply the patch on.
    enable Boolean
    Enable or disable autopatching on SQL virtual machine.
    maintenanceWindowDuration Number
    Duration of patching.
    maintenanceWindowStartingHour Number
    Hour of the day when patching is initiated. Local VM time.

    KeyVaultCredentialSettingsResponse

    AzureKeyVaultUrl string
    Azure Key Vault url.
    CredentialName string
    Credential name.
    Enable bool
    Enable or disable key vault credential setting.
    ServicePrincipalName string
    Service principal name to access key vault.
    AzureKeyVaultUrl string
    Azure Key Vault url.
    CredentialName string
    Credential name.
    Enable bool
    Enable or disable key vault credential setting.
    ServicePrincipalName string
    Service principal name to access key vault.
    azureKeyVaultUrl String
    Azure Key Vault url.
    credentialName String
    Credential name.
    enable Boolean
    Enable or disable key vault credential setting.
    servicePrincipalName String
    Service principal name to access key vault.
    azureKeyVaultUrl string
    Azure Key Vault url.
    credentialName string
    Credential name.
    enable boolean
    Enable or disable key vault credential setting.
    servicePrincipalName string
    Service principal name to access key vault.
    azure_key_vault_url str
    Azure Key Vault url.
    credential_name str
    Credential name.
    enable bool
    Enable or disable key vault credential setting.
    service_principal_name str
    Service principal name to access key vault.
    azureKeyVaultUrl String
    Azure Key Vault url.
    credentialName String
    Credential name.
    enable Boolean
    Enable or disable key vault credential setting.
    servicePrincipalName String
    Service principal name to access key vault.

    ResourceIdentityResponse

    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    principalId string
    The Azure Active Directory principal id.
    tenantId string
    The Azure Active Directory tenant id.
    type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    principal_id str
    The Azure Active Directory principal id.
    tenant_id str
    The Azure Active Directory tenant id.
    type str
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

    SQLInstanceSettingsResponse

    Collation string
    SQL Server Collation.
    IsIfiEnabled bool
    SQL Server IFI.
    IsLpimEnabled bool
    SQL Server LPIM.
    IsOptimizeForAdHocWorkloadsEnabled bool
    SQL Server Optimize for Adhoc workloads.
    MaxDop int
    SQL Server MAXDOP.
    MaxServerMemoryMB int
    SQL Server maximum memory.
    MinServerMemoryMB int
    SQL Server minimum memory.
    Collation string
    SQL Server Collation.
    IsIfiEnabled bool
    SQL Server IFI.
    IsLpimEnabled bool
    SQL Server LPIM.
    IsOptimizeForAdHocWorkloadsEnabled bool
    SQL Server Optimize for Adhoc workloads.
    MaxDop int
    SQL Server MAXDOP.
    MaxServerMemoryMB int
    SQL Server maximum memory.
    MinServerMemoryMB int
    SQL Server minimum memory.
    collation String
    SQL Server Collation.
    isIfiEnabled Boolean
    SQL Server IFI.
    isLpimEnabled Boolean
    SQL Server LPIM.
    isOptimizeForAdHocWorkloadsEnabled Boolean
    SQL Server Optimize for Adhoc workloads.
    maxDop Integer
    SQL Server MAXDOP.
    maxServerMemoryMB Integer
    SQL Server maximum memory.
    minServerMemoryMB Integer
    SQL Server minimum memory.
    collation string
    SQL Server Collation.
    isIfiEnabled boolean
    SQL Server IFI.
    isLpimEnabled boolean
    SQL Server LPIM.
    isOptimizeForAdHocWorkloadsEnabled boolean
    SQL Server Optimize for Adhoc workloads.
    maxDop number
    SQL Server MAXDOP.
    maxServerMemoryMB number
    SQL Server maximum memory.
    minServerMemoryMB number
    SQL Server minimum memory.
    collation str
    SQL Server Collation.
    is_ifi_enabled bool
    SQL Server IFI.
    is_lpim_enabled bool
    SQL Server LPIM.
    is_optimize_for_ad_hoc_workloads_enabled bool
    SQL Server Optimize for Adhoc workloads.
    max_dop int
    SQL Server MAXDOP.
    max_server_memory_mb int
    SQL Server maximum memory.
    min_server_memory_mb int
    SQL Server minimum memory.
    collation String
    SQL Server Collation.
    isIfiEnabled Boolean
    SQL Server IFI.
    isLpimEnabled Boolean
    SQL Server LPIM.
    isOptimizeForAdHocWorkloadsEnabled Boolean
    SQL Server Optimize for Adhoc workloads.
    maxDop Number
    SQL Server MAXDOP.
    maxServerMemoryMB Number
    SQL Server maximum memory.
    minServerMemoryMB Number
    SQL Server minimum memory.

    SQLStorageSettingsResponse

    DefaultFilePath string
    SQL Server default file path
    Luns List<int>
    Logical Unit Numbers for the disks.
    DefaultFilePath string
    SQL Server default file path
    Luns []int
    Logical Unit Numbers for the disks.
    defaultFilePath String
    SQL Server default file path
    luns List<Integer>
    Logical Unit Numbers for the disks.
    defaultFilePath string
    SQL Server default file path
    luns number[]
    Logical Unit Numbers for the disks.
    default_file_path str
    SQL Server default file path
    luns Sequence[int]
    Logical Unit Numbers for the disks.
    defaultFilePath String
    SQL Server default file path
    luns List<Number>
    Logical Unit Numbers for the disks.

    SQLTempDbSettingsResponse

    DataFileCount int
    SQL Server tempdb data file count
    DataFileSize int
    SQL Server tempdb data file size
    DataGrowth int
    SQL Server tempdb data file autoGrowth size
    DefaultFilePath string
    SQL Server default file path
    LogFileSize int
    SQL Server tempdb log file size
    LogGrowth int
    SQL Server tempdb log file autoGrowth size
    Luns List<int>
    Logical Unit Numbers for the disks.
    PersistFolder bool
    SQL Server tempdb persist folder choice
    PersistFolderPath string
    SQL Server tempdb persist folder location
    DataFileCount int
    SQL Server tempdb data file count
    DataFileSize int
    SQL Server tempdb data file size
    DataGrowth int
    SQL Server tempdb data file autoGrowth size
    DefaultFilePath string
    SQL Server default file path
    LogFileSize int
    SQL Server tempdb log file size
    LogGrowth int
    SQL Server tempdb log file autoGrowth size
    Luns []int
    Logical Unit Numbers for the disks.
    PersistFolder bool
    SQL Server tempdb persist folder choice
    PersistFolderPath string
    SQL Server tempdb persist folder location
    dataFileCount Integer
    SQL Server tempdb data file count
    dataFileSize Integer
    SQL Server tempdb data file size
    dataGrowth Integer
    SQL Server tempdb data file autoGrowth size
    defaultFilePath String
    SQL Server default file path
    logFileSize Integer
    SQL Server tempdb log file size
    logGrowth Integer
    SQL Server tempdb log file autoGrowth size
    luns List<Integer>
    Logical Unit Numbers for the disks.
    persistFolder Boolean
    SQL Server tempdb persist folder choice
    persistFolderPath String
    SQL Server tempdb persist folder location
    dataFileCount number
    SQL Server tempdb data file count
    dataFileSize number
    SQL Server tempdb data file size
    dataGrowth number
    SQL Server tempdb data file autoGrowth size
    defaultFilePath string
    SQL Server default file path
    logFileSize number
    SQL Server tempdb log file size
    logGrowth number
    SQL Server tempdb log file autoGrowth size
    luns number[]
    Logical Unit Numbers for the disks.
    persistFolder boolean
    SQL Server tempdb persist folder choice
    persistFolderPath string
    SQL Server tempdb persist folder location
    data_file_count int
    SQL Server tempdb data file count
    data_file_size int
    SQL Server tempdb data file size
    data_growth int
    SQL Server tempdb data file autoGrowth size
    default_file_path str
    SQL Server default file path
    log_file_size int
    SQL Server tempdb log file size
    log_growth int
    SQL Server tempdb log file autoGrowth size
    luns Sequence[int]
    Logical Unit Numbers for the disks.
    persist_folder bool
    SQL Server tempdb persist folder choice
    persist_folder_path str
    SQL Server tempdb persist folder location
    dataFileCount Number
    SQL Server tempdb data file count
    dataFileSize Number
    SQL Server tempdb data file size
    dataGrowth Number
    SQL Server tempdb data file autoGrowth size
    defaultFilePath String
    SQL Server default file path
    logFileSize Number
    SQL Server tempdb log file size
    logGrowth Number
    SQL Server tempdb log file autoGrowth size
    luns List<Number>
    Logical Unit Numbers for the disks.
    persistFolder Boolean
    SQL Server tempdb persist folder choice
    persistFolderPath String
    SQL Server tempdb persist folder location

    ScheduleResponse

    DayOfWeek string
    Day of the week to run assessment.
    Enable bool
    Enable or disable assessment schedule on SQL virtual machine.
    MonthlyOccurrence int
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    StartTime string
    Time of the day in HH:mm format. Eg. 17:30
    WeeklyInterval int
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
    DayOfWeek string
    Day of the week to run assessment.
    Enable bool
    Enable or disable assessment schedule on SQL virtual machine.
    MonthlyOccurrence int
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    StartTime string
    Time of the day in HH:mm format. Eg. 17:30
    WeeklyInterval int
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
    dayOfWeek String
    Day of the week to run assessment.
    enable Boolean
    Enable or disable assessment schedule on SQL virtual machine.
    monthlyOccurrence Integer
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    startTime String
    Time of the day in HH:mm format. Eg. 17:30
    weeklyInterval Integer
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
    dayOfWeek string
    Day of the week to run assessment.
    enable boolean
    Enable or disable assessment schedule on SQL virtual machine.
    monthlyOccurrence number
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    startTime string
    Time of the day in HH:mm format. Eg. 17:30
    weeklyInterval number
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
    day_of_week str
    Day of the week to run assessment.
    enable bool
    Enable or disable assessment schedule on SQL virtual machine.
    monthly_occurrence int
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    start_time str
    Time of the day in HH:mm format. Eg. 17:30
    weekly_interval int
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
    dayOfWeek String
    Day of the week to run assessment.
    enable Boolean
    Enable or disable assessment schedule on SQL virtual machine.
    monthlyOccurrence Number
    Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
    startTime String
    Time of the day in HH:mm format. Eg. 17:30
    weeklyInterval Number
    Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

    ServerConfigurationsManagementSettingsResponse

    additionalFeaturesServerConfigurations Property Map
    Additional SQL feature settings.
    sqlConnectivityUpdateSettings Property Map
    SQL connectivity type settings.
    sqlInstanceSettings Property Map
    SQL Instance settings.
    sqlStorageUpdateSettings Property Map
    SQL storage update settings.
    sqlWorkloadTypeUpdateSettings Property Map
    SQL workload type settings.

    SqlConnectivityUpdateSettingsResponse

    ConnectivityType string
    SQL Server connectivity option.
    Port int
    SQL Server port.
    ConnectivityType string
    SQL Server connectivity option.
    Port int
    SQL Server port.
    connectivityType String
    SQL Server connectivity option.
    port Integer
    SQL Server port.
    connectivityType string
    SQL Server connectivity option.
    port number
    SQL Server port.
    connectivity_type str
    SQL Server connectivity option.
    port int
    SQL Server port.
    connectivityType String
    SQL Server connectivity option.
    port Number
    SQL Server port.

    SqlStorageUpdateSettingsResponse

    DiskConfigurationType string
    Disk configuration to apply to SQL Server.
    DiskCount int
    Virtual machine disk count.
    StartingDeviceId int
    Device id of the first disk to be updated.
    DiskConfigurationType string
    Disk configuration to apply to SQL Server.
    DiskCount int
    Virtual machine disk count.
    StartingDeviceId int
    Device id of the first disk to be updated.
    diskConfigurationType String
    Disk configuration to apply to SQL Server.
    diskCount Integer
    Virtual machine disk count.
    startingDeviceId Integer
    Device id of the first disk to be updated.
    diskConfigurationType string
    Disk configuration to apply to SQL Server.
    diskCount number
    Virtual machine disk count.
    startingDeviceId number
    Device id of the first disk to be updated.
    disk_configuration_type str
    Disk configuration to apply to SQL Server.
    disk_count int
    Virtual machine disk count.
    starting_device_id int
    Device id of the first disk to be updated.
    diskConfigurationType String
    Disk configuration to apply to SQL Server.
    diskCount Number
    Virtual machine disk count.
    startingDeviceId Number
    Device id of the first disk to be updated.

    SqlWorkloadTypeUpdateSettingsResponse

    SqlWorkloadType string
    SQL Server workload type.
    SqlWorkloadType string
    SQL Server workload type.
    sqlWorkloadType String
    SQL Server workload type.
    sqlWorkloadType string
    SQL Server workload type.
    sql_workload_type str
    SQL Server workload type.
    sqlWorkloadType String
    SQL Server workload type.

    StorageConfigurationSettingsResponse

    DiskConfigurationType string
    Disk configuration to apply to SQL Server.
    SqlDataSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsResponse
    SQL Server Data Storage Settings.
    SqlLogSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsResponse
    SQL Server Log Storage Settings.
    SqlSystemDbOnDataDisk bool
    SQL Server SystemDb Storage on DataPool if true.
    SqlTempDbSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLTempDbSettingsResponse
    SQL Server TempDb Storage Settings.
    StorageWorkloadType string
    Storage workload type.
    DiskConfigurationType string
    Disk configuration to apply to SQL Server.
    SqlDataSettings SQLStorageSettingsResponse
    SQL Server Data Storage Settings.
    SqlLogSettings SQLStorageSettingsResponse
    SQL Server Log Storage Settings.
    SqlSystemDbOnDataDisk bool
    SQL Server SystemDb Storage on DataPool if true.
    SqlTempDbSettings SQLTempDbSettingsResponse
    SQL Server TempDb Storage Settings.
    StorageWorkloadType string
    Storage workload type.
    diskConfigurationType String
    Disk configuration to apply to SQL Server.
    sqlDataSettings SQLStorageSettingsResponse
    SQL Server Data Storage Settings.
    sqlLogSettings SQLStorageSettingsResponse
    SQL Server Log Storage Settings.
    sqlSystemDbOnDataDisk Boolean
    SQL Server SystemDb Storage on DataPool if true.
    sqlTempDbSettings SQLTempDbSettingsResponse
    SQL Server TempDb Storage Settings.
    storageWorkloadType String
    Storage workload type.
    diskConfigurationType string
    Disk configuration to apply to SQL Server.
    sqlDataSettings SQLStorageSettingsResponse
    SQL Server Data Storage Settings.
    sqlLogSettings SQLStorageSettingsResponse
    SQL Server Log Storage Settings.
    sqlSystemDbOnDataDisk boolean
    SQL Server SystemDb Storage on DataPool if true.
    sqlTempDbSettings SQLTempDbSettingsResponse
    SQL Server TempDb Storage Settings.
    storageWorkloadType string
    Storage workload type.
    disk_configuration_type str
    Disk configuration to apply to SQL Server.
    sql_data_settings SQLStorageSettingsResponse
    SQL Server Data Storage Settings.
    sql_log_settings SQLStorageSettingsResponse
    SQL Server Log Storage Settings.
    sql_system_db_on_data_disk bool
    SQL Server SystemDb Storage on DataPool if true.
    sql_temp_db_settings SQLTempDbSettingsResponse
    SQL Server TempDb Storage Settings.
    storage_workload_type str
    Storage workload type.
    diskConfigurationType String
    Disk configuration to apply to SQL Server.
    sqlDataSettings Property Map
    SQL Server Data Storage Settings.
    sqlLogSettings Property Map
    SQL Server Log Storage Settings.
    sqlSystemDbOnDataDisk Boolean
    SQL Server SystemDb Storage on DataPool if true.
    sqlTempDbSettings Property Map
    SQL Server TempDb Storage Settings.
    storageWorkloadType String
    Storage workload type.

    SystemDataResponse

    CreatedAt string
    The timestamp of resource creation (UTC).
    CreatedBy string
    The identity that created the resource.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    The type of identity that last modified the resource.
    CreatedAt string
    The timestamp of resource creation (UTC).
    CreatedBy string
    The identity that created the resource.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    The type of identity that last modified the resource.
    createdAt String
    The timestamp of resource creation (UTC).
    createdBy String
    The identity that created the resource.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    The type of identity that last modified the resource.
    createdAt string
    The timestamp of resource creation (UTC).
    createdBy string
    The identity that created the resource.
    createdByType string
    The type of identity that created the resource.
    lastModifiedAt string
    The timestamp of resource last modification (UTC)
    lastModifiedBy string
    The identity that last modified the resource.
    lastModifiedByType string
    The type of identity that last modified the resource.
    created_at str
    The timestamp of resource creation (UTC).
    created_by str
    The identity that created the resource.
    created_by_type str
    The type of identity that created the resource.
    last_modified_at str
    The timestamp of resource last modification (UTC)
    last_modified_by str
    The identity that last modified the resource.
    last_modified_by_type str
    The type of identity that last modified the resource.
    createdAt String
    The timestamp of resource creation (UTC).
    createdBy String
    The identity that created the resource.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    The type of identity that last modified the resource.

    WsfcDomainCredentialsResponse

    ClusterBootstrapAccountPassword string
    Cluster bootstrap account password.
    ClusterOperatorAccountPassword string
    Cluster operator account password.
    SqlServiceAccountPassword string
    SQL service account password.
    ClusterBootstrapAccountPassword string
    Cluster bootstrap account password.
    ClusterOperatorAccountPassword string
    Cluster operator account password.
    SqlServiceAccountPassword string
    SQL service account password.
    clusterBootstrapAccountPassword String
    Cluster bootstrap account password.
    clusterOperatorAccountPassword String
    Cluster operator account password.
    sqlServiceAccountPassword String
    SQL service account password.
    clusterBootstrapAccountPassword string
    Cluster bootstrap account password.
    clusterOperatorAccountPassword string
    Cluster operator account password.
    sqlServiceAccountPassword string
    SQL service account password.
    cluster_bootstrap_account_password str
    Cluster bootstrap account password.
    cluster_operator_account_password str
    Cluster operator account password.
    sql_service_account_password str
    SQL service account password.
    clusterBootstrapAccountPassword String
    Cluster bootstrap account password.
    clusterOperatorAccountPassword String
    Cluster operator account password.
    sqlServiceAccountPassword String
    SQL service account password.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
    pulumi/pulumi-azure-native