/// <summary>
/// Transforms the given database policy object to its cmdlet model representation
/// </summary>
private DatabaseAuditingPolicyModel ModelizeDatabaseAuditPolicy(DatabaseAuditingPolicy policy)
{
DatabaseAuditingPolicyModel dbPolicyModel = new DatabaseAuditingPolicyModel();
DatabaseAuditingPolicyProperties properties = policy.Properties;
dbPolicyModel.AuditState = ModelizeAuditState(properties.AuditingState);
dbPolicyModel.UseServerDefault = properties.UseServerDefault == Constants.AuditingEndpoint.Enabled ? UseServerDefaultOptions.Enabled : UseServerDefaultOptions.Disabled;
ModelizeStorageInfo(dbPolicyModel, properties.StorageAccountName, properties.StorageAccountKey, properties.StorageAccountSecondaryKey);
ModelizeEventTypesInfo(dbPolicyModel, properties.EventTypesToAudit);
return(dbPolicyModel);
}
/// <summary>
/// Transforms the given database policy object to its cmdlet model representation
/// </summary>
private DatabaseAuditingPolicyModel ModelizeDatabaseAuditPolicy(DatabaseAuditingPolicy policy)
{
var dbPolicyModel = new DatabaseAuditingPolicyModel();
var properties = policy.Properties;
dbPolicyModel.AuditState = ModelizeAuditState(properties.AuditingState);
dbPolicyModel.UseServerDefault = properties.UseServerDefault == SecurityConstants.AuditingEndpoint.Enabled ? UseServerDefaultOptions.Enabled : UseServerDefaultOptions.Disabled;
ModelizeStorageInfo(dbPolicyModel, properties.StorageAccountName, properties.StorageAccountKey, properties.StorageAccountSecondaryKey);
ModelizeEventTypesInfo(dbPolicyModel, properties.EventTypesToAudit);
ModelizeRetentionInfo(dbPolicyModel, properties.RetentionDays, properties.AuditLogsTableName, properties.FullAuditLogsTableName);
return(dbPolicyModel);
}
/// <summary>
/// Provides a database audit policy model for the given database
/// </summary>
public DatabaseAuditingPolicyModel GetDatabaseAuditingPolicy(string resourceGroup, string serverName, string databaseName, string requestId)
{
DatabaseAuditingPolicy policy = Communicator.GetDatabaseAuditingPolicy(resourceGroup, serverName, databaseName, requestId);
DatabaseAuditingPolicyModel dbPolicyModel = ModelizeDatabaseAuditPolicy(policy);
dbPolicyModel.ResourceGroupName = resourceGroup;
dbPolicyModel.ServerName = serverName;
dbPolicyModel.DatabaseName = databaseName;
FetchedStorageAccountName = policy.Properties.StorageAccountName;
FetchedStorageAccountResourceGroup = policy.Properties.StorageAccountResourceGroupName;
FetchedStorageAccountSubscription = policy.Properties.StorageAccountSubscriptionId;
FetchedStorageAccountTableEndpoint = policy.Properties.StorageTableEndpoint;
return dbPolicyModel;
}
/// <summary>
/// Gets the database auditing policy for the given database in the given database server in the given resource group
/// </summary>
public void GetDatabaseAuditingPolicy(string resourceGroupName, string serverName, string databaseName, string clientRequestId, out DatabaseAuditingPolicy policy)
{
IAuditingPolicyOperations operations = GetCurrentSqlClient(clientRequestId).AuditingPolicy;
DatabaseAuditingPolicyGetResponse response = operations.GetDatabasePolicy(resourceGroupName, serverName, databaseName);
policy = response.AuditingPolicy;
}
