DatabaseExtendedAuditingPolicyArgs

data class DatabaseExtendedAuditingPolicyArgs(val databaseId: Output<String>? = null, val enabled: Output<Boolean>? = null, val logMonitoringEnabled: Output<Boolean>? = null, val retentionInDays: Output<Int>? = null, val storageAccountAccessKey: Output<String>? = null, val storageAccountAccessKeyIsSecondary: Output<Boolean>? = null, val storageEndpoint: Output<String>? = null) : ConvertibleToJava<DatabaseExtendedAuditingPolicyArgs>

Manages a MS SQL Database Extended Auditing Policy.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.mssql.Server;
import com.pulumi.azure.mssql.ServerArgs;
import com.pulumi.azure.mssql.Database;
import com.pulumi.azure.mssql.DatabaseArgs;
import com.pulumi.azure.storage.Account;
import com.pulumi.azure.storage.AccountArgs;
import com.pulumi.azure.mssql.DatabaseExtendedAuditingPolicy;
import com.pulumi.azure.mssql.DatabaseExtendedAuditingPolicyArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
.location("West Europe")
.build());
var exampleServer = new Server("exampleServer", ServerArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.version("12.0")
.administratorLogin("missadministrator")
.administratorLoginPassword("AdminPassword123!")
.build());
var exampleDatabase = new Database("exampleDatabase", DatabaseArgs.builder()
.serverId(exampleServer.id())
.build());
var exampleAccount = new Account("exampleAccount", AccountArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.accountTier("Standard")
.accountReplicationType("LRS")
.build());
var exampleDatabaseExtendedAuditingPolicy = new DatabaseExtendedAuditingPolicy("exampleDatabaseExtendedAuditingPolicy", DatabaseExtendedAuditingPolicyArgs.builder()
.databaseId(exampleDatabase.id())
.storageEndpoint(exampleAccount.primaryBlobEndpoint())
.storageAccountAccessKey(exampleAccount.primaryAccessKey())
.storageAccountAccessKeyIsSecondary(false)
.retentionInDays(6)
.build());
}
}

Import

MS SQL Database Extended Auditing Policies can be imported using the resource id, e.g.

$ pulumi import azure:mssql/databaseExtendedAuditingPolicy:DatabaseExtendedAuditingPolicy example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.Sql/servers/sqlServer1/databases/db1/extendedAuditingSettings/default

Constructors

Link copied to clipboard
fun DatabaseExtendedAuditingPolicyArgs(databaseId: Output<String>? = null, enabled: Output<Boolean>? = null, logMonitoringEnabled: Output<Boolean>? = null, retentionInDays: Output<Int>? = null, storageAccountAccessKey: Output<String>? = null, storageAccountAccessKeyIsSecondary: Output<Boolean>? = null, storageEndpoint: Output<String>? = null)

Functions

Link copied to clipboard
open override fun toJava(): DatabaseExtendedAuditingPolicyArgs

Properties

Link copied to clipboard
val databaseId: Output<String>? = null

The ID of the SQL database to set the extended auditing policy. Changing this forces a new resource to be created.

Link copied to clipboard
val enabled: Output<Boolean>? = null

Whether to enable the extended auditing policy. Possible values are true and false. Defaults to true. ->NOTE: If enabled is true, storage_endpoint or log_monitoring_enabled are required.

Link copied to clipboard
val logMonitoringEnabled: Output<Boolean>? = null
Link copied to clipboard
val retentionInDays: Output<Int>? = null

The number of days to retain logs for in the storage account. Defaults to 0.

Link copied to clipboard
val storageAccountAccessKey: Output<String>? = null

The access key to use for the auditing storage account.

Link copied to clipboard

Is storage_account_access_key value the storage's secondary key?

Link copied to clipboard
val storageEndpoint: Output<String>? = null

The blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all extended auditing logs.