dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Get-DbaServerAuditSpecification

Gets SQL Security Audit Specification information for each instance(s) of SQL Server.

Screenshots

Examples

Returns all Security Audit Specifications on the local default SQL Server instance.

Get-DbaServerAuditSpecification -SqlInstance localhost

Returns all Security Audit Specifications for the local and sql2016 SQL Server instances.

Get-DbaServerAuditSpecification -SqlInstance localhost, sql2016

Author

This command was created by Garry Bargsley. You can find Garry on Twitter and his blog.

Get-Help

From PowerShell, execute Get-Help Get-DbaServerAuditSpecification -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaServerAuditSpecification.ps1 on GitHub
 

Related commands