Hello, Wondering if anyone might have suggestion for best way to obtain
snapshot stats of # of Cases open at a particular time each week (say,
midnight on Wednesdays).
I can run a Query with a search like:
'Created' = 10/9/2008 AND ('Resolved' 10/9/2008 OR 'Status*'
Resolved)
which
Hi Julie,
Are you trying to do the report in Remedy or are you using another tool? If
you're doing it in Remedy, you can have a macro simply run the query and use
the $DATE$ keyword to get the results you wanted. If you're using SSRS, you can
do the same thing and set up a subscription to the
One way to do this is to use an Escalation which runs every night during
off-hours. The setup is the following:
1. Create an Integer field with Administrator only permissions - I
usually call it Days Open
2. Setup an Escalation which performs Days Open = Days Open +1
every night on each
Take a look at flashboard variables, I think that is the easiest thing to
setup. Displaying more than a few flashboards requires a license, however,
the variables are free and there may be another way to query those without
using a flashboard.
Brien
On Mon, Nov 24, 2008 at 7:53 AM, Frank,
4 matches
Mail list logo