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 <john.sundb...@kineticdata.com> wrote: > From: John Sundberg <john.sundb...@kineticdata.com> > Subject: Re: How can an external program query to see if a ticket # exists? > To: arslist@ARSLIST.ORG > 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 > > john.sundb...@kineticdata.com > 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"