"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 [EMAIL PROTECTED]
