"Thought I had it....

How would I need to adjust the macro to include information between two
dates?"


Try this...

select
nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024
as decimal(6,2)))
as GB from nodes, summary  where (end_time between current_timestamp - $1
hours and
current_timestamp - $2 hours) and (activity='BACKUP' or activity='RESTORE'
or activity='ARCHIVE' or
activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by
domain_name,summary.activity

$1 is the start time in hour past... like 72 for three days
$2 is the end time


curtis.stewart AT lawson DOT com