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)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property DateLastModified As DateTime
Get
'Usage
Dim instance As Audit
Dim value As DateTime
value = instance.DateLastModified
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public DateTime DateLastModified { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property DateTime DateLastModified {
DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DateLastModified : DateTime
function get DateLastModified () : DateTime
Property Value
Type: System.DateTime
A DateTime system object value that specifies the time and date when the audit log was last modified.
Examples
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