Get-AzureRmSqlServerThreatDetectionPolicy

NAME Get-AzureRmSqlServerThreatDetectionPolicy



SYNOPSIS

Gets the threat detection policy for a server.





SYNTAX

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

[-WhatIf] [<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlServerThreatDetectionPolicy cmdlet gets the threat detection policy of an Azure SQL server. To use this cmdlet, specify the

ResourceGroupName and ServerName parameters to identify the server for which this cmdlet gets the policy.





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>

Specifies the name of the resource group to which the server belongs.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the server.



Required? true

Position? named

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.ThreatDetection.Model.ServerThreatDetectionPolicyModel







NOTES









Example 1: Get the threat detection policy for a server



PS C:\\>Get-AzureRmSqlServerThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

ResourceGroupName : ResourceGroup11

ServerName : Server01

ThreatDetectionState : Enabled

NotificationRecipientsEmails : admin@myCompany.com

StorageAccountName : mystorage

EmailAdmins : True

ExcludedDetectionTypes : {}

RetentionInDays : 0



This command gets the threat detection policy for a server named Server01. The server is assigned to the resource group ResourceGroup11.







RELATED LINKS

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

Remove-AzureRmSqlDatabaseThreatDetectionPolicy

SQL Database Documentation https://docs.microsoft.com/azure/sql-database/