Thanks John. Your post gives a new idea. I could have a perl cgi accessed by
the external entity through http. Since this cgi can be in unix, it's easy for
me to do here.
---
I got runmacro.exe to work, but it's awfully slow. Takes 10+ seconds to query
for one record. The trick is to use the -o flag. It cause runmacro to do
something other than run a macro...do a straight query instead.
---
C:\> runmacro.exe -o "c:\temp\test3.txt" -f HPD:HelpDesk -t csv -x server.com
-U "<username>" -P "<password>"
-Q "4\1\1\1\2\4\15\HD0000000700000\"
Action Request System Runmacro.exe Version 6.3
Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved.
Accessing server - server.com ...
Processing form - HPD:HelpDesk ...
Processing complete with total matches of 1 record(s).
Server - server.com access complete with total matches of 1 record(s).
----
Record detail got dumped into the file test3.txt
I used -Q with internal qualification format, because I couldn't get -q
<readable qualification> ('Entry Id' = "HD0000000700000") to work. Something
with double quotes in windows command line. I tried a zillion things, always
getting error on qualification.
The -Q parameter means:
'1' = "HD0000000700000"
meaning
'Entry Id' = "HD0000000700000"
If you change -o "<filename>" to
-o ""
no file is created with the record's field values; instead, the record is
dumped on the screen. May be useful.
This is an awesome (effortless) way for any external entity to query Remedy,
except for the 10+ second performance. I wonder if there's any local issue in
my setup that's causing the delay.
--- On Tue, 4/20/10, John Sundberg <[email protected]> wrote:
> From: John Sundberg <[email protected]>
> Subject: Re: How can an external program query to see if a ticket # exists?
> To: [email protected]
> Date: Tuesday, April 20, 2010, 12:57 PM
> setup klink (Kinetic Link)
> http://www.kineticdata.com/Products/KineticLink.html
> (Free/opensource)
>
> then
>
> http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User
> (will give you all record numbers)
> http://skitch.com/johnsundberg/n92y6/mozilla-firefox
>
> http://matrix.kineticdata.com:8081/klink/entry/127.0.0.1/User/000000000000001
> (will give you User record - 1 -- as XML)
> http://skitch.com/johnsundberg/n92bn/mozilla-firefox
>
>
> http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User?qualification='7'=0
> (will give you User records where field '7' = 0)
> http://skitch.com/johnsundberg/n92b3/mozilla-firefox
>
>
>
>
>
> -John
>
>
>
>
>
>
>
>
>
>
> On Apr 20, 2010, at 11:32 AM, Rabi Tripathi wrote:
>
> Hi all,
> I need to provide a way a program can ask Remedy if a
> ticket number exists.
>
> Web services is out (mismatch of Mid-tier and ARS
> versions). I am looking for any other simple solution.
>
> I tried a query with runmacro.exe, hoping i can somehow
> trick it into letting me know if the query matched any
> record or not, but it turns out its not designed to output
> anything to standard output, other than "macro xx processing
> completed".
> I am trying the -o (output to file) option, which may work
> (working on getting the query criteria right), but appears
> to be very slow.
>
> I am considering a Perl script that will take a ticket
> number and simply respond with something like yes or no. I
> will likely turn it into an .exe using perl2exe. We use a
> lot of Perl, but all of it is on the server side and on
> Solaris. This will be the first time doing it on Windows, so
> I wish I could avoid having to open this can of worms to
> build and maintain.
>
> Before I go that route, I want to pick your brain and see
> if I have overlooked any other simple solution.
>
> Thanks in advance.
>
>
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
>
> --
> John Sundberg
>
> Kinetic Data, Inc.
> "Building a Better Service Experience"
> Recipient of the WWRUG09 Innovator of the Year Award
>
> [email protected]
> 651.556.0930
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
> I www.kineticdata.com
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
