We help IT Professionals succeed at work.

Automating the collection of Reports from Remedy

bbcac
bbcac asked
on
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?
Comment
Watch Question

Commented:
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

Commented:
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.

Author

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?
Commented:
For that part, you'll want a Windows Macro Recorder utility like AutoIt:

http://www.nonags.com/nonags/auto.html

Author

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?

Author

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

Author

Commented:
Works great

Explore More ContentExplore courses, solutions, and other research materials related to this topic.