Azure Native v2.21.0, Dec 5 23

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.21.0 published on Tuesday, Dec 5, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sqlvirtualmachine.getSqlVirtualMachine

Explore with Pulumi AI

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.21.0 published on Tuesday, Dec 5, 2023 by Pulumi

pulumi/pulumi-azure-native

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)
// Output-based functions aren't available in Java yet

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 Pulumi.AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
SqlConnectivityUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
SqlInstanceSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLInstanceSettingsResponse: SQL Instance settings.
SqlStorageUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsResponse: SQL storage update settings.
SqlWorkloadTypeUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

AdditionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
SqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
SqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
SqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
SqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additional_features_server_configurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sql_connectivity_update_settings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sql_instance_settings SQLInstanceSettingsResponse: SQL Instance settings.
sql_storage_update_settings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sql_workload_type_update_settings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

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

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.21.0 published on Tuesday, Dec 5, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sqlvirtualmachine.getSqlVirtualMachine

On this page

On this page

Using getSqlVirtualMachine

getSqlVirtualMachine Result

Supporting Types

AdditionalFeaturesServerConfigurationsResponse

AssessmentSettingsResponse

AutoBackupSettingsResponse

AutoPatchingSettingsResponse

KeyVaultCredentialSettingsResponse

ResourceIdentityResponse

SQLInstanceSettingsResponse

SQLStorageSettingsResponse

SQLTempDbSettingsResponse

ScheduleResponse

ServerConfigurationsManagementSettingsResponse

SqlConnectivityUpdateSettingsResponse

SqlStorageUpdateSettingsResponse

SqlWorkloadTypeUpdateSettingsResponse

StorageConfigurationSettingsResponse

SystemDataResponse

WsfcDomainCredentialsResponse

Package Details

On this page

On this page