Get-AzureRmSqlServerAuditing

NAME Get-AzureRmSqlServerAuditing



SYNOPSIS

Gets the auditing settings of an Azure SQL server.





SYNTAX

Get-AzureRmSqlServerAuditing [-ResourceGroupName] <String> [-ServerName] <String> [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf]

[<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlServerAuditing cmdlet gets the blob auditing policy of an Azure SQL server. Specify the ResourceGroupName and ServerName

parameters to identify the database. This cmdlet returns a policy that is used by the Azure SQL databases that are defined in the specified Azure

SQL server.





PARAMETERS

-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ResourceGroupName <String>

The name of the resource group.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

SQL server name.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.Security.Model.ServerBlobAuditingSettingsModel







NOTES









Example 1: Get the auditing settings of an Azure SQL server



PS C:\\>Get-AzureRmSqlServerAuditing -ResourceGroupName "resourcegroup01" -ServerName "server01"

AuditActionGroup : {SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP,

BATCH_COMPLETED_GROUP, ...}

ResourceGroupName : resourcegroup01

ServerName : server01

AuditState : Enabled

StorageAccountName : mystorage

StorageKeyType : Primary

RetentionInDays : 0











RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... erauditing