Automating the collection of Reports from Remedy

I am trying to automate the collection of remedy reports. I have already created a macro in remedy to collect the data and export it to 4 different files.

Then I use a windows script to combine all 4 files into one report.

Finally I post this report to an email and send it. I need to do this everyday. Is there anyway to automate this process?
bbcacAsked:
Who is Participating?
 
souseranConnect With a Mentor Commented:
For that part, you'll want a Windows Macro Recorder utility like AutoIt:

http://www.nonags.com/nonags/auto.html
0
 
souseranCommented:
Can you use Windows Task Scheduler? Assuming you're in Windows XP, see this Microsoft article:

How To Schedule Tasks in Windows XP

http://support.microsoft.com/kb/308569
0
 
souseranCommented:
You could use a "mailto" URL like the following, to open an e-mail window with a file attached:

mailto:recipient@location.net?subject="remedy report"&body="see attachment"&attachment="\\servert\folder\remedyreportfile.ext"

Within the email client, set up a rule, filter, or whatever, to auto-send messages with recipient@location.net in the To line.
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
bbcacAuthor Commented:
My first hurdle is to some how automate the running of the macro... I have to be in remedy and choose Tools > Macro > and then the appropriate macro... is there anyway to do that?
0
 
bbcacAuthor Commented:
I am trying to figure out how to use AutoIt. When I do I will let you know if this will work.

With AutoIt do the simulated mouse clicks always click the same spot on the screen, or is it smart enough to see what application window you are choosing?

0
 
bbcacAuthor Commented:
AutoIt works fine now. My issue is this. What if I want the task to run while the computer is locked? I don't want to have to log in manually to the server every day. The goal is to automate the report production
0
 
bbcacAuthor Commented:
Works great
0
All Courses

From novice to tech pro — start learning today.