Thanks, Bill.

I'll probably implement this in SSRS until version 5 is out.

Getting the data directly from the database is possible but probably a little cumbersome. The descriptions of the objects aren't stored, so you would have to take the OID from each record, join to the correct table, and work out the name/description for each object.

You do this easily through the API using the QueryChangeLog method, which returns a collection of ObjectChangeLog objects.

Here's a quick example that gets all changes for the past 7 days.

void QueryChangeLog(string serverName)
{
	using (var session = Scheduler.Connect(ServerName, LoginAuthenticationType.Windows, "", ""))
	{
		var parms=new ChangeLogQueryParameters();
		parms.ExcludeSystemGenerated=true;	//don't include changes made by the system, e.g., jobs held by job control action
		parms.IncludeObjectDescriptions=true;	//resolve the objects and populate the ObjectDescription field. Otherwise it will be empty.
		parms.AuditOnly=true;	//only get audit records, not snapshot-only records 
		
		parms.EndTimestamp=DateTime.UtcNow;
		parms.StartTimestamp=parms.EndTimestamp.Value.Subtract(TimeSpan.FromDays(7));

		var records = session.QueryChangeLog(parms);
		foreach (var record in records)
		{
			if (record.ChangeType == ObjectChangeType.Delete)
			{
				Console.WriteLine(record.ChangeType + ": " + record.TargetClassName + ": " + record.DeletedObjectDescription);
			}
			else
			{
				Console.WriteLine(record.ChangeType + ": " + record.TargetClassName + ": " + record.ObjectDescription);
			}
		}
	}
}

This worked great. It's exactly what I needed.

I don't have the ExcludeSystemGenerated property of the ChangeLogQueryParameters object. Is that a new property? I'm using version 4.3.1.1 of the ArcanaDevelopment.adTempus.Shared class.

Yes, it got added later. Without that you may get a lot of change records you don't want. For example, if a Job Control Action modifies a job (by putting it on hold or setting a variable, for example), an audit record will get generated.

To skip these In your code, you can ignore records where record.SecurityLogin is null.