Get-AzureRmSqlDatabaseThreatDetectionPolicy

NAME Get-AzureRmSqlDatabaseThreatDetectionPolicy



SYNOPSIS

Gets the threat detection policy for a database.





SYNTAX

Get-AzureRmSqlDatabaseThreatDetectionPolicy [-ResourceGroupName] <String> [-ServerName] <String> [-DatabaseName] <String> [-DefaultProfile

<IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

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

ResourceGroupName , ServerName , and DatabaseName parameters to identify the database for which this cmdlet gets the policy.





PARAMETERS

-DatabaseName <String>

Specifies the name of a database.



Required? true

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-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 is assigned.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of a server.



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



You cannot pipe input to this cmdlet.





OUTPUTS

Microsoft.Azure.Commands.Sql.ThreatDetection.Model.DatabaseThreatDetectionPolicyModel

This cmdlet returns a Model.DatabaseThreatDetectionPolicyModel object.





NOTES









Example 1: Get the threat detection policy for a database



PS C:\\>Get-AzureRmSqlDatabaseThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

DatabaseName : Database01

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 database named Database01. The database is located on the server named Server01, which is

assigned to the resource group ResourceGroup11.







RELATED LINKS

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

Remove-AzureRmSqlDatabaseThreatDetectionPolicy