Export (0) Print
Expand All

Audit.DateLastModified Property

Gets the date and time when the audit log was last modified.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)]
public DateTime DateLastModified { get; }

Property Value

Type: DateTime
A DateTime system object value that specifies the time and date when the audit log was last modified.

The following code example demonstrates how to get the date and time when the audit log was last modified, and displays that information 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();

            //Display the date of the most recent modification to the 
            //log on the console
            DateTime auditModificationDate = dbAudit.DateLastModified;
            Console.WriteLine("The most recent modification of the  
                              audit log was made on " + 
                              auditModificationDate.ToString());
        }
    }
}

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 date of the most recent modification to the log
Write-Host "The most recent modification of the audit log was made on" 
            $dbAudit.DateLastModified
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft