Propriedade do RDL Audit.DateLastModified
Gets the date and time when the audit log was last modified.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property DateLastModified As DateTime
Get
'Uso
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
Valor da propriedade
Tipo: System.DateTime
A DateTime system object value that specifies the time and date when the audit log was last modified.
Exemplos
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