Announcement Banner
UNSOLVED

mryan193

updated

7 years ago

M

mryan193

1 Rookie

•

10 Posts

0

1971

March 22nd, 2019 12:00

DPA Report on Restores & Duration since Backup

So I'm working on creating this report that will generate a list of Restore Jobs which will include the "Started" timestamp of the Restore and the Timestamp of the Backup that the Restore is being processed from.

I'm working with the "Restore Details" data source... and I thought the Backup timestamp would be the "Recorded Date Time", but now I'm wondering if that's incorrect.  (Insight on that would be welcomed.)

Then, I'm feeding it all through "Subtract Fields" operator which generates (Duration-between-B-and-R = Started - Recorded Date Time).  Seems simple enough, right?  However, the "Duration-between-B-and-R" column is always coming out blank... and I've no idea what I'm doing wrong.

Would anyone be generous enough to assist me with this and let me know what I'm doing wrong?