Audit.FileName Propiedad
Gets the name of the file in which the audit log information is recorded, when the audit destination is a file.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property FileName As String
Get
'Uso
Dim instance As Audit
Dim value As String
value = instance.FileName
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string FileName { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ FileName {
String^ get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member FileName : string
function get FileName () : String
Valor de la propiedad
Tipo: System.String
A String value that specifies the name of the file in which the audit log information is recorded.
Comentarios
You can set the audit destination type using the AuditDestinationType property.
Ejemplos
The following code example shows how to get the name of the audit destination file.
C#
using System;
using Microsoft.SqlServer.Management.Smo;
namespace samples
{
class Program
{
static void Main(string[] args)
{
//Create the audit
Server dbServer = new Server("(local)");
Audit dbAudit = new Audit(dbServer, "Test Audit");
dbAudit.DestinationType = AuditDestinationType.File;
dbAudit.FilePath = "C:\\AuditDirectory";
dbAudit.Create();
//Display the file name information on the console
Console.Writeline("The audit filename is: " +
dbAudit.FileName);
}
}
}
Powershell
#Create the audit
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$dbAudit = New-Object Microsoft.SqlServer.Management.Smo.Audit($dbServer, "Test Audit")
$dbAudit.DestinationType = [Microsoft.SqlServer.Management.Smo.AuditDestinationType]'File'
$dbAudit.FilePath = "C:\AuditDirectory"
$dbAudit.Create()
#Display the file name information
Write-Host "The audit filename is:" $dbAudit.FileName