I'm making a report to indicate last successful full backup of savesets (and also a second version of this where I filter the results to report only before a specified date).  However I've noticed when comparing to mminfo output that some of the information is erroneous, I was wondering if anyone has any suggestions as to why this data is not working correctly.

My report is something like this:

Backup Save Set Details

(server, sub name,group,schedule,client,save set,domain name,queue start)

(period=epoch to current time, no interval)

(node=default)

(conditions: level=full AND status=success)

(no limit)

(Order by Queue Start ascending, no limit)

(no smoothing)

I

V

Group By [I believe this is where the report is failing as it is not clear how the grouping would respond with a date]

(Default Duration=Max, Number=Max, Percent=Average, String=last, GroupBy1/2/3: Server, Client, Saveset)

(Fields drop: Sub Name, Group, Schedule, Domain Name)

I

V

Join the following data source (this is to remove inactive clients from the results):

Backup Client Config

(Server, Sub Name, Client)

(Time default settings)

(Node defaults)

(Conditions: active=true)

(no limit, no order)

I

V

Order

(Order by client, ascending)

(Drop Sub Name)

The following is amended to for the report to report when the backup time is before a specified time:

(Conditions: queue start less than start time)

Any suggestions to fix this gladly accepted!