Condividi tramite

  • Articolo

Proprietà FilePath

Gets or sets the location of the folder where the audit file is stored when the audit type is a file.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FilePath As String
    Get
    Set
'Utilizzo
Dim instance As Audit
Dim value As String

value = instance.FilePath

instance.FilePath = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string FilePath { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ FilePath {
    String^ get ();
    void set (String^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member FilePath : string with get, set

function get FilePath () : String
function set FilePath (value : String)

Valore proprietà

Tipo: System. . :: . .String
A String value that specifies the path of the file in which the audit log information is recorded.

Osservazioni

You can set the audit destination type using the AuditDestinationType()()()() property.

Esempi

The following code example shows how to get the path of the destination audit log 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)");
            dbAudit.DestinationType = AuditDestinationType.File;
            dbAudit.FilePath = "C:\\AuditDirectory";
            Audit dbAudit = new Audit(dbServer, "Test Audit");
            dbAudit.Create();

            //Display the path of the audit log file on the console
            Console.Writeline("The path of the audit log file is: " +
                              dbAudit.FilePath);
        }
    }
}

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 path of the audit log file
Write-Host "The path of the audit log file is:" $dbAudit.FilePath