This post is more than 5 years old
20 Posts
0
836
How to create a report with specific duration criteria
Hi
I'm currently using a report called All Save Sets in DPA v5.8.1.
Now I need only to see output of which duration is greater than 24 hour, but I can't find a condition or an operator to use for the purpose.
/Tommy
DavidRussell1
141 Posts
0
August 9th, 2011 02:00
Hi Tommy,
The duration field isn't an actual field in the DPA database and therefore you can't condition on the data source for it. The duration field is calculated by the "Extended Save Set Info" operator so you need to add the condition on that operator. As DPA stores durations and dates/times as integers you would need to use seconds in the condition. So to only return save sets over 24 hours in duration you would need to add a condition on the Extended Save Set Info operator of Duration greater than 86400.
Thanks
David
David Russell
EMC Technical Support
TbeckDK
20 Posts
0
August 9th, 2011 02:00
Thank you for the quick responce...
That was just what I needed :-)
dplaflamme1
37 Posts
0
August 9th, 2011 06:00
You may need to make the field you want to use Time to Duration on a key field. Depending on your input stream, that might not be necessary, but keep SetKey in mind as well.