Audit.Guid Audit.Guid Audit.Guid Property

Definition

Gets or sets the unique system identifier for the referenced audit.

public:
 property Guid Guid { Guid get(); void set(Guid value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.ReadOnlyAfterCreation | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public Guid Guid { get; set; }
Public Property Guid As Guid
Property Value

A Guid value that specifies a unique system identifier for the referenced audit.

Examples

The following code example shows how to generate a unique audit GUID and display it on the console.

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();  

            //Get the GUID and display it on the console  
            Console.WriteLine("The GUID of the audit log file is: " +  
                              dbAudit.Guid);  
        }  
    }  
}  

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()  

#Get and display the GUID  
Write-Host "The GUID of the audit log file is:" $dbAudit.Guid  

Applies to