Macro to return only certain times of tickets

[troyu]

I would like to build a macro that would return only certain times of the day for say 4 days in a row.

For example, I would like to see tickets created from 4am - 8am from Mon-Fri. I do not want to see tickets that were created outside of these times.

Any ideas?

 

[RmdyJoe]

Why not use a escalation that calls a macro for those particular time?

 

[troyu]

I would like the macro to return tickets for an entire month for example, excluding weekends.

 

[RmdyJoe]

Then you might need to use SQL.

 

[DaveStL]

Worst case scenario, you may have to query for each date/time range (for example, ('Create Date' >= &quot;2/1/02 4:00:00AM&quot; AND 'Create Date' < &quot;2/1/02 8:00:00AM&quot OR
('Create Date' >= &quot;2/4/02 4:00:00AM&quot; AND 'Create Date' < &quot;2/4/02 8:00:00AM&quot OR...... and so on). Depending on which database you are using behind Remedy, you may find easier ways of doing this. But this should do the job.