Re: Escalation Reports

[Bruce Scott]

James,

An escalation is about the only Remedy way to do this.  Here is an
excerpt from the Runmacro vs Macro in client thread from earlier this
month:

I recently did something very similar and encounter some of the issues
you are seeing.  What I have is an escalation (because the report is
needed on a reoccurring basis to meet audit requirements) which has a
Run Process action.  The command line of the Run Process looks like:
 
c:\\progra~1\\remedy\\reports\\report.bat $zTmpDate$
 
where $zTmpDate$ is a variable I pass to the file being generated to
make it unique.
 
The batch file (report.bat) looks like:
 
@Echo Off
copycmd=/Y
Set filedate=%1
C:\Progra~1\ARSyst~1\runmacro.exe -x remedydev01 -U Username -P password
-d C:\Progra~1\Remedy\Reports -e ChangeCo
copy c:\\progra~1\\remedy\\reports\\weekly\\changecontrolmeeting_.csv
c:\\progra~1\\remedy\\reports\\weekly\\ChangeControlMeeting_%filedate%.c
sv
 
Finally, my macro looks like this:
 
ChangeCo
Set-schema: PETM:ISChangeControlRequest
remedyapp01
Query: 
1707200=true
1707100=true
1707000=false
1706900=true
(( '7' =
"Approved" AND '536871106' = "Open") OR ( '7' = "Pending" AND
'536871106' != "Closed")) AND '536870921' >= $-4$ AND '536870921' <
($-4$+7*24*60*60)
Report: 
21=1
1=1
3=Change Control
Meeting
4=
5=
6=
13=
23=0
7=72
10=96
8=1
9=1
11=0
12=0
20=7
16=-
17=
18=
1
19=7
2=1Change Req ID050536870921Implementation
Start045536870923Change
Type025200000004Type040536870914Change
Owner0407Approval0308Short Description0100536870919Risk
Lvl015536870920Outage015

report-sort: 0|2|536870921\1|1\1|

Statistics: 
 
to-file: C:\Progra~1\Remedy\Reports\Weekly\ChangeControlMeeting_.csv
O
end
 
Part of the no file issue you are seeing seems to be related to the way
the command line interface treats the DOS-like commands, which is why
there are doubled slashes in the batch and command line of the run
process.  Make sure that the name of the macro (seen above, first line
of the macro) matches the macro name in the runmacro command (end of the
third line of the batch file above).

Let me know if you have any questions. 


Thanks,
Bruce Scott
Application Developer - Remedy
SSG, PetSMART, Inc.
eMail:  [EMAIL PROTECTED]



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of James Collins
Sent: Wednesday, January 31, 2007 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Escalation Reports

Hello,

I have a requirement where I have to run a report once a week collecting
the number of entries for a particular form with all of the appropriate
data.  I can create the report, but do not see a convenient and well
thought out way via Remedy to have this run automatically through its
workflow.  I thought perhaps an escalation. 

Any Suggestions?

James Collins

________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"



#####################################################################################
The information contained in this electronic mail message, including 
attachments, if any, is PetSmart confidential information.  It is intended only 
for the use of the person(s) named above.  If the reader of this message is not 
the intended recipient, or has received this message in error, you are hereby 
notified that any review, dissemination, distribution or copying of this 
communication is strictly prohibited.  If you are not the intended recipient or 
have received this message in error, please notify the sender via e-mail and 
promptly delete the original message.
#####################################################################################

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"